The free book "Detailed features of Firebird 5" (in English) is written by D.Simonov and edited by A.Kovyazin. The book covers all new feautures of Firebird 5 (including 5.0.1).
Update of 1-step Firebird installation scripts for Linux. Now they support CentOS (7, 8, 9), Debian (11, 12), Oracle Linux (8, 9), RockyLinux (8, 9), Ubuntu (22, 24).
We have made performance tests and confirmed that Firebird 5.0 delivers impressive performance gains over previous versions. Recent tests comparing it to versions 4.0, 3.0, and 2.5 reveal significant speed improvements across various operations. Database administrators and developers can expect noticeable speed boosts when upgrading to version 5.0. See presentation and video for more details.
Firebird 5.0.1 introduces several bug fixes and stability improvements, as well as a noteworthy new feature for the database optimizer. The update includes the ability to convert subqueries to ANY/SOME/IN/EXISTS in semi-join operations. converting subqueries to ANY/SOME/IN/EXISTS in semi-join. By default, this feature is disabled, but it promises great improvements in the speed of complex SQL queries. See in-depth article for all details.
April-June 2024 was pretyy intensive period: read the digest of news and events!
This is the final part of the comprehensive description of Firebird 5 features, it is devoted to the brand new feature: SQL Profiler. It became much easier to find performance bottlenecks in complex stored procedures and identify SQL code responsible for slowness.
In order to make Firebird installation on Linux flawless and fast, we continue the effort to provide one-step Firebird installation scripts for all popular Linux distrinutions - now for Rocky Linux 8 and 9.