In the past, my company had an experience with a product called InterBase. InterBase was a good tool with which I never had any issues.

We worked with MySQL, and before that, we used Oracle. We still use Oracle for certain other solutions, but not for this specific requirement of our database. So, our expertise lies in this particular aspect of databases.

PostgreSQL has crossed our minds. Currently, we are evaluating whether we should make the switch or continue with Firebird. Another option we are considering is using Oracle because they also have a free solution for a certain amount of data. I don't know the exact limit, but it's something available for free, but it tends to use more resources compared to Firebird.

Firebird can compete with well-known names like Oracle and SQL Server when you don't have more than a few hundred thousand users.

It's a level below SQL Server, and the application of SQL is a kind of database you can rely on for situations where you don't have too much information to deal with.

For example, you can use it for the internet or national projects, but when you have millions of users, then it's not possible for other services.

InterBase was our first database management system, and we still use it. However, we extracted some parts in the Firebird SQL database. The main advantage of InterBase over Firebird SQL is that it is much faster. InterBase has these just-in-time dumps. I don't know if Firebird SQL has these dumps by now. Earlier versions of Firebird SQL could do backup and restore, but they didn't have just-in-time dumps.

InterBase has a journaling feature, and I don't know if Firebird SQL has it. The advantage of Firebird SQL over InterBase is that it is an open-source solution and not proprietary.

I used a relational database before. When Firebird SQL was released as an open-source solution, I used it because it cost nothing.

We currently use Firebird as well as Microsoft SQL Server. The performance and scalability of Microsoft are much better, but it's a more expensive solution of course because it's a commercial license.