We are happy to announce the release of Jaybird 5.0.5.
We've identified an issue where the latest libpthread library versions are not compatible with Firebird 2.5 (including the latest available release of vanilla version 2.5.9.27139). To prevent any impact on Firebird 2.5, please follow the guidance provided below. Please note that version 2.5 is discontinued and there will be no fix for it in vanilla version.
The Firebird Technical Task Group has wrapped up its meeting, and we're excited to share the roadmap for the upcoming version 6. There are so many features planned: schemas, JSON, tablespaces, new SQL.
The Firebird Project is launching the Technical Task Group meeting next week, where its developers and sponsors will plan the future of Firebird, including version 6. Become a sponsor and participate!
The Firebird ODBC driver is in beta testing, with version 3.0.0.8 available. You can download it and test how well it works with Power BI and other common tools. Please send feedback to Github Issues of Firebird ODBC!
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.
In this video, we explore the InlineSortThreshold parameter, a recent addition to the Firebird configuration that alters the execution plan from SORT to REFETCH. Additionally, we briefly examine the ORDER INDEX plan, and perform comparison of 3 sorting methods in Firebird.
This presentation addresses a common inquiry among Firebird database administrators: should the swap space (paging file) be enabled or disabled for Firebird on Linux or Windows servers? We'll delve into the theoretical aspects, examine recommendations from vendors, and most importantly, analyze statistics from production servers running on both Linux and Windows platforms. Here's a heads-up – swap space is essential; turning it off is not recommended!