B4J Question SQlite file update

[derez]

When a server runs an SQL Database and updates it during interface with users, when a user downloads the DB file from the server, does the file include all the updates ? In other words, does the server updates the file on which it was initialized while it is still in work ?

 

[Daestrum]

If I understand your question correctly, you have a database that is in use. A user downloads the database file whilst it is still in use. Does it contain all the information that the original file contained?

The simple answer is 'possibly most of it' ,depending on the server, you may have indexes which have not been written/updated, also entire transactions may be missing, due to the database software using delayed writes to disk for indexes and records. It won't contain any transactions that are in progress when the copy is taken.

 

[derez]

It won't contain any transactions that are in progress when the copy is taken.

If I download the file 2 minutes after the last update had been done - will it be completely updated ?
.

 

[Erel]

Are you asking about SQLite?
1. Make sure that there is no active transaction when you download the database.
2. Download the journal files as well as the database file (if such are available).

 

[derez]

Thank you