Paul Rubin wrote: > Peter Hansen <[EMAIL PROTECTED]> writes: > >>And PySQLite conveniently wraps the relevant calls with retries when >>the database is "locked" by the writing process, making it roughly a >>no-brainer to use SQLite databases as nice simple log files where >>you're trying to write from multiple CGI processes like the OP wanted. > > Oh, ok. But what kind of locks does it use?
I think the FAQ can answer that better than I can, since I'm not sure whether you're asking about any low-level (OS) locks it might use or higher-level (e.g. database-level locking) that it might use. In summary, however, at the database level it provides only coarse-grained locking on the entire database. It *is* supposed to be a relatively simple/lightweight solution compared to typical RDBMSes... (There's also an excrutiating level of detail about this whole area in the page at http://www.sqlite.org/lockingv3.html ). -Peter -- http://mail.python.org/mailman/listinfo/python-list