On 3 Dec 2015, at 10:17am, Murdare, Vijaykumar S (GE Oil & Gas) <vijaykumar.murdare at ge.com> wrote:
> 1) If read operation is in progress, then can I take backup safely with > file copy or any other third party tool? When taking a backup of the database file you should also copy all other files with similar names in the same folder. So suppose your database name is 'mydatabase.sqlite'. You should either copy every file in its folder or use a technique which will include also mydatabase-journal.sqlite mydatabase-wal.sqlite mydatabase-shm.sqlite Including mydatabase-*.sqlite or even mydatabase*.* will create no problems and may help to future-proof your procedure. Doing this will aid in automatic database recovery should either of the following occur: 1) A backup is accidentally taken while one or more apps is engaged in a database operation. 2) A backup is taken after an app crashed while it had the database open, before the database was opened again to automatically recover the best available data. As Dr Hipp replied to your second question, since SQLite has no client/server architecture, there is no delay on writes to the database. Simon.
