MWA Software is pleased to announce the 2nd pre-release of IBX2 for Lazarus. it is available here.

This second pre-release fixes several problems with the first pre-release including an issue with processing large blobs (> 64K) using the FB3 API, and event handling. Issues with Character Set NONE have also been resolved.

This version also sees considerable enhancement to TIBExtract and TIBXScript. TIBExtract has been updated to ensure proper dependency order with the extracted SQL. Data extract now includes generator values, binary blobs and arrays. The latter two data types are extracted as text objects using a simple XML format. TIBXScript has been updated to support the processing of embedded XML values as exported by TIBExtract, as well as interactive use, and support for Create Database, Connect and Drop Database statements.

The changes to TIBExtract and TIBXScript can be seen in the updated example program "fbsql". This now includes the capability to dump an entire database including binary blobs and arrays into a single text file and to recreate the database by reading from such a text file. While less compact than gbak format, this nevertheless is potentially very useful for tasks such as complex DDL changes with multiple dependencies, or removing not null constraints. fbsql can now also be used interactively from the command line.

Although nearing stability, a further period of field testing is believed appropriate before IBX2 is declared suitable for operational use.