Dr. Hip, As I stated before, I do not have a detailed understanding of the core source. Therefore I do not know how difficult or even possible adding a pragma controlled(?) finer grained locking "hook" or related API calls for those who might wish to "wrap" a server layer around the core.
SQLite has proven to be a very fast, small, reliable, and bullet proof DB engine, for a single instance. I prefer to keep it true to its heritage. My real motive for the locking solution and API's would be to take the multi user pressure off the core. Leave us that want it to remain small, fast, and tight, a core that can either be used as is or embedded in a bigger picture. Fred -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of D. Richard Hipp Sent: Monday, September 21, 2009 8:14 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Most wanted features of SQLite ? On Sep 21, 2009, at 8:58 AM, Fred Williams wrote: > > Fine for me. It seems to be everybody else that wants their favorite > feature imbedded in the core :-) > > Fine grained locking would be a great "asset" I feel. Notice I did > not > request a "feature." On my to-do list is to write a paper that explains why fine-grain locking is not practical without either (1) a dedicated server process to manage the locks or (2) enhancements to OS locking primitives that are not currently available on any OS that I am aware of. There is a widely held belief that since OSes provide byte-level locking of files it should be a simple matter to provide row-level locking in a serverless database engine. The proposed paper will explain why that belief is incorrect. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
