Firebird 4 is released

Firebird Project is happy to announce general availability of Firebird 4.0 — the latest major release of the Firebird relational database.

Firebird 4.0 introduces new data types and many improvements without radical changes in architecture or operation, the most important are:

  • Built-in logical replication;
  • Extended length of metadata identifiers (up to 63 characters);
  • New INT128 and DECFLOAT data types, longer precision for NUMERIC/DECIMAL data types;
  • Support for international time zones;
  • Configurable time-outs for connections and statements;
  • Pooling of external connections;
  • Batch operations in the API;
  • Built-in cryptographic functions;
  • New ODS (version 13) with new system and monitoring tables;
  • Maximum page size increased to 32KB.

Please refer to the Release Notes for the full list of changes. The complete Language Reference is also available.

Binary kits for Windows, Linux and Android platforms (both 32-bit and 64-bit) are immediately available for download.

IBX 2.4.0 for Lazarus is now available for download

MWA Software is pleased to announce the release of version 2.4.0 of IBX for Lazarus. This version supports the new Firebird 4 data types and has been tested with the latest version of lazarus (2.0.12) and FPC (3.2.0). All users are recommended to upgrade to this version. It is available for download from

https://www.mwasoftware.co.uk/ibx

The new Firebird data types supported are: TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE, INT128, DECFLOAT and  extended precision NUMERIC fields. Due to recent changes to the Firebird 4 API, no version of Firebird 4 less than Firebird 4 rc1 is supported.

See the updated user guide for more information on how to use these new data types.

A major addition to IBX 2.4.0 for lazarus is the inclusion of a comprehensive testsuite. This is not included in the distribution archives, but can be downloaded from our svn repository (https://www.mwasoftware.co.uk/svn-repository).

The testsuite is intended to provide a set of tests with a pass/fail result determined by a simple inspection of the “diff” file. It uses the same approach as the existing testsuite for the Firebird Pascal API, also bundled in with IBX for Lazarus.

The testsuite comprises 28 separate tests, testing 230 identified features present in the IBX non-visual components. It is intended to provide comprehensive test coverage of all test features in order to demonstrate a high degree of confidence that the software performs as expected and when run on different platforms (32 bit and 64 bit, Linux and Windows) and with different versions of the Firebird database (2.5, 3 and 4). It also supports regression testing. See doc/TestCoverage.pdf for a list of tests and test features and which test covers which test features. The file ibx/testsuite/readme.txt contains information on how to run the test suite.

Version 2.4.0 has been tested using the testsuite for Firebird 2.5.9, Firebird 3.0.5 and Firebird 4 rc1 in various combinations of 32-bit and 64-bit Linux and Windows platforms, and with recent versions of FPC.

Firebird 4 alpha

Firebird Project announces the first Alpha release of Firebird 4.0, the next major version of the Firebird relational database, which is now available for testing.

This Alpha release arrives with an early preview of the features and improvements currently under development by the Firebird development team, as well as with countless bugfixes. Our users are appreciated giving it a try and providing feedback to this mailing list. Apparent bugs can be reported directly to the bugtracker.

Alpha releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release.

Please read the Release Notes carefully before installing and testing this Alpha release.

Download page:
http://www.firebirdsql.org/en/firebird-4-0-0-alpha1/

Release Notes:
http://web.firebirdsql.org/downloads/prerelease/v40alpha1/Firebird-4.0.0_Alpha1-ReleaseNotes.pdf


Dmitry Yemanov