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 a fully featured and powerful RDBMS. It can handle databases from just a few KB to many Gigabytes with good performance and almost free of maintenance!
Below is a list of some of the Firebird's major features:
- Full support of Stored Procedures and Triggers
- Full ACID compliant transactions
- Referential Integrity
- Multi Generational Architecture
- Very small footprint
- Fully featured internal language for Stored Procedures and Triggers (PSQL)
- Support for External Functions (UDFs)
- Little or no need for specialized DBAs
- Almost no configuration needed
- Large user community
- Optional single file embedded version
- Dozens of third party tools
- Careful writes - fast recovery, no need for transaction logs!
- Many ways to access your database
- Native support for all major operating systems
- Incremental Backups
- 64bits builds available
- Full cursor implementation in PSQL
- Monitoring tables
- Connection and Transaction Triggers
- Temporary Tables
Context variables WIRE_COMPRESSED and WIRE_ENCRYPTED were added to the SYSTEM namespace to report compression and encryption status, respectively, of the current connection. See Context Variables: v.3.0.4 for details.
Enhanced reporting of errors when a dynamic library fails to load. For more information, see Better Reporting on Dynamic Library Loading Errors.
When an external function (UDF) causes an error of the type "Arithmetic exception, numeric overflow, or string truncation", the error message will now include the name of the function.
The API now supports passing the DPB/spb item ***_auth_plugin_list from an application to the client interface. More details.
Two new context variables LOCALTIME and LOCALTIMESTAMP that are synonyms for CURRENT_TIME and CURRENT_TIMESTAMP, respectively. They can be used in Firebird 3.0.4 and later, for forward-compatibility with Firebird 4. See Context Variables: v.3.0.4 for details.
The read-only restriction for system tables was relaxed to permit CREATE, ALTER and DROP operations on their indexes.