in reply to SQLite vs Firebird vs ...

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.

Replies are listed 'Best First'.
Re^2: SQLite vs Firebird vs ...
by mapopa (Acolyte) on Sep 13, 2013 at 05:52 UTC

    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

[reply]
Re^2: SQLite vs Firebird vs ...
by sedusedan (Pilgrim) on Mar 12, 2013 at 16:39 UTC

    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.

[reply]

      No, not with a multithreaded program.

[reply]

In Section Seekers of Perl Wisdom