On Fri, Aug 1, 2008 at 5:49 PM, Στράτος Νικολαΐδης <[EMAIL PROTECTED]> wrote: > 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! >
Good to know. >> >> 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. > Great! That's what I needed to know. Thanks. Tom > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users