There is a PalmOS port of SQLite available. Mr. Taylor on this list kindly sent me the code of his work on the Palm port. I have not tested it on Palm Vx but I do believe it works(Mr. Wayne can correct me if I am wrong). I am working on Palm OS 6 port of SQLite but haven't been able to get far as my dev machines either keep crashing (for some totally different reasons) or they get utilized for something else. When will I be able to complete the port is an eternal question ;-) Let me know if you need the code.
I think it is a good idea to put the code and put a link in wiki as Puneet Kishor said. I have Palm OS 3.5 Do you think sqlite may work fine?
Thanks
With regard to the code that I ported for the Palm OS...
All worked well with a minimal test application but when I put in into my full size application the SELECT statements ran very slow under Palm OS 5 and would not run at all under Palm OS 3.5 due to insufficient memory and stack space. I have a few ideas about how to get around the limitation imposed by the Palm OS but I just have to find the time to try it out.
Another potential problem has to do with indexes and hotsynch'ing but that one is fairly involved.
-- Warren Taylor, B.Sc., Taylor Software Inc. mailto:[EMAIL PROTECTED] http://www.taylorsoftware.ca/