@Jack K It requires practically zero admin which is not true of postgresql..
From my experience I think Firebird is as close to a zero-admin RDMS as it's possible to get.
@Jack K It can work in embedded mode just like Sqlite but with far superior support for official SQL standards, e.g right join. It can function as a server database just like Postgresql. So if you want to provide a solution that may start out as single user but later scale it is ideal.
Yes, and you can also choose between a multi-threaded or multi-process server, the former being faster the latter being more robust. When Firebird 3 arrives the embedded server will be unified with the client library so I imagine going from single user to client/server could be as easy as changing the connection string.
@LouisDesjardins I once looked at Firebird, and abandoned the option because the product was near dead. It would now seem to be resurrected.
For a long time the Firebird Foundation didn't do themselves any favours with their fusty old website. That's now, thankfully, had a refresh. I don't think the project itself was ever near death.
@Paul R Last point, neither Oracle or SQL server run on MacOS. Oracle runs great on Windows or Linux, and SQL Server runs only under Windows. That tends to mean you need to run the database server on a virtual machine dedicated to the task, or on a spare machine if you happen to have one
Firebird runs on lots of platforms:
OS: Windows, Linux, MacOS, FreeBSD, HP-UX, AIX, Solaris and more...
Hardware: x86, x64, ARM, PowerPC, Sparc and more...
e.g. Want Firebird on your Raspberry Pi (ARM+Linux)?