Linq on MonoDroid

I love this post so when it is possibile I modify the original source code on various environment.

I do it on GTK, Sugar (OLPC) and maemo.

Now I realize the same thing on Android platform using Monodroid.

Here there are the source code and screenshots follows:

PgDroid updated.

PgDroid, a software to access postgresql databases from android devices, is update in order to compile with MonoDroid preview 14.

Moreover the Npgsql postgresql driver is moved to a separate project file.

Now you can download the Npgsql postgresql driver for Android from here and use in your code without the necessity to get PgDroid code.

Any suggestions about how to improve PgDroid are welcomed.

Best Regards

PgDroid part 2, PostgreSQL db from Android device using Monodroid and Npgsql

News from PgDroid project: - it is possible write and executes a generic SQL query from the device. - "connection list" function is added. With this function you are able to see any database connection and, if you are connected as administrator, you are able to terminate it. In a future I hope that will be possible for database owner kill sessions to own database. The source code can be found here. Any suggestions will be appreciated.

  

 

PgDroid, access to PostgreSQL db from Android device using Monodroid and Npgsql

Finally PgDroid (PostgreSQL from Android), an application to test PostgreSQL db access from android device using Monodroid and Npgsql seems to work. Actually give me the list of Tables, Views, Indexes and Sequences of any postgresql DB. Next step are adding some "Administrative tool" and the capability for the user to write an own SQL command.

To do: - publish in an open repository - more useful functions - ......

Any suggestions will be appreciated.

Ops.... Some screenshot are needed:

Mono 2.4.3 and WinForm on Maemo device

Today I spend some time to make some test using a real winform application on my N810 device. This application use a config file, a socket and a nontrivial winform interface to show the status of specific software server. This interface use tab pane dock to the full window, a detaililed list, and change the color of the row when a specific process is in running. I simply copy the binary from the windows server to my OpenSuSE linux machine and on my N810 maemo device. On OpenSuSE I have no problem with the latest version of mono. On Maemo device I not able to run the release version of application, so I try to run the Debug version with the "--debug" option. Now the application start perfectly. Here there is some screenshot taken from Windows, OpenSuSE and N810 :)

Window Platform

Linux Plaform

Maemo4 on N810

Mono 2.4.3 on Maemo devices

After long long time I find some freetime to spend to update mono for maemo devices. After a lots of work, at the end I able to compile mono 2.4.3 for the maemo devices. Here you can find the instaction to compile mono for maemo. This instruction are refered by Maemo5 but work also on maemo4 and maemo4.1. I test it only on maemo4.1 device (I have N810 device but unfortunally not a N900 one). Here a the output of "mono --version" from a terminal:

Nokia-N810-23-14:~# mono --version
Mono JIT compiler version 2.4.3 (tarball Sat Feb 27 22:09:03 CET 2010)
Copyright (C) 2002-2008 Novell, Inc and Contributors. www.mono-project.com
    TLS:           normal
    GC:            Included Boehm (with typed GC)
    SIGSEGV:       normal
    Notifications: epoll
    Architecture:  armel,soft-float
    Disabled:      debug,large_code,logging,com

FsGateway - access to Sugar Datastore

FsGateway is a Mono application that allows to mount several entities as a filesystem using mono-fuse. Now we see the sugar_datastore module.

sugar_datastore module

This module allows mounting a Sugar Datastore storage as a filesystem. This way you can access to your document created using Sugar. Tags are shown as directories in the exported filesystem. You can open a Write document by simply double-clicking on it, and Open Office will be opened.

To do this, simply run the application specifying the filesystem type (sugar_datastore), the location where your data is stored (in this case datastore_sample) and the mountpoint (in this case mountpoint/):

mono --debug fsgateway.exe sugar_datastore datastore_sample mountpoint/

Now you can use your preferred file manager such as Nautilus or Dolphin to see the content and open each object with a double-click:

Here some snapshopt:




Since the datastore is read scanning the storage directory without using the datastore internal storage capability, data is read-only. This is done by the module, changing this behavior is very easy.

Obviously, you can open a SoaS datastore using this step:

• become root (unfortunately)
• plug in your SoaS in the USB port
• create a working directory (e.g.: //mkdir ~/soas_datastore//)
• mount the home partition with loop option (e.g.: //mount -o loop /media/disk/LiveOS/home.img soas_datastore// )
• mount the datastore stored inside it (e.s. //mono --debug fsgateway.exe sugar_datastore ~/soas_datastore/liveuser/.sugar/default/datastore mountpoint//)

Of course, you can try the "allow_other" FUSE option to allow other users to access to the datastore.