[Python-Dev] pysqlite for 2.5?

[Greg Ewing]

Fredrik Lundh wrote:

> not according to the documentation (which says that the embedded library locks
> the database file, to prevent other independent processes from accessing the data).

I think that means other *non-Firebird* processes.
Firebird itself uses a system of file locks and
transactions to manage concurrent access by different
Firebird applications.

Just to make sure I wasn't imagining things, I ran
two instances of a program of mine that uses Firebird,
without server, accessing the same database, and
both worked fine. They can independently access different
parts of the database, and if they try to update the
same part at the same time, deadlocks are reported
as appropriate.

On the whole I'm very impressed with Firebird. I've
found it to be nothing less than sleek, efficient,
powerful and reliable. I'd encourage anyone looking for
a database, embedded or otherwise, to give it a go.

--
Greg