IBX 2.4.2 is now available for download

MWA Software is pleased to announce the release of version 2.4.2 of IBX for Lazarus. This version adds support for the Firebird 4 IBatch interface. It also fixes some minor bugs. Version 2.4.2 supports all Firebird releases from 2.5 onwards.

The Firebird 4 Batch Execution interface applies to Update and Insert queries only (i.e. not update/insert returning) and can be used to batch up many separate queries to be executed as a single operation. This can be used to minimise the client/server interfaces and to optimise server update/insert times.

Support is provided by the Firebird Pascal API and exposed via TIBSQL.

It is available for download from

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

New release of Firebird driver for Python v1.3.0 is available with Improved Firebird 4 support

New release of Firebird driver for Python v1.3.0 is available for download with Improved Firebird 4 support.

The firebird-driver package provides official Python Database API 2.0-compliant driver. In addition to the minimal feature set of the standard Python DB API, this driver also exposes the new (interface-based) client API introduced in Firebird 3, and number of additional extensions and enhancements for convenient use of Firebird RDBMS. The driver is written as pure-Python package (requires Python 3.8+) on top of Firebird client library (fbclient.so/dll) using ctypes. Driver supports Firebird version 3.0 and higher.

You can download this driver from PyPI or or install it using pip.

Golang Firebird Driver version 0.9.2 released with a few Firebird 4 features

Golang Firebird Driver version 0.9.2 released with a few Firebird 4 features and fixes :

  • Support negatives INT128 #132
  • Fix decode Int128 #131
  • Upgrade mathutil to v1.4.1 to support RISC-V x64 #122
  • Update README.rst – current supported go is 1.15 #121
  • Support INT128 for Firebird 4.0 #129
  • Move calcBlr() to xsqlvar.go c19e7b9
  • Fix time(stamp) with timezone. issue #128 

You can install it with go get github.com/nakagami/firebirdsql

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.

1 2