New Flamerobin snapshot available : 0.9.3.3
New Flamerobin snapshot available.
Increased Firebird 3 compatibility and a new dependency interface.
https://github.com/mariuz/flamerobin/releases/tag/0.9.3.3
Take a look, test and comment.
Category: General news
Firebird related news
Get USD 5 OFF in the Migration Guide to FB 3
Planning to move to Firebird 3 and still didn’t buy the Migration Guide to Firebird 3?
Here is your chance to buy the eBook with USD 5 discount, so the final price will be USD 11! The promotion is valid only for the eBook version (PDF) and will be active up to Aug, 21.
Hurry up, save some money and many hours of headache during your migration process!
Enter the coupon code FB3OFF5 in the order form to get your discount!
Obs: Most of the information in this guide can also be applied when moving to Firebird 4.
Rust Firebird Client
Rust Firebird Client that Binds to official firebird client lib
Object Pascal Examples for Firebird OO Api
The aim of these examples is to copy as closely as possible the equivalent C++ examples. The primary intention is to demonstrate how to make calls to the new Firebird OO API. For this reason they should not be considered examples of best practice.
Another alternative is MWA Software’s Firebird Pascal Interface https://www.mwasoftware.co.uk/fb-pascal-api
New version of RedExpert 2020.08 has been released
New version of RedExpert 2020.08 has been released.
The main changes:
- the launch of the program and the search for Java have been completely redesigned. Now if Java is not found, it is suggested to specify the path manually or download Java automatically;
- fixed display of system objects (generators, domains and functions that are not defined by the user are not displayed in the main nodes);
- fixed execution of the script containing “execute block”;
- fixed editing procedure with declare variables block;
- removed the type of object while copying the name;
- fixed display of tables if “RDB $ RELATION_TYPE IS NULL”;
- fixed bugs with autoincrement while creating and editing tables;
- other minor fixes.
Download and install the new version.
Jaybird 4.0.1 released
Jaybird 4.0.1 has been released. Jaybird 4.0.1 is the first maintenance release of Jaybird 4, and introduces support for INT128 (a new type in Firebird 4), improves support for the Firebird 4 WITH TIME ZONE types by adding support for java.time.ZonedDateTime and making some of the derivation rules more consistent with Firebird. It also provides some bug fixes and other changes.
The following has been changed or fixed since Jaybird 4.0.0
- Fixed: Changes to the transaction configuration (transaction parameter buffer configuration) of one connection are no longer propagated to other connections with the same connection properties (JDBC-386)
- Fixed: Search index of Javadoc in Java 11 version used incorrect links (JDBC-619)
- Fixed: The cleanup of native resources didn’t dispose the native library held by JNA, as a change in implementation no longer allowed directly access to the JNA NativeLibrary (JDBC-620)
- Fixed: When updating a row through an updatable result set, selected but not updated blob fields were set to NULL (JDBC-623)
- Added: Support for type INT128 (reported as JDBC type NUMERIC) (JDBC-624)
See also Firebird 4 INT128 support. - Added: A static utility method FBDriver.normalizeProperties which, given a JDBC url and a Properties object, returns a Map<String, String> containing the merged properties normalized to common property name. (JDBC-627)
- Fixed: Use of isc_dpb_no_db_triggers no longer logs a warning (JDBC-628)
- Incompatible change: While making changes to time zone support, the API of org.firebirdsql.gds.ng.tz.TimeZoneDatatypeCoder was made almost entirely private. This should not affect normal user code.
Although we try to avoid these types of incompatible changes in point releases, we explicitly allow them for the org.firebirdsql.gds.ng package and sub-packages. - Changed: conversions from TIME WITH TIME ZONE now use 2020-01-01 as base date for named zones (JDBC-629)
- New feature: Added support for java.time.ZonedDateTime for the WITH TIME ZONE types (JDBC-630)
- Fixed: Connection.setNetworkTimeout incorrectly used the provided Executor to set the timeout (JDBC-631)
Jaybird 4 supports Firebird 2.5 and higher, on Java 7, 8, 11 and 14 (using the Java 11 version of the driver).
See also:
Firebird Java External Engine Plugin 1.0.0-beta-1 released
Firebird Java External Engine Plugin 1.0.0-beta-1 is now available for download https://github.com/FirebirdSQL/fbjava/releases/tag/1.0.0-beta-1
IBSurgeon Firstaid 7.0 is released
IBSurgeon releases version 7 of FirstAID: recovery for Firebird and InterBase databases.
This version includes the following new features and bugfixes:
- Support of InterBase is extended till the version of 2020
- Firebird 4 support was aligned with changes in ODS of Firebird 4.0 Beta 2 version, almost ready for the release
- Addressable space for 64-bit machines was increased to 3Gb, which allows to open and recover bigger databases
- Several bugfixes for BOOLEAN data type recovery and BLOBs processing
Download FirstAID now: https://ib-aid.com/en/ibsurgeon-firstaid/
Clients with available FirstAID activations (from version 3.0+) can download and use version 7.0 with existing licenses.
Those clients who have exhausted all activations, or users of FirstAID before 3.0, can upgrade here https://ib-aid.com/en/upgrades-ibsurgeon/
Firebird 3.0.6 is out
Firebird Project is happy to announce general availability of Firebird 3.0.6 — the 6th point release in the Firebird 3.0 series.
This sub-release offers many bug fixes and also adds a few improvements, please refer to the Release Notes for the full list of changes.
Binary kits for Windows, Linux and Android platforms are immediately available for download, Mac OS packages will follow shortly.
New Firebird driver for Python – preview release
There is now an official preview release – v0.5.0 – available on PyPI:
https://pypi.org/project/firebird-driver/
All core driver functionality works, except handling of limbo
transactions due to error discovered in Firebird (should be fixed in
soon to be released Firebird 3.0.6).
This preview version was released because the driver architecture is
evolving rapidly, and I would like get some feedback before the initial
release planned for end of June.
Some important notes about the driver architecture:
- It uses namespace package “firebird”, and the driver is distributed
as “firebird.driver” package. There are other packages that share the
same namespace: “firebird.base” and “firebird.butler”. In future I’d
like introduce “firebird.lib” package for extension libraries (former
schema, monitor and other extension modules in FDB). - Although the initial driver design was close to FDB, there are
significant differences and the driver architecture and API will diverge
further from FDB or KInterbasDB. The sole backward “compatibility” is
defined as compliance to Python DB API 2.0. So the new driver is not and
will not be a drop-in replacement for FDB.
Here are some main decisions related to implementation and architecture:
