This is a focused minor release built around a single major feature: the ability to create indices concurrently in Firebird 5.
Many database administrators have lost sleep creating indices at night to avoid impacting production. In some cases, a CREATE INDEX or ALTER INDEX operation running during production hours has caused databases to become unresponsive.
With Firebird in HQbird starting from 5.0.5.1838, this is no longer necessary. The new CREATE INDEX CONCURRENTLY command allows indices to be created without blocking database operations. It is important to add that database is 100% compatble with vanilla Firebird, no need to backup-restore to switch between HQbird and Firebird.
This feature will be available in vanilla Firebird 6, when it will be released, and already available in HQbird.
This release also includes additional improvements and bug fixes, including enhancements to silent installation and uninstallation.
More details: https://ib-aid.com/articles/concurrent-index-creation-in-firebird
Download HQbird: https://ib-aid.com/en/download-hqbird
en
br
IBSurgeon provides the encryption plugin framework for Firebird:
To recover corrupted Firebird (or InterBase) databases you can use IBSurgeon FirstAID - the best recovery tool for Firebird and InterBase. FirstAID can automatically fix the vast majority of Firebird database corruptions. For big database (more than 65Gb in size) please contact our support, most likely it will require manual recovery service.