Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms.
Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms.
Customer Reviews
Wojciech Z.
Advanced user of FirebirdSimplicity (Portability, Management) and Efficacy. I like also compliance of ASNI standards for SQL. It is easy to get a snapshot, just stop database engine, copy a file and start database service one again. Managment is as simple as it could be. There is one tool for user management, other one to backup and restore a database. It is very flexible, powerful database engine and it doesn't use much of system resources. I hope You take this into consideration.
Efficacy problem with large volume of data (above 3-4GB), poor recoverability after database corruption. I don't like the archives incompatibilities between 2.x and 3.x branches. I also dislike a lack of window function in 2.x version. I would be great if there is official database explorer like SSMS or SQL Developer. I also feel lack of server linking technology to connect multiple cross-platform database to firebird.
It's great on premises database for all of propose if only You don't need to store more than a couple of GB per one datafile. I works with many RMBDSes but I belive that Firebird is unique and worth of using in every inch. I advise You to give a chance to Firebird becuase if You start use it, You would love it :)
I use Firebird mainly as database behind selling and storage system for Pharmacies. The second possible database engine for this application is Oracle but I prefer using Firebird. I also write SQL statements for data extraction from OLTP Pharmacy's databases.