HQbird 2024 is released

We are glad to announce that HQbird version 2024 is released!
HQbird is advanced distribution of Firebird, with many improvements in the areas of performance, high availability, development, and more. It is intended for large enterprises and development companies with many Firebird installations, offering performance, protection from various threats, and mass maintenance.

Version 2024 introduces support of Firebird 5, and continue to support versions 4.0, 3.0, 2.5, with various improvements in the engine, high availability, tooling, and encryption.

HQbird is 100% compatible with Firebird, no need to perform backup/restore, you can install HQbird in trial mode in parallel with vanilla Firebird, and switch between instances.

The detailed list of HQbird features which improves Firebird can be found here, and below there are the biggest improvements of version HQbird 2024:

  1. Replacing queries “on the fly”
  2. Plugins for performing external connections with ODBC and MySQL
  3. Streaming/Change Data Capture with ready-to-use Kafka plugin, and plugin-building framework.
  4. Automation support to work with many databases on the server (for clients with SaaS model), with ability to create “replica server”
  5. Multi-instance support, which makes migration process from old Firebird versions much easier. HQbird 2024 is also integrated with Mass Migration Framework
  6. Automatic correction of firebird.conf configuration in case of erroneous configuration.

All features are described here.

HQbird v2024 has 2 licenses (click here to see purchasing options):

  • Per server, suitable for small and medium companies, US$899/server
  • Unlimited License, for large enterprises and software development companies, cost US$13465/year for unlimited number of installations.

Download HQbird v2024 here.

Customers with support contracts, subscriptions, or recent maintenance purchases (within the last 13 months), as well as customers who bought HQbird in the last 30 days, will get free upgrades in the next 10 days.

IBProvider News

Hello Everyone.

We have updated all our components and recommend our user and customers to use them.

https://www.ibprovider.com/eng/news/n_240311.html

IBProvider 5.36.x

  • Sending short BLOB via VARCHAR datatype (Firebird v2.5.1+)
  • A support of Windows XP was restored

LCPI ADO.NET provider for OLE DB v1.29

  • Assemblies for .NET8 were added

Other updates

  • LCPI OLE DB Services was updated
  • LCPI EF Core Provider for OLE DB was updated

Kind Regards, IBProvider Team.

Jaybird 5.0.4 released

We are happy to announce the release of Jaybird 5.0.4.

The following has been fixed since Jaybird 5.0.3:

  • Firebird 5.0 is now formally supported
  • Fixed: Potential NPE when warningMessageCallback is null while reading operations or consuming packets (#778)
  • Fixed: FBRowUpdater incorrectly considers result set with only partial PK updatable — backported from Jaybird 6 (#780)
  • Fixed: Use of offset timezone names (e.g. +05:00) for sessionTimeZone would result in a warning being logged, and an incorrect conversion applied (in UTC instead of the offset) when using the legacy time types — backported from Jaybird 6 (#787)

Jaybird 5 supports Firebird 2.5 and higher, on Java 8, 11, 17 and 21 (support for Java 11 and higher using the Java 11 version of the driver).

See also:

FBPC 1.0.2 is released

The new version of Performance Comparer for Firebird is available. In this new version, the parsing of huge trace files is much faster, along with some other small changes and fixes which are listed in the changelog.txt. This is the first non-beta version.

FBPC is a free tool that can help people to compare the performance between two Firebird versions, or even between the same Firebird version but with different configurations in firebird.conf

IBProvider v5.35 and BIG testing with FB4

Hello Everyone!

We are pleased to present a new release of our OLE DB provider for Firebird and InterBase, which has undergone not only standard load testing, but also BIG testing with Firebird v4, which lasted more than a month. This is more than 7 million tests executed in parallel on a ten-core processor.

IBProvider v5.35

In this new version of the provider, the internal infrastructure has been improved — now the cancellation of query execution also applies to operations with BLOBs.

BIG testing with FB4

The last time BIG testing was done was 3 years ago with FB 3.0.8.33401…

Read more: https://www.ibprovider.com/eng/news/n_240212-fb4_big_testing.html

With Kind Regards, IBProvider Team.

FBPC 1.0.1 is released

The new (beta) release of the Performance Comparer for Firebird tool fixes some small glitches and improves the usability. The Firebird Embedded used by the tool was also updated to the official Firebird 5.0 release. More details about the changes can be found in the ChangeLog.txt.

A video (recorded from a recent Live, in Portuguese) is now available on YouTube, showing how to use the tool. Of course, the previous instructions (in English) are still included in the distribution.

Download the new version and get to know how your queries will behave in Firebird 5 (or any version of Firebird), before migrating your customers.

Jaybird 5.0.3 and 4.0.10 released

We are happy to announce the release of Jaybird 5.0.3 and Jaybird 4.0.10.

With this release, Jaybird 4 is end-of-life. We recommend upgrading to Jaybird 5.

Jaybird 5.0.3

The following has been changed or fixed since Jaybird 5.0.2:

  • Improvement: Do not reject attempts to read blob id 0 — backported from Jaybird 6 (#765)
  • Fixed: on CHAR fields, a too short value could be returned if the string contained one or more codepoints represented by surrogate pairs and the string length in char exceeded the maximum string length — backported from Jaybird 6 (#770)
  • Fixed: CallableStatement.getXXX(String) could return value from wrong column — backported from Jaybird 6 (#772)
  • Updated: error messages updated from Firebird 5.0.0.1272

Jaybird 5 supports Firebird 2.5 and higher, on Java 8, 11, 17, and 21 (support for Java 11 and higher using the Java 11 version of the driver).

See also:

Jaybird 4.0.10

Jaybird 4.0.10 is the last release of Jaybird 4, and Jaybird 4 is now end-of-life. We recommend upgrading to Jaybird 5.

The following has been changed or fixed since Jaybird 4.0.9

  • Fixed: Reconnect transaction with a transaction id exceeding 0x7FFF_FFFF did not work (#734)
  • Fixed: CallableStatement.getXXX(String) could return value from wrong column — backported from Jaybird 6 (#773)
  • Updated: error messages updated from Firebird 5.0.0.1272

Jaybird 4 supports Firebird 2.5 and higher, on Java 7, 8, 11, 17, and 21 (support for Java 11 and higher using the Java 11 version of the driver).

See also:

Firebird Performance Comparer (FBPC)

In my two presentations at the 20th Firebird Developers Day, I introduced firsthand the tool I created to help compare the performance between two Firebird servers (>= 2.5) in an easy and visual way.

This tool actually helped to detect a performance regression in Firebird 5 beta, which was resolved after I reported it to the core developers. The intention is to identify optimizer regressions or low performance issues in Firebird itself, or even the breaking of SQL commands due to new reserved words or syntax restrictions.

I’m making version 1.0 beta available for anyone interested. It’s a version that so far has been tested only by me, so it may and probably does have some bugs.

The FBPC runs on Windows and internally uses Firebird 5 RC1 embedded to store the tests and their results. When you run the application for the first time, it will display instructions on how to use it.

In summary, it helps you create a trace.conf to capture SQL commands executed on a Firebird server 2.5 or higher in a production environment. Then, the tool parses the file and collect the statements, allowing you to run them in a controlled environment of servers, specifying test rounds where the execution time between server1 and server2 is compared and displayed in an intuitive and visual way, enabling you to detect regressions or even commands that could not be executed due to new reserved words or syntax restrictions imposed in new versions of the DBMS.

RedExpert 2023.10.1 has been released

You can join to the Telegram chat for discussion.

New version of RedExpert 2023.10.1 is available.

Added:

  1. “Properties” tab on the database table editing panel.
  2. Configuring SQL templates from the Menu -> Tools.
  3. Checkbox “Automatic text wrapping” in the text browser of data with the BLOB type.
  4. Ability to specify a relative path to the log file in the settings.
  5. View blobs of PDF type.
  6. Autocomplete when editing table triggers for <new.> and <old.>.
  7. Ability to change column position.
  8. Ability to (not)check changes in column positions during DB comparison.
  9. Changing a cursor in the Query Editor while holding down the CTRL button when hovering over an object that can be opened.
  10. Restart the application only after saving several settings
  11. Target and source database exchange button on the comparison panel.

Fixed:

  1. ODBC driver support has been terminated.
  2. Recreation a role when adding a comment  for it.
  3. Errors of editing table foreign keys.
  4. Inability to add a comment to the index through the editing window.
  5. Adding extra versions of Red Expert to the list of Windows applications when installing a new version of the application over the old one.
  6. Action taken when clicking the Select Displayed Dataset Columns button when the Results Pane is closed.
  7. Selecting  table rows to be deleted after closing the “Data” tab and canceling the deletion.
  8. An error when the “Close all tabs” button did not close all tabs.
  9. Incorrect error handling during update.
  10. Syntax highlighting for multi-line identifiers.
  11. Application crash if user settings are broken.
  12. DDL generation for ARRAY, NUMERIC and DECIMAL columns.
  13. Improved autocomplete support for Firebird aliases and keywords.
  14. Working with tables with name length more than31
  15. Updated links for automatic Java downloads.
  16. Unreasonable memory consumption.
  17. Incorrect display of the red_expert.ico file.
  18. Functioning of such application settings as:
    1. highlighting the current line;
    2. number of saved log files;
    3. selected text color;
    4. alternative editor background;
    5. editor font color;
    6. alternative highlight color.

Download and install the new version.

1 2 3 145