After two and a half years of development, Firebird 5.0 has been released. Firebird is a DBMS built upon the source code of Interbase 6.0, which was originally opened by Borland in 2000. Firebird is distributed under the free MPL license and supports ANSI SQL standards, including features like triggers, stored procedures, and replication. Binary assemblies for Firebird 5.0 have been prepared for Linux, Windows, MacOS, and Android platforms.
Key innovations in Firebird 5.0 include:
- Implemented the possibility of performing operations in multi-flow mode. Multi-flow operation is applicable in various scenarios such as creating indices, garbage assembly, creating backups, and restoring backups.
- Added support for partial indexes, which allows selecting specific records corresponding to certain conditions while creating an index.
- Implemented the SkipLocked syntax in the expressions of SELECT with LOCK, UPDATE, and DELETE statements. This syntax excludes records that are currently locked, preventing waiting for the release of blocking when interacting with another transaction.
- Added the ability to renew databases to the current intermediate storage version (ODS-On-Disk-STRUCTURE) on the fly, without the
/Reports, release notes, official announcements.