Re: SQLite vs Firebird vs ...

[stefbv]

I have a long time experience using Firebird, more than 10 years, and I can say that it is very stable even on Windows XP. It is also robust, easy to install and use, there is a good DBD module for it (DBD::Firebird) and there is also a good administration tool named Flamerobin.

I use it with small databases, but I see that is also your intent so I have no reason not to recommend it.

Regards Stefan.

Update: This doesn't mean it can't handle large databases, it just means that I don't have experience with large databases.

[mapopa]

I agree with what Stefan has said above Firebird is very robust on Windows but also on Posix systems and is used in large scale applications

Firebird on Large Big Iron servers : 512G-2TB of ram 100.000 users http://www.firebirdnews.org/?p=6797

Where firebird shine is embeeded mode also : full multithreaded and is easy to carry around with you

DBD::Firebird does have support for embedded mode Damyan created some of the test to run with embedded mode

The dabatabase that is to be used in LibreOffice Base is Firebird Embedded and the reasons are that Firebird is lot more powerfull than sqlite and a lot faster and easier to deploy/integrate than other databases https://wiki.documentfoundation.org/Development/Base/FirebirdSQL

[sedusedan]

Thanks for sharing.

Do you use it with a multithreaded program?

I'm particularly interested in startup/connection speed, though I'll be doing some benchmarking myself later on.

[stefbv]

No, not with a multithreaded program.