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:

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.

OLPC under the Tower Eiffel - video, slide and pictures from the event

The French guys have published a lots of material from the CodeCamp on OLPC. Here you can find a lots of material about this event including some pictures and my presentation about to use the XO datastore from Mono and C#.

OLPC and MONO under the Eiffel Tower

Hi guys, OLPC France will organize a OLPC CodeCamp in Paris on November 15 th. Five workshops are planned: Sugar, Localization, Pedagogic Usage, School Server and… Development of new activities using Mono. OLPC is one of most ambitious education project, it’s cool to have opportunity to use Mono on it. I will join with this guys, and you? You can find here some useful link:here and here. This news is also published by olpcnews. You can find the full article here. Best Regards.

Mono on OLPC (One Laptop Per Child) device update

Hi guys, A new official version of the XO Operating System is came out some days ago, the 767 build. Unfortunally the mono activities doesn't work on this environment. After some work to understanding the problem (because if I try to run it from Terminal activity using sugar-launch it came up) the bug is now fixed. The problem was related to the rainbow security model implemented on XO. This version of rainbow do not create the standard input and output file handles so the application hang-up. To fix it you need to modify the script that launch the activity to add a redirection from and to /dev/null. After this you have your activity ready to run again. Here you can see the wiki page on laptop.org with the script updated. Happy hacking

Mono on OLPC (One Laptop Per Child) device update

Hi guys, several months went by without any post, but I didn't remain idle. During this time I made a lots of things but now I'm glad to post an update to sugar-sharp. This update will let you to use the datastore service that Sugar makes available to store your data. The datastore data are used by the Journal and can be integrated with the school server. This version is a very low-level API because it's a one-to-one mapping with the DBUS services. In the next version I will create a new class to allow you an easier way to access to the data on the datastore. Any suggestions are welcomed. You can find the instruction about compilation of mono here, and here you can find the source code. Happy hacking to all

GBrainy for OLPC v0.50

Hi everyone, my little contribution to the OLPC and Mono is not finished yet, so in the last days I tried to port the new version of GBrainy to the OLPC Device. GBrainy is so nice that the OLPC version needs to be updated. You can find it here. The original web page can be found here. Thanks to Jordy Mas for the original code.