What abilites have firebird to use it in highloaded projects? Whats better PostgreSQL or FireBirdSQL? Any one know big projects which work with Firebird database and developed over it?
Firebird is a relational and open source database that provides many SQL and ANSI features that are able to perform on Windows, Linux, and several UNIX platforms. Firebird provides excellent concurrency, powerful language support, and high performance support for stored procedures and triggers.
Firebird itself takes no precautions to provide external security. Once a person has physical access to a database file there is no effective way to prevent that user from reading all data (and metadata) within that file.
Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers.
Firebird is an open-source SQL relational database management system that support Linux, Microsoft Windows, macOS and other Unix platforms. The database forked from Borland's open source edition of InterBase in 2000 but the code has been largely rewritten since Firebird 1.5.
Both Firebird and PostgreSQL are good choices. I think 'better' is highly subjective and not easy to answer for such a broad and unspecific question. The case-studies on firebirdsql.org lists some projects that might be of interest to you.
It is however important to keep in mind that performance in general depends largely on the way your system interacts with the database, transaction management (and transaction configuration), underlying server etc.
Full disclosure: I am a developer of the Firebird JDBC driver, so I may be biased :)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With