[EMAIL PROTECTED] wrote:

but... I want try to ask again...  ;-)

SQLite handles the File-Lockings as a physical Locking during the writings to File and Disk. (Is it so?) I do my own logical Locking during the Edit of a Record and then reflect to the Busy-State if the changes will be saved to disk. The different point of views are intended from a logical Lock during Edit and a physical Lock during storing the Data to Disk. A logical Locking can hold it for a long time, several minutes, to a hour ... so long the user need to hold this Record for Editing. But there is during
editing no affect to DB. This will done very well in my Logical-Locking-
Concept. The physical File-Locking needs only milliseconds, even to write changes to Disk, if DB Ready and not Busy. Now then...if the User-Edit endet, the changes will be saved to File and written to Disk, and that is controlled bei File- Locking through SQLite, so that multiple Diskwritings to one DB do not end in a collision.

Is that accurately described?

Anne,

Yes, your description is correct. SQLite does what you are calling the physical locking, and your application will have to do the logical locking itself. SQLite will help with the logical locking by providing physical locking that will prevent two users from updating the database to acquire the same logical lock. SQLite's physical locking will ensure that only one application instance can write to the database to either acquire or release a logical lock. As long as all your applications use and respect your logical locks, then this scheme should work well.

HTH
Dennis Cote

Reply via email to