Firebird Relational Database.
Firebird is a relational database that offers many ANSI SQL-99 features. Firebird is high performance and has powerful language support for stored procedures and triggers.
The Firebird server is available in three flavors:
- Super Server
You can start with SuperServer. Classic is recommended for use with SMP machines and certain other specific situations. SuperServer shares its cache among database connections and uses threads to handle each connection.
Classic launches an independent server process for each connection.
The software comes with a complete set of command line tools that enable users to create databases, retrieve database statistics, run SQL commands, miscellaneous scripts, perform backup and restore.
To enhance the Firebird functionality, IBSurgeon has sponsored the development and now released for public use the free open source "IBSurgeon Full Text Search UDR" to perform full text search queries within SQL and PSQL. UDR works with Firebird 3 and 4, for Windows there are ready-to-use binaries, for Linux it is necessary to build the UDR.
The UDR is based on Lucene++ engine, with all the powerful features required for full text search and with very fast performance (build as native C++ library).
Alternatively, for users who prefer to use a GUI (Graphical User Interface) frontend, there are many options to choose from, including free.
Firebird is used with many large databases and most connections. It has been used on production systems under several different names since 1981, making it a very mature and stable application.