Tom Lancaster wrote: > > i'm considering using sqlite as a replacement for sql server ce in a > mobile device that periodically syncs with a web server.
It's the right thing to do. I did it and everything's working just fine! > I wish to use sqlite because I will be able to assemble the whole new > database for the mobile device on the web server and send it back in > its entirety. > > What I would like to know from others who might have experience is: > > would I need to restart my mobile application in order to see the new > database. No, the only thing you have to do, is to disconnect from the database file, update it with the new one and reconnect. > I ask because sqlite is an embedded thing rather than a database > server; perhaps data is cached in-memory. By disconnecting from the database, the file is closed, so the system flushes all cached data. -- Stratos Nikolaidis Thessaloniki, Greece _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
