Development For Gui+db?

[netog]

Hi:

I have a C1000 with cacko 1.23 ROM
I need to develop some applications for my work. My main requirements are:
-GUI
-Database sync with my mysql 4 DB at office (Dump of about 2 MB of data)
-Mostly is used to read queries (selects), not much inserting or updating

I think I have some choices:
-Qt/C++ : It should be the fastest for GUI(?), but I do not know if it could be easy to work with mysql in the zaurus. I have not found any C API for it yet.
- Java AWT/JDBC : I have used JDBC to integrate a java app with mysql 3.23 in the zaurus with no problem. But I do not consider AWT a nice tool for GUI.
-PHP/Mysql: I can run apache+php+mysql. But I guess it will not be fast, and using client/server tech in my PDA is not a good architecture practice...But I think it could be the easiest way to do it...

So... what do you think about this? Any experience developing your own apps?
Should I use mysql 3.23 at the zaurus if I want to sync with mysql 4 at the office?
What is your choice to develop at desktop?

Thanks for your suggestions.

[ThirtyOne]

I haven't done any mysql work with it yet, but so far python is my favorite language for developing on the Z.  With Cacko you can use PyQT for gui.  I will try a little SQL proof-of-concept just to make sure.

Also, stay away from java on the zaurus - it will bring you heartache.

[netog]

I haven't done any mysql work with it yet, but so far python is my favorite language for developing on the Z.  With Cacko you can use PyQT for gui.  I will try a little SQL proof-of-concept just to make sure.

Also, stay away from java on the zaurus - it will bring you heartache.
[div align=\"right\"][a href=\"index.php?act=findpost&pid=106881\"][{POST_SNAPBACK}][/a][/div]

OK. I gues I might try to look at PyQt as well. I have no experience with Python, but I can learn quickly  
Using the python 2.4 image?

[ThirtyOne]

I use pdaxrom but it looks like the kopsis image will work with Cacko and has everything you need (see the python forum).

I have used lots of languages (C/C++, Java, Perl, PHP, VB, C#, etc), and I was able to pick up python/PyQT and be proficient building gui applications in a couple of days.