My database is shared by many users on a network. As part of auto-updating my client applications via the web it might be necessary to alter some table structures / view sql or put extra data into tables inside the shared sqlite database. Problem is that the db might be in use at the time.
Qn1) Is it safe simply to wrap up everthing I want to do in a transaction and then commit the transaction? Q2) If I back up the database first using the online backup to safely back it up, how do I safely restore it again when the db might be in use at the time? I'm using DISQLite and the online api in delphi, not the command line thing. Howard -- View this message in context: http://sqlite.1065341.n5.nabble.com/How-to-restore-from-backup-or-alter-db-in-multi-user-envionment-tp65812.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
