Just curious, because I don’t know, Postegres is all the rage, MySql is the og, where does Firebird carve its niche?
My favorite anecdote relating to Firebird/Interbase (its original name) is that it is supposed to be renowned for its durability (i.e. resistance to corruption) and fast start times.<p>Because of this, they used it within the internal systems of the M-1 Abrahms tank.<p>Apparently when the main gun is fired, it gives off such a powerful energy impulse, that there is (at least was) a tendency for it to crash the internal systems.<p>So, they adopted Interbase because of its ability to work well in an environment where hard computer crashes are more a norm than an outlier.
These days, feature-wise, it's probably somewhere in the middle. It had support for things like window functions long before they became available in MySQL and friends.<p>What it gives you over both is single-file databases which are easy to share, and in-process embedded mode, just like SQLite.<p>Unlike SQLite, it doesn't only support embedded mode, but can also be turned into a "server" DBMS that supports remote access from multiple clients (like MySQL/PostgreSQL). Hundreds of concurrent connections work fine from what I've seen. This can be changed in either direction at your discretion, the database file remains the same.
> Postegres is all the rage, MySql is the og<p>From "influencers" i.e. YouTubers?<p>OG real world was Oracle and SQL Server.