Firebird x InterBase

Historical overview

InterBase was created in 1985: it was the first commercial multi-versioning database. In the end of 1999, Borland decided to close InterBase development and published its source codes under InterBase Public License. This code was copied (it is permitted by the license), and Firebird was born – from the version 1.0 Firebird is a production-ready database, based on previous decades of InterBase development.

At the end of 2000, Borland turned back to the closed source and commercial licenses (exactly as it was earlier) with InterBase and started development of 6.5.

Firebird 1.0 was released in 2002, with many bugfixes and extensions of DDL and DML. The active Firebird development continued after 1.0, and in 2004 the second major version of Firebird (v.1.5) was released. Borland at that time also has introduced new versions (7.0 and 7.1). Firebird 1.5 and InterBase 7.0 was incompatible both by database format (ODS) and core functionality. The migration from InterBase to Firebird and back with backup/restore is impossible since Firebird 2.0 and InterBase 7.0.

Since then, the difference between Firebird and InterBase became bigger.

Check the full article from IBSurgeon, and see the currently diferences between Interbase and Firebird.

Disponível também em Português.

JayBird 3 is released

We are happy to announce the release of Jaybird 3.0.0.

Jaybird 3.0 is a big change from Jaybird 2.2 and earlier. The entire low-level implementation has been rewritten to be able to support protocol improvements in newer Firebird versions. We have also made changes with a stricter interpretation of the JDBC requirements, and removed some parts that were either obsolete or not functioning correctly.

Most notable changes in Jaybird 3:

  • Support for wire protocol versions 11, 12, and 13 (without support for encryption and compression); protocol version 13 contributed by Hajime Nakagami
  • Support for the Firebird 3 SRP (Secure Remote Password) authentication mechanism (contributed by Hajime Nakagami)
  • Support for streaming backup and restore (contributed by Ivan Arabadzhiev)
  • Improved Firebird 3 support
  • Improved and stricter JDBC support (including improved java.time support, and more optional methods implemented)
  • Initial JDBC 4.3 (Java 9) support (without real module support)
  • New implementation of the native/embedded Type 2 driver using JNA (a jaybird .dll/.so is no longer needed)
  • Improved character set handling
  • Removal of (buggy) connection pool implementation
  • Removal/replacement of (internal) GDS API

And a large number of smaller bug fixes, improvements, and changes.

We recommend that you do not consider Jaybird 3.0 a drop-in replacement for Jaybird 2.2, and study the release notes carefully. Test your application with Jaybird 3.0 before using it in production.

Jaybird 3.0 supports Firebird 2.0 and higher, on Java 7, 8 and 9. Basic Java 9 compatibility is provided through the Java 8 version of the driver.

See also:

FirstAID 5.0: Firebird 3.0 and InterBase XE7 and support of 100+Gb databases

We are proud to present IBSurgeon FirstAID 5.0 – the new version of the recovery software with the highest rate of successful repairs. FirstAID 5.0 is a major improvement: now it supports Firebird 3.0, InterBase XE7, and big databases (100Gb+).

Download IBSurgeon FirstAID 5.0

If you are a user of FirstAID version 3.x or 4.x, you can log into IBSurgeon Deploy Center and see that you were automatically upgraded to version 5.0. All your licenses were transferred to 5.0.

IBSurgeon FirstAID 5.0 -50% upgrade offer till May 15
If you have the license for FirstAID version 1.x or 2.x (including Pack 3.x), or if you have used all licenses for 3.x/4.x, we would like to offer you 50% discount to upgrade to FirstAID 5.0 Tech Support (for 50 databases) for the special price: USD$99. This is a limited offer till May 15 only!
Upgrade Now!

FB Documentation Crowdfunding campaign

Goal: Translate & Publish Firebird Developer Guide
During 2015-2016 IBSurgeon and the Moscow Exchange sponsored the authoring, in Russian, of step-by-step examples for newbie Firebird developers, with databases in 2.5 and 3.0 format.  The work included full source code and parallel examples in Delphi, .Net desktop, .Net MVC, PHP (based on Laravel) and Java (Jaybird 2.x).  The main work was done by Denis Simonov, who previously edited the Russian version of the Firebird 2.5 Language Reference that was translated into English and published last year.

The Firebird Project’s 2017 project is to translate this work into English, edit and review it and publish it as the Firebird Developer Guide in the project’s documentation library.  For this project, as ever, we need funding.  This is your opportunity to make it happen, by contributing whatever you can to our crowdfunding campaign.

To donate, go to here and click the donate button.

Database .NET 21.5 and dbMigration .NET 5.3 released!

Database .NET 21.5 is an innovative, powerful and intuitive multiple database management tool. (Full support for Firebird 1.5~3.0+)
http://fishcodelib.com/Database.htm (Change Log 2017/04/17)

dbMigration .NET 5.3 is a simple, easy and intuitive multiple database migration and data synchronization tool, With it you can easily migrate schema and data to Firebird and vice versa.
http://fishcodelib.com/DBMigration.htm (Change Log 2017/04/17)


  • Updated to FirebirdSql.Data.FirebirdClient.dll 5.8.1.0
  • 30~50% performance improvement for Data Import, Export and Migration
  • Better support for windows display scaling
  • Added support for PSQL Stored Functions (FB3)
  • Fixed support for Firebird Embedded
  • Fixed CHECK Constraints for Firebird
  • Compatible with Microsoft Windows 10 RedStone 2 (1703)
1 53 54 55 56 57 201