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.
