I don't think sqlite is meant to be used that way. The locking is at the database level or in the case of "shared_cache" mode the locks are held at the table level. So locking is pretty much nothing or everything approach. If you look at the journal design you'll see it applies to the entire file.
Locking at the row level would be unpractical without a major overhaul. I am not the author, nor a developer. The authors do suggest that if you need row locking or other "heavy weight" DBMS features that there are other DB's availble. --- On Tue, 10/7/08, Steven Charest <[EMAIL PROTECTED]> wrote: From: Steven Charest <[EMAIL PROTECTED]> Subject: [sqlite] Record locking To: [email protected] Date: Tuesday, October 7, 2008, 7:22 PM Are there any plans to put record locking in Sqlite? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
