On 6 Dec 2011, at 9:58pm, Jos Groot Lipman wrote: > At some point (idle?) the readers should close the database connection and > you must make sure any new connection starts to the new database?
Right. One way to do it is to have a table in the database used to point to the next database. Normally that table has zero rows in it. You can check it with SELECT COUNT(*) FROM databaseObsolete when an entry does appear in it the count switches to 1. If your operating system supports aliases/shortcuts/links you can change one of them to point to whatever file is the current database file. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users