write to the same file from multiple processes at the same time?

[Paul Rubin]

Peter Hansen <peter at engcorp.com> 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?