TQuerci's WebLog

Linq on MonoDroid

2011-03-25T02:57:00.000-07:00

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.

2011-03-17T02:19:00.000-07:00

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

2011-03-04T05:20:00.000-08:00

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

2011-02-02T05:53:00.000-08:00

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

2010-03-23T02:43:00.000-07:00

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

2010-03-13T01:39:00.000-08:00

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

2009-07-04T23:32:00.000-07:00

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.

FsGateway: looking inside an XML file as a filesystem.

2009-06-15T01:30:00.000-07:00

FsGateway is a Mono application that allow to mount several entity as a filesystem. To do this one mono-fuse is used. Actually when you need to start the fsgateway you need do specify the filesystem type and the mountpoint. Now will describe the use of xmlfs "module". This module allow to mount a XML file into the normal filesystem. To do this simply run the application specify filesystem type (xmlfs), an XML file (in this case ~/mono_sugar/xml/xml/xml/bin/Debug/test3.xml) and the mountpoint (in this case mountpoint/):

mono fsgateway.exe xmlfs ~/mono_sugar/xml/xml/xml/bin/Debug/test3.xml mountpoint/

Now you can use your preferred file manager like nautilus or dolphin to see the content and open each node like a file: If you run the "find" or "grep" utilities, the file name that you get contains the XPath query to access the node. For example:

find mountpoint -iname "*md5*"

give this result for the file that I specify:

mountpoint/def:metadigit/def:img[1]/def:md5 mountpoint/def:metadigit/def:img[1]/def:altimg[1]/def:md5 mountpoint/def:metadigit/def:img[1]/def:altimg[2]/def:md5 mountpoint/def:metadigit/def:img[2]/def:md5 mountpoint/def:metadigit/def:img[2]/def:altimg[1]/def:md5 mountpoint/def:metadigit/def:img[2]/def:altimg[2]/def:md5 mountpoint/def:metadigit/def:img[3]/def:md5 mountpoint/def:metadigit/def:img[3]/def:altimg[1]/def:md5 mountpoint/def:metadigit/def:img[3]/def:altimg[2]/def:md5 mountpoint/def:metadigit/def:img[4]/def:md5 mountpoint/def:metadigit/def:img[4]/def:altimg[1]/def:md5 mountpoint/def:metadigit/def:img[4]/def:altimg[2]/def:md5 mountpoint/def:metadigit/def:img[5]/def:md5 mountpoint/def:metadigit/def:img[5]/def:altimg[1]/def:md5 mountpoint/def:metadigit/def:img[5]/def:altimg[2]/def:md5 mountpoint/def:metadigit/def:img[6]/def:md5 mountpoint/def:metadigit/def:img[6]/def:altimg[1]/def:md5 mountpoint/def:metadigit/def:img[6]/def:altimg[2]/def:md5 mountpoint/def:metadigit/def:img[7]/def:md5 mountpoint/def:metadigit/def:img[7]/def:altimg[1]/def:md5 mountpoint/def:metadigit/def:img[7]/def:altimg[2]/def:md5 mountpoint/def:metadigit/def:img[8]/def:md5 mountpoint/def:metadigit/def:img[8]/def:altimg[1]/def:md5 mountpoint/def:metadigit/def:img[8]/def:altimg[2]/def:md5

The same way, if you run "grep" you get the same behavior. For example:

grep -ril piccolo mountpoint/

gives as result:

mountpoint/def:metadigit/def:bib/dc:description/text()

You can find the source code here. Note: the def prefix is automatically added by the module for the default namespace. If this prefix is already used, the module use def2, or def3 ... and so on.

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

2008-12-05T08:58:00.000-08:00

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

2008-11-12T13:57:00.000-08:00

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

2008-10-29T22:22:00.000-07:00

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

2008-07-23T04:37:00.000-07:00

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

2008-01-18T01:27:00.000-08:00

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.

Mono on OLPC (One Laptop Per Child) device

2008-01-03T04:57:00.000-08:00

After a lot of time I'm finally releasing the first version of Sugar assembly to "sugarize" a Mono application. This assembly is needed to integrate a Mono application with the Sugar environment so it can run on an OLPC device. This version allows creating applications that use GTK# forms created programmatically or by a Glade resource file. Additional work remains to be done to support new widgets and integrate with Journal/Datastore to enable using all of the OLPC resource. A specific wiki page has been created on laptop.org wiki at this address. I have ported two applications to the OLPC device: GBrainy and MonkeysMemory. The first application is an interesting application to "improve" your brain, while the second one is a simple "Memory" game that I wrote to play with my children. Again I created some specific wiki page on laptop.org wiki, one for MonkeysMemory and one for GBrainy. Here are some screenshots to see these applications (oops, activities) in action:

How to write a standalone program (part 3)?

2007-12-16T13:04:00.000-08:00

When I was deciding which library to use for developing my application, I was in doubt between GTK and WinForm. Back then, the WinForm was not so good, so I tried to use the GTK# for both the Win32 and Linux platforms. I had a lot of problems because I had to put a widget in a specific position and I needed to make a lot of experimentation to understand how to layout the GTK widgets. In the next project I did, the WinForm API became more stable, so I decided to use it. Again, I found a lot of problems but the program is now finished. The difference between the two class libraries? Personally, I prefer GTK# because is very powerful and flexible. Unfortunaly, on the Windows platform the look is not so good as on the Linux platform, and the need to include the GTK library for Windows increases the space requirements and the startup time on the CD-ROM media. Using WinForm, the application requires less disk space, but under Linux the interface looks alien.

How to write a standalone program (part 2)?

2007-12-06T15:02:00.000-08:00

Hi, now you can look on some screenshot taken from linux and windows system.

The first sequence of image is taken from Linux system.

This other sequence of images is taken from Windows System

How to write a standalone program?

2007-12-06T13:33:00.001-08:00

Several years ago I write some program to be run on Windows machine. This programs need to be run from CD so no installation program can be used. At this time the mail solution are two: use Visual Basic or Director. I am mainly like to have the full control of my program so prefer to use Visual Basic. Several month ago e new customer ask to me to realize a CD to put in a book. Now, which development tool use this time? In fact in the last year I'm developing web application using mainly PHP and JSP on linux platform. Again, which development tool I can use to do this? So I give a look about the old Visual Basic plaftorm. Ok the old Visual Basic is dead, and it evolve to VB.NET while Director I never use before so why use it now? So give a look to VB.NET. Ok, seems to be very interesting and powerful .... but there is a LITTLE problem ...... to run the program the virtual machine need to be installed on machine and this is not a good thing for this type of application .... So, no solution? No, of course. From several month I start to look inside MONO, an open source reimplementation of .NET Virtual Machine. In this environment I can create a standalone program using mkbundle utility shipped with mono. Using this solution you have a program that can be run where mono runtime is supported (almost everywhere) and can be transformed on a standalone program for the target that you need. In my case only windows. This utility generate a C program that include all the library needed to start the mono runtime without need to install on the computer. I listen you, and to get the data used by the application? In the past you can store you data inside the program as resource or use a MDB file. Obviously this solution is not portable so I make some test using sqlite to manage the data. This solution is high portable because sqlite is available everywhere. But, it works? Sure, after I post some snapshot taken from Windows and Linux.