Firebird 4 is released

Firebird Project is happy to announce general availability of Firebird 4.0 — the latest major release of the Firebird relational database.

Firebird 4.0 introduces new data types and many improvements without radical changes in architecture or operation, the most important are:

  • Built-in logical replication;
  • Extended length of metadata identifiers (up to 63 characters);
  • New INT128 and DECFLOAT data types, longer precision for NUMERIC/DECIMAL data types;
  • Support for international time zones;
  • Configurable time-outs for connections and statements;
  • Pooling of external connections;
  • Batch operations in the API;
  • Built-in cryptographic functions;
  • New ODS (version 13) with new system and monitoring tables;
  • Maximum page size increased to 32KB.

Please refer to the Release Notes for the full list of changes. The complete Language Reference is also available.

Binary kits for Windows, Linux and Android platforms (both 32-bit and 64-bit) are immediately available for download.

Firebird Yahoogroups archive

Mark Rotteveel posted on twitter:

In case anyone is interested in the archive of Firebird mailing lists that were hosted on Yahoo Groups: … (up to the 14th of December 2019)

I’m considering the idea to also add messages after the 14th of December 2019 (when the Yahoo Groups archive closed down) and the final shutdown of Yahoo Groups at the end of 2020.

Mark Roteveel on twitter

Tutorial to use Firebird on Android

Jan Baumgarten wrote a tutorial on how to create a simple application using Delphi + ZeosLib and Firebird 4RC1 on Android devices.

Firebird binaries for Android are around for quite some time as “test” releases, but there is a lack of information about how to use it in Delphi applications. Well, seems that no more 😉

Firebird 3 Language Reference

The Firebird Documentation Team is proud to announce the first release of the English Firebird 3.0 Language Reference (HTMLPDF). You can also find it on the Documentation page. This new Language Reference covers all SQL syntax of Firebird 3.0.

The new English Firebird 3.0 Language Reference is based in part on the Russian Firebird 3.0 Language Reference, but is not a direct translation (though we thankfully copied parts of it). Work has also been started on the Firebird 4.0 Language Reference.

Developer’s Pub presents Ann Harrison

The second episode of the Developer’s Pub series is now online, and the interviewed is no one less than Ann Harrison, the “mother of InterBase/Firebird”, telling us great histories of her life and the time spent with InterBase and Firebird… and Jim, of course! Enjoy watching, and don’t forget to give your like!

Firebird 4 RC1

Firebird Project announces the first Release Candidate of Firebird 4.0, the next major version of the Firebird relational database, which is now available for testing on Windows and Linux platforms.

This Release Candidate demonstrates the complete set of features and improvements developed for the new release. Release Candidates are generally considered stable enough and may be recommended for testing in “almost-production” environments. Our users are appreciated giving it a try and providing feedback to the development mailing list. Apparent bugs can be reported directly to the bugtracker.

Please read the Release Notes carefully before installing and testing this Release Candidate.

Firebird automated testing site

Alexey Kovyazin recently shared some interesting news:

Hi All,

This website is a frontend of FBT + OLTP+automated scripts, supported by Pavel Zotov and some IBSurgeon employees.

It is running FBT tests on Windows server (8Gb, 4cores) for SuperServer and Classic for 3.0 and 4.0, and OLTP-EMUL for SuperServer 3.0/4.0.

Tests are triggered automatically, when new build appear at

As a result of test run, the report is generated.
P – passed (ok)
Failed test due to failed assert is marked as F (failed), pink
Failed due to runtime marked as E (error), yellow.
Failed due to Firebird crash – F red/violet

For each error there is a hint (mouseover) with details of the error.

After click on the cell, the new page will be opened with more details and history of runs.

Detailed links:

  1. Total results for each kind of outcome and server mode
  2. ERRORS MAP: distribution of Firebird errors which occured during runs
  3. FRESH FAILS: tests which failed for LAST execution only
  4. FRESH ERRORS: tests which raised run-time error for LAST execution only
  5. STILL FAILS: tests which fail for at least two last runs
  6. Has fails: tests with at least one fail for previous runs
  7. Has runtime errors: tests with at least one runtime error for previous runs
  8. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent
  9. All tests: outcomes – all results for last 30 runs
  10. All tests: A. Skipped: tests which was intentionally excluded from execution

Firebird OLTP Emul results
OLTP Emul simulates high load OLTP aplication, and uses many
sophisticated SQLs in multi-thread environment.

Our plan for the future:
1) Publish sources of automated scripts to GitHub (need to clean them a bit)
2) Perform Linux tests and include report results to the frontend
3) improve web representation – https certificate, design, etc
4) Migrate to the new FBT test framework when its adoption will be completed

We invite all interested to join the effort.
Pavel Zotov is a coordinator of the project –

Alexey Kovyazin

17th FDD – record of donations!

The 17th FDD in Brazil, organised by Carlos Cantu, were a huge success! It was convened online for the first time, due to Covid-19. There were 720 attendees, and the traditional collection of donations netted a record R$ 8.163,35 after tax, for Firebird development.

The list of donors and their donations is at


17º Firebird Developers Day

Only for Brazilians and Portuguese speakers…

Está no ar o site do 17º Firebird Developers Day, que dessa vez excepcionalmente será realizado on-line, de 21 a 25 de setembro, uma palestra por noite.

Essa é uma edição “best of“, ou seja, o tema das palestras foi definido por votação dos melhores temas das edições anteriores. As palestras serão ao vivo, com direito à perguntas e respostas.

A inscrição é apenas R$ 50, e todos os inscritos ganharão uma cópia do eBook Guia de Migração para o Firebird 3! Fora isso, poderão também aproveitar as promoções dos patrocinadores, além de participar do tradicional sorteio de licenças.

Visite o site do evento e faça sua inscrição para aproveitar o preço promocional. O download do ebook é liberado assim que o pagamento é reportado pelo banco (dentro de 48h).

Ajude a divulgar o evento compartilhando essa publicação em grupos de bancos de dados e de programação.

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.

1 2 3 95