OESF Portables Forum

Everything Else => General Support and Discussion => Zaurus General Forums => Archived Forums => Software => Topic started by: stahlrosen on February 16, 2004, 06:34:12 pm

Title: picoSQL or HSQLdb on Z 5600?
Post by: stahlrosen on February 16, 2004, 06:34:12 pm

Hello, just wondering if anyone was using either picoSQL or HSQLdb and if they liked them, or prefered one over the other, or if there is something better on the Z? Any comments would be appreciated.

Title: picoSQL or HSQLdb on Z 5600?
Post by: Tehas on February 16, 2004, 08:46:59 pm

Haven\'t tried either but I am using SQLite and it\'s working out great.  I have the JDBC libs set up too so that I can reference the DB from Java.

Title: picoSQL or HSQLdb on Z 5600?
Post by: stahlrosen on February 16, 2004, 09:14:42 pm

So it is working well for you? What are you using it for? (in general) Is it compatable enough with MySQL that I can dump the info on the desktop and have the database sync ok? Do you have it installed on a CF card or internal? (I\'d prefer to put it on a CF) Thank you very much for the reply!

Title: picoSQL or HSQLdb on Z 5600?
Post by: Tehas on February 16, 2004, 09:31:55 pm

Yes, it\'s working great.  The first time that I had exposure to it was when I installed the NFDB (Nutritional Food Database).  The author said that it was using SQLite as it\'s DBMS.

I wrote a small, Java application for entering and referencing quotations and sayings.  I wanted a DB that didn\'t require the user to fire up a DBMS in order to use my application.  SQLite is different from MySQL in that it does not require a DBMS running in the background to support SQL calls.  When installed, it loads libs that applications can use for accessing the databases which are actually individual files.

Yes, I was able to export data from a MySQL database on my server and load it into a SQLite DB.  I created a query in MySQL that generated INSERT statements and piped them to a text file.  I used the text file as a set of commands to load the DB.  

Synching - I have not tried any synching.  AFAIK, SQLite does not expose any ports like MySQL does so I\'m not sure how you\'d synch with another machine unless you wrote an app on the Zaurus that open an SQLite DB and then contacted the server running MySQL.

Installation:  Since libraries are installed, I think that it has to go to Internal Storage.  The database files can be on any medium, I have mine on SD.

I\'m also running MySQL on the Zaurus but that\'s mostly for experimenting and playing.