In the article “How to install Firebird 3.0 and 4.0 on Linux” you can find the installation instruction for Firebird versions 3 and 4 on the popular Linux versions: CentOS 7, Oracle Linux 7/8, Debian 9/10, Ubuntu18/20, and OpenSUSE15.0.
The new article “How Firebird Database Encryption Works” is based on the materials of the workshop “Database Encryption” at Firebird Conference 2019 in Berlin, Germany, presented by Alex Peshkoff, Firebird Project, and Alexey Kovyazin, IBSurgeon.
The article describes how Firebird database encryption works, on the server-level, on the client-side, how to configure database encryption, how to use it from the various types of applications (Delphi, Java, .NET).
IBSurgeon releases a new version of Firebird Encryption Plugin Framework: the set of source files and ready-to-use compiled binaries to implement database encryption for Firebird databases.
Main features of Firebird Encryption Plugin Framework (version 2021):
1. Support of Firebird 4.0 and Firebird 3.0 out of the box, on Windows 32bit/64bit and Linux 32bit/64bit. The new version is ready to use with Firebird 4.0 without recompilation (but databases must be migrated, of course)
2. Client-side KeyHolder support. Now, fbclient.dll can load keys from KeyHolder.conf on the client-side, it allows the transparent and safe connection of developer tools, Firebird command-line tools. and other applications without key exchange support.
3. Included low-level tool for decryption of databases in case of corruption and (new in v2021) license of FirstAID recovery tool for 10 databases.
4. Gbak.exe supports encrypted backup and restore.
5. Client application examples are available for Delphi, Lazarus, PHP, .Net, Java, etc.
6. Now 2 licenses are available: a) Unlimited license with sources, it includes upgrades for all minor releases of Firebird 4.0.x – USD$1999 (EUR 1655) b) Unlimited license with sources and implementation consulting for 1 application, includes upgrades for all minor releases of Firebird 4.0.x – USD$2499(EUR 2055)
All existing customers of Firebird Encryption Framework Unlimited License will receive this major upgrade for free!
The 1st minor update of HQbird 2020 introduces several useful features and important bug fixes:
New updated HQbird user guide – in PDF and HTML
HQbird FBDataGuard shows the time on the server in the upper left corner
HQbird FBDataGuard during the installation automatically generates a name for the HQbird instance using hostname and date, and also set random background color (you can change name and color in the Alerts setup dialog – just click on the server name)
Updated OpenJDK distribution with HQbird for Windows to support changes in world time zones (Brazil DST, etc)
Fixed problem with Office365 emails in alerts settings
Fixed “Foreign key error” problem for several specific situations
Parameter TempSpaceLogThreshold to track big sortings now has the alias TempCacheLog
ALTER CONNECTION POOL statements are not replicated anymore
As you probably know, Firebird Conference 2019 will include the practical workshops, and the article “How to track deadlocks in Firebird” is one of the sneaks peeks of the workshop “All About Transactions”, which will be done by Vlad Khorsun, Firebird core developer, and Alexey Kovyazin from IBSurgeon.
To help developers investigate the update conflicts (deadlocks), Firebird puts into error messages the reference to the concurrent transaction – i.e., the transaction where the concurrent update is not yet committed. Together with Trace API, it gives us the ability to track both conflicting operations.