-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Emerson Clarke wrote: | I am left to assume that all other locking mechanisms like ipc and | files have already been tried and been found wanting. I also assume | that priority has been given to making sqlite operate across network | boundaries rather than process to process (where the locking | requirements would be quite different)
Your assumptions are not quite correct. SQLite was always designed to be a library used within an optionally threaded process. Its sweet spot is low end to mid range. You wouldn't run the New York Stock Exchange on it, but it will work well on an MP3 player with memory measured in kilobytes. It has no external requirements like a daemon for coordination and control. IPC is difficult to work with when processes are unrelated. It does use file locking - see the various os_*.c files in the source. SQLite knows absolutely nothing about networks. In theory the file locking will work on files on a networked file server, but in practise the various network file protocols and their implementations often have problems getting their native locking functionality correct. See http://www.sqlite.org/faq.html#q7 Some people have proposed a networked version of SQLite and some even sell products. None of these are a standard part of SQLite. http://www.sqlite.org/cvstrac/wiki/wiki?p=ClientServer http://www.sqlite.org/cvstrac/wiki/wiki?p=SqliteNetwork | Im not familiar with DB/dbm/gdbm, are any of those under a similar | license to sqlite and or as easy to use and simple ? :) http://en.wikipedia.org/wiki/Gdbm http://en.wikipedia.org/wiki/Berkeley_DB They effectively use fixed size records and have no SQL layer. The Berkeley DB variant should allow the concurrency you want. Version 1 of SQLite was actually just a SQL layer over the GNU variant, gdbm. http://www.sqlite.org/cvstrac/wiki?p=SqliteHistory Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFFlmGomOOfHg372QQRAkKTAKDTOAt+jz/bEG0BmwJ9ZrOajOB3ZQCgjKUi qghWqZISU+h6i+S3nAr2R6E= =8BoZ -----END PGP SIGNATURE----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
