Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Firebird usage in big projects [closed]

Tags:

firebird

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?

like image 875
DefacedVR Avatar asked Nov 23 '11 13:11

DefacedVR


People also ask

Is Firebird a good database?

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.

Is Firebird secure?

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.

Does Firebird use SQL?

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.

What is InterBase Firebird?

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.


1 Answers

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 :)

like image 197
Mark Rotteveel Avatar answered Oct 04 '22 04:10

Mark Rotteveel