Contact Us | Site Map
Firebird is used by approximately 1 million of software developers worldwide. High compatibility with industry standards on many fronts makes Firebird the obvious choice for developing interoperable applications for homogeneous and hybrid environments.
You are here: Home Newsletter
Join Firebird!
Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses
Follow Us
Select your media preference
Google+ Twitter Facebook RSS
Subscribe to Firebird’s Newsletter to receive the latest news
August 21, 2015
Brazil has the largest Firebird user community in the world, and even the fact that we are suffering with a crisis maybe never seen before (forcing companies to cut costs or even to close its doors) did not diminish the brilliance of the event.

On August 8, people from 15 different states of Brazil participated in the 12th edition of the Firebird Developers Day (FDD). This year, the conference had Dmitry Yemanov (chief of the Firebird development team) and Alexey Kovyazin (IBSurgeon) as international speakers, as well the Brazilians Marcelo Daibert, Alexandre Benson Smith, Nilson Brasil and Carlos H. Cantu.

The FDD is an annual conference organized by FireBase, which brings developers an unique opportunity to catch up on issues related to Firebird, and exchange experiences with other users of this fantastic  RDBMS.

In addition, participants could also buy Firebird-related products with super special discounts. This year's conference was sponsored by IBSurgeon, FastReports, IBObjects, Embarcadero and supported by Woll2Woll, DevArt and Steema.

The report with all the information and many pictures can be seen here. During the registration process, people could donate money to the Firebird Foundation, summing up R$ 4.590.

On August 7, a selected group of people participated in a special MasterClass about Performance Optimization, done by Dmitry Yemanov and Alexey Kovyazin.
March 19, 2015
We invite all Firebird developers and administrators to a 1 day seminar on the Firebird 2015 Tour. The Firebird 2015 Tour is devoted to SQL performance optimisation: SQL plans, queries and database statistics, query tuning techniques and understanding how Firebird works within this context.

The Firebird 2015 Tour is organised by IBSurgeon and IBPhoenix, with the support of Firebird Developer core team.
Locations and dates of Firebird 2015 Tour (see details in the appropriate sections below):
  • April 24 - Seligenstadt, Germany
  • May 19 – Prague, Czech Republic
  • June 5 – Moscow, Russia
Topics of Firebird 2015 Tour seminar:

Performance of SELECT queries
1.    PLANs: what are INDEX, SORT, ORDER, NATURAL and how to manage them
2.    Execution statistics interpretation, data paths, cache hits
3.    Tracking slow and resource-consuming queries through the MON$ and Trace API
4.    Firebird configuration parameters
5.    Best practices, tips and tricks to speed up queries

Performance of INSERT queries
1.    Typical errors which lead to slow INSERTs
2.    How indices, triggers and database structure affect INSERT performance
3.    Transactions and INSERTs
4.    Best practices to speed up INSERTs

Performance of UPDATE and DELETE queries
1.    General approach for updates and deletes
2.    How indices, triggers and database structure affect UPDATE and DELETE performance
3.    Update Conflicts, transactions and their resolution, DELETE, SELECT WITH LOCK
4.    Real-life example of UPDATEs algorithm without conflicts

Multi-user performance optimisation
1.    Locks, mutexes and resource races
2.    Selecting Firebird architectures and tuning their parameters for multi-user environments

Locations and further details for the Firebird 2015 Tour

April 24, Seligenstadt, Germany

The seminar will take place in Hotel Columbus (, April 24, 2015.
Note: all topics are presented in English.

Seminar's schedule:
•    9-30-10-00 Registration
•    10-00 - 17-00 Seminar (with Lunch and Coffee breaks)

Attendee's package includes seminar’s materials, lunch and coffee breaks.
The early bird registration fee is EUR 49 (till April 5, volume discounts are available).

May 19, Prague, Czech Republic

The seminar will take in the Hotel Extoll Inn (,  May 19, 2015.
Note: all topics are presented in English.

Seminar's  schedule:
•    9-30-10-00 Registration
•    10-00 - 17-00 Seminar 10-00 - 17-00 Seminar (with Lunch and Coffee breaks)

Attendee's package includes seminar’s materials, lunch and coffee breaks.
The early bird registration fee is EUR 39 (till April 25, volume discounts are available)

June 5, Moscow, Russia

Seminar will take in TechnoPark «Slava» Inn (,  June 5, 2015.
Important! All topics are presented in Russian!

Seminar's  schedule:
•   9-30-10-00 Registration
•   10-00 - 17-00 Seminar (with Lunch and Coffee breaks)

Attendee's package includes seminar’s materials and coffee breaks.
The early bird registration fee is EUR 39 (roubles 2800) (till April 25).

With best regards,
Firebird Project Team
December 02, 2014
Firebird Project announces the first Beta release of Firebird 3.0, the next major version of the Firebird relational database, which is now available for testing.

This Beta release demonstrates the features and improvements currently under development by the Firebird development team. Our users are appreciated giving it a try and providing feedback here. Apparent bugs can be reported directly to the bugtracker.

Beta releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release.

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

Download page:

Release Notes:

Firebird Project.

November 24, 2014
Firebird Documentation funding campaign

Recently Firebird Project has announced the availability of Firebird Language Reference in Russian, and now crowd-funding campaign is in progress to collect money for English translation.

Don't miss your chance to participate in this campaign and help Firebird Project to create free, professional and detailed (400+ pages) Firebird SQL language documentation which will be very useful for all Firebirders.

Visit this link and select "Fund Docs".

Thank you in advance!

Firebird Conference 2014 Report

Firebird Conference 2014 took place on 24-25 October in Prague, Czech Republic, Clarion Congress Hotel. Some facts about the Firebird Conference 2014: there were 110 attendees, 18 speakers, 23 interesting presentations and, of course, invaluable conversations between sessions.

Headliners of Firebird Conference were core developers of Firebird Project: Dmitry Yemanov and Vlad Khorsun, they presented the latest  news about Firebird and plans for future development.

Special guests at Firebird Conference 2014 were Jim Starkey (original architect of InterBase, Falcon (MySQL), NuoDB and more) and Ann Harrison, with two very interesting presentations about high performance threading development and orphan records in Firebird.

Firebird driver developers, Jiri Cincura and Mark Rotteveel, spoke about Firebird.NET and Java. The second talk of Mark's was about Java and jOOq was also supported by Lucas Eder, original creator of jOOq.

The audience was great, many sessions turned into valuable conversations, generating tricky questions and comprehensive answers.

At the URL below you can download all the presentations that were made at the conference.

Firebird Project
October 31, 2014
Firebird Project is pleased to announce that «Firebird 2.5 Language Reference» in Russian language is released. It is available on Firebird SQL Documentation page.

Why it is only in Russian and how to get it in English? The answer is the following: Moscow Exchange, one of the biggest Firebird users in the world, and IBSurgeon (tools and service for Firebird) have sponsored documentation development in Russian. Several Russian-speaking core developers of Firebird Project participated in documentation creation to ensure its quality.

The next step is extending this documentation to cover Firebird 3 new features: authors and editors are already working on it. However, the resulted documentation for Firebird 3 will be also in Russian.

In order to translate Firebird documentation into English, Firebird Project needs additional funds.

We need US$7000 to translate almost 500 pages of Firebird documentation into English using professional translation service, which will ensure the quality of translation.

So, if you would like to have Firebird 2.5 and 3.0 Language Reference in English in the first quarter of 2015, please help Firebird Project now with your donations (please use PayPal option):

Please don't think that somebody else will pay for Firebird documentation!

Collected money will go to translation of Firebird documentation and, if USD$ 7000 threshold will be exceeded, for further development of next volumes: «Firebird Operations Guide» and others.
October 22, 2014
Firebird 3 is on its track to release: the first Beta version of source code was tagged, and now Firebird core developers work on Beta 2, with intention to release final Firebird 3 in the beginning of 2015.

How to ensure that Firebird 3 will be stable and reliable? How to make it happen earlier? The answer for these questions is: intensive beta-testing with wide community support.

To start effective beta-testing earlier and to supply Firebird developers with convinient path to Firebird 3 we started Firebird 3 Launch Campaign (  It has 3 parts:

1) Firebird 3 distributives, materials and documentation, with focus on Firebird 3 new features, configuration tips and tricks, performance testing, and, of course, beta-testing. 

2) Banners for Firebird 3. To support Firebird 3 Launch Campaign, simply put Firebird 3 banner  to your blog/web-site, and point them to

3) Social activity: starting with simple posts and «likes», then we will continue with contests and special prizes. Join Firebird in Facebook  ( ) and LinkedIn ( to be part of the action!

We believe that Firebird 3 will become the best version of Firebird ever, and to encourage you and all Firebird developers we prepared a lot of very interesting materials for Firebird Launch Campaign.

Stay tuned for Firebird 3 news!
September 23, 2014
 We'd like to invite you to the Firebird event of the year - The Firebird International Conference 2014.

It will last for 2 days, and takes place on October 24-25th, in Prague. The Conference will be devoted to 2 main topics: Firebird 3 features and Firebird performance.
With Firebird 3 Beta 1 (due to be announced next week) you will be in a position to start testing, doing development or considering migration to Firebird 3.0, and, since Firebird 3.0's SuperServer configuration shows three times better performance than Firebird 2.5 SuperClassic, it is probably not a bad idea!
(Note: There will be special sessions devoted to performance testing and comparison of Firebird 3,9 v's Firebird 2.5.)
Dmitry Yemanov and Vlad Khorsun (core developers of Firebird) will present detailed explanations of the new features in Firebird 3.0, with focus on its architectural changes and advantages which this new technology will give to Firebird users.
There will be two very special speakers at Firebird Conference: Ann Harrison and Jim Starkey (the original creator of InterBase), presenting interesting topics about multi-threading and orphan database pages.
There will be sessions devoted to the new abilities of performance monitoring with Firebird 3.0 enhancements, and a session about Firebird database recovery and how to avoid possible database corruption.
The developers responsible for the Firebird JDBC/.NET drivers will also be at the conference, so this is a good chance to ask questions about optimal performance and future development.
And, as usual, Firebird Conference is also is good place to meet with existing friends and make new friends, to find like-minded people and get invaluable experience and conversation.
For more details please take a look at the list of presentations.
The conference page with more details about the location and how to register is here:
Don't miss your chance to participate in the main Firebird event of the year!

Alexey Kovyazin
Firebird Project
July 30, 2014
The Firebird Project is pleased to announce Firebird Conference 2014: The most important international event devoted to Firebird. The Firebird Conference 2014 will be a meeting point for all Firebird users and developers of Firebird. It's the best place to share and receive Firebird knowledge!

The Firebird Conference 2014 will take place on October 24-25, 2014, in Prague, Czech Republic, at the Clarion Congress Hotel. Early Bird registration is available till August 15 only, so register now:

Here is the list of the most interesting topics at Firebird conference. It will be updated when new descriptions from speakers will arrive.
  1. Firebird release strategy and roadmap for 2015/2016, Dmitry Yemanov
  2. Firebird performance counters in details, Dmitry Yemanov
  3. Threading through InterBase, Firebird, and beyond, Ann Harrison and Jim Starkey
  4. Orphans, Corruption, Careful Write, and Logging, Ann Harrison and Jim Starkey
  5. Using Firebird trace & audit as tool for system analysis, Pavel Cizar
  6. Using Firebird monitoring tables as tool for system monitoring and analysis, Pavel Cizar
  7. Firebird database recovery: tools and techniques, Alexey Kovyazin
  8. Transactions: how they work inside Firebird, Dmitry Kuzmenko
  9. Firebird Performance tests: open-source framework to simulate real-world Firebird applications with heavy load, Pavel Zotov
  10. A year in the life of .NET provider, Jiri Cincura
  11. Using Azure cloud and Firebird to develop applications easily, Jiri Cincura
  12. Firebird and Node.js, Marius Popa
  13. Creating logs for data auditing, Carlos Cantu
  14. Understanding numbers in Firebird, Carlos Cantu
  15. Tips for using system tables, Ivan Prenosil
  16. Benchmarking Firebird with TPC-C, Paul Reeves
  17. Jaybird Status Update, Mark Rotteveel
  18. Using Firebird from Java (using Jaybird) with the help of jOOQ&Hibernate, Mark Rotteveel
  19. Overview of Red Database 2.5, Roman Simakov
  20. Firebird replication with CopyCat, Jonathan Neve

Dmitry Yemanov,
Firebird lead architect
Firebird release strategy and roadmap for 2015/2016

This session will be dedicated to post V3 development. It will outline the new release strategy to be established for the coming years, it will show what is being plabben will describes the primary goals for the future Firebird versions. An updated roadmap will be presented.

Firebird performance counters in details

The Firebird database engine internally maintains a number of performance counters that are exposed as runtime statistics via both monitoring tables and the trace facility. Firebird 3.0 improves on this by introducing lots of other performance counters. This session will provide an in-depth review of both existing and newly added counters with examples how to use them in both query profiling and bottleneck investigations.

Ann Harrison

Jim Starkey
Threading through InterBase, Firebird, and beyond 

From its original conception as Rdb/ELN, the design that became Firebird targeted the use of multiple processors to improve database performance. Computer architectures have changed radically over time and the process architectures of Firebird changed with them. What remains constant, is that database applications need all the power available to them, and the best way to get it is to increase the parallelism. Early versions of InterBase and Firebird in its classic mode used process-based parallel execution. That design suited environments before most operating systems supported threads. On VAX clusters, processes could run on different computers in the cluster. On multi-processor systems, the operating systems schedule Firebird processes on different processors on the same machine. One anomaly in the parallelism story is the SuperServer architecture of InterBase and Firebird prior to V3. SuperServer is threaded, but has only a single control stream and cannot run on multiple processors.

Having multiple threads in a single process has many advantages over a multi-process architecture on current multi-processor machines. Sharing the page cache means fewer copies of each page in memory, many fewer I/O operations, and of course, eliminates the need for interprocess communication.

Multi-threading is not simple. Introducing multi-threading into existing software is particularly challenging. Firebird has made major progress in Version3. Other database management systems have implemented more complex mechanisms to provide parallelism. This talk and paper will consider threading and parallelism and the challenges they present starting in the early eighties and continuing to consider a new model, created by Jim Starkey, that provides elastic scalability and distributed query processing.

Orphans, Corruption, Careful Write, and Logging

A frequent question on the Firebird Support list is "Gfix thinks my database is corrupt. How can I fix it?" The best answer may be to fix gfix itself so it reports benign errors differently from actual corruption. The most common errors reported by gfix can simply be ignored. From the beginning of InterBase to now, gfix is the least interesting of the utilities, so it's had little attention. However it requires a great deal of knowledge of database internals, so it's not easily replaced by a separately developed tool. So, from 1984 until now, gfix has reported major corruption and benign errors as if they were all the same.

What's a benign error? Usually, it's an artifact from the sudden death of a Firebird server that leaves obsolete record versions or even whole empty pages orphaned — neither released nor in use. Orphans represent lost space, but have no other damaging effect on the database. Orphaned record versions and pages occur because Firebird carefully orders its page writes to avoid the need for before or after logs. Database management systems that rely on logging for durability and recovery write each piece of data twice — once to a log and later to the database. Careful write requires discipline in programming. In 1984, careful write had performance advantages that more than made up for the need for careful programming.

This talk and paper explore the cause of "orphan" pages and record versions, Firebird's careful write I/O architecture, and the trade-offs between careful write and logging today.

Pavel Cizar,
Using Firebird trace & audit as tool for system analysis

Firebird trace and audit services were introduced in Firebird version 2.5. They provide extensive logging of various events that occur performed inside the database engine, such as statement execution, connections, disconnections, etc., that can be used to identify problematic spots in your system. However, these audit trails can be huge and very hard to analyse.

This session will present some challenges and solutions based on experience and usage of the trace and audit services at IBPhoenix.

Using Firebird monitoring tables as tool for system monitoring and analysis

Firebird monitoring tables are a less intrusive tool for system monitoring and analysis than the trace and audit services, because they provide snapshots of internal states rather than a continuous trail of events. However, using them effectively has it's own set of challenges.

This session will present some approaches and solutions based on experience with monitoring tables at IBPhoenix.

Alexey Kovyazin,
Firebird database recovery: tools and techniques

Why do Firebird databases become corrupted? How to avoid corruptions? These are popular questions from Firebird administrators and developers of Firebird applications.

This Session will be devoted to key corruptions and issues that can sometimes happen to Firebird databases, the session will detail the methods needed to fix them.

Dmitry Kuzmenko,
Transactions: how they work inside Firebird

This session is devoted to an explanation of how the internal transaction mechanism works in Firebird, in order to give developers practical recommendations on how to correctly handle transaction management.

Pavel Zotov,
Firebird Project QA
Firebird Performance tests: open-source framework to simulate real-world Firebird applications with heavy load

This Session is all about Firebird performance testing, and about an open-source framework created to simulate the heavy load of real-world Firebird applications using complex business-logic. The framework supports both Firebird 2.5 and Firebird 3.0, and utilises many Firebird 3 features. Comparison test results and tuning recommendations for Firebird 2.5 and Firebird 3.0 will also be presented.

Jiri Cincura,
Firebird Project, .NET driver developer
A year in the life of .NET provider

What's new and what's planned, an overview of changes made to the .NET provider, as well as new features and the expected direction of development for the coming year.

Using Azure cloud and Firebird to develop applications easily

A session to introduce developers in using Firebird on the Azure cloud and what it offers for a .NET developer. Focused on loosely coupled scenarios where part of the application can be run on-premise, or even written in different language, whilst other part(s) run on Azure and have the benefit of the .NET world and its scalability.

Marius Popa
Firebird and Node.js

An overview of Node.js and Firebird drivers with a examples (Express/Angular) and performance comparison : A native c++ driver vs a pure java script driver.

Carlos Cantu
Creating logs for data auditing

Sometimes you can have situations where users say that information has disappeared from the system or it has been modified without any intervention. In these cases, typically no user will take the responsibility for what has happened blaming the developer, the application or even the database. That's when audit logs become an extremely useful tool. Using logs, we can check everything that happens to our data (inserts,updates, deletes) as well as who and when it took place.

This talk will cover a real example of how to implement logs for data auditing in Firebird databases, using only the native features of Firebird 2.1 and 2.5. The information will be stored in log tables and can be accessed by standard sql (select), allowing the user to know who inserted, modified or removed any data, when the operation took place, the IP address of the system involved and what information has been affected. It will also show an example of keeping the log data both in production database as well as in an external log database as well.

Understanding numbers in Firebird

Firebird offers several datatypes to store numbers: integer, numeric, decimal, double precision, etc. Developers sometime have doubts about what is the best type to use for a specific purpose, e.g. storing monetary values, etc. The behaviour of some of those datatypes also depends on the dialect being used, and can affect even the precision of the retrieved values.

This talk will explore the different datatypes supported by Firebird to store numerical values, the differences among them, what care needs to be taken regarding limits and precision, and some "quirks" that can generate strange results like truncated values, retrieved values that are different from what was originally stored, etc.

Ivan Prenosil
Tips for using system tables 

To ensure your database is in good shape, you do not always need to use specialised tools. A quick look into the Firebird system tables can reveal lot of interesting things or warn about problematic or suspicious places in your database structure.

Paul Reeves,
Benchmarking Firebird with TPC-C

The tpc-c spec is designed to imitate an OLTP database application — which is very much the zone that many firebird databases occupy. This makes it an ideal candidate for benchmarking different firebird configurations.

In this session we start with a brief look at the tpc-c specification and how it needs to be modified to work as a benchmark for Firebird. We then look at what else is required to set up the test harness.

With the test harness in place we can then use it to examine the results of running the benchmark under various configurations. We will run tests that aim to provide answers to these sorts of questions:
  • Windows or Linux — which performs better?
  • Comparing Super Server and Classic Server performance.
  • Analysing performance degradation as concurrent user numbers increase.
  • What is the impact of the build up of back record versions on performance?
  • Finding the right balance of database cache and filesystem cache
  • Does intensive use of SSD RAID degrade compared to HDD RAID?
One thing is certain — once the data has been collected the resulting graphs always give us new insights into the behaviour of Firebird under load.

Mark Rotteveel,
Firebird Project, Jaybird developer
Jaybird Status Update

Current state of Jaybird development, new features in Jaybird 2.2 and 3.0, JDBC 4.2 (Java 8).

Using Firebird from Java (using Jaybird) with the help of jOOQ&Hibernate

JDBC is a relatively low-level API that requires a lot of boilerplate code. This is usually hidden with higher level APIs that make developer life simpler.

This session shows two different styles of querying database in Java: Hibernate is an Object Relational Mapper to map between Java objects and database tables, while jOOQ is a fluent API that gives you the flexibility and power of SQL in a typesafe manner

Roman Simakov,
Red Soft Corporation
Overview of Red Database 2.5

This session describes what Red Database is and how it's correlated with Firebird project. We'll talk about development process and main features which Red Database added to Firebird: a lot of security improvements, database file and network traffic encription, built-in engine record level replication, etc. Also roadmap and some interesting case studies will be presented.

Jonathan Neve,
Firebird replication with CopyCat

This talk is devoted to the Firebird replication with CopyCat components and CopyCat LiveMirror.

May 16, 2014
International Firebird Conference 2014

The Firebird Project is pleased to announce Firebird Conference 2014: The most important international event devoted to Firebird. The Firebird Conference 2014 will be a meeting point for all Firebird users and developers of Firebird. It's the best place to share and receive Firebird knowledge!

The main sponsors of the Firebird Conference are IBPhoenix and IBSurgeon.

The Firebird Conference 2014 will take place on October 24-25, 2014, in Prague, Czech Republic.

Firebird Tour Seminar in Moscow, June 2, 2014

Firebird Project invites to the next "All About Transactions" seminar in the frames of Firebird Tour: next stop in Moscow, June 4, 2014.

More details are here (in Russian).

Community News Index (

The news below was collected from FirebirdNews site. You can periodically visit the site or subscribe to its RSS feed to keep up to date in almost real-time with all the news coming from the Firebird community.

Community News

[May 15, 2014] Firebird International Conference is officialy announced

Firebird Project is glad to announce Firebird Conference 2014: the most important international event devoted to FirebirdSQL. Firebird Conference 2014 will be a meeting point for all Firebird users and core developers of Firebird. It's the best place to share and receive FirebirdSQL knowledge!

Firebird Conference 2014 will be October 24-25, 2014, in Prague, Czech Republic, in Clarion Congress Hotel (see details about its location).

There will be 2 simultaneous flows in the conference, during 2 full days.

More details about the Conference can be found in

[May 15, 2014] #Node Firebird driver: node-firebird-libfbclient can be build and used on MacOS X

Latest version for Node C++ Module for Firebird from git can be build on MacOSX fixing Linking flags (against regular Firebird installation)

[May 12, 2014] Active Record Firebird Adapter for #Rails updated to version 0.8.8

Active Record Firebird Adapter 0.8.8 is updated with a few cleanups and fixes: Merge pull request from Ray Zane: Use @config instead of @connection_params. Fix sequence name limit.

[May 07, 2014] Ruby Firebird Extension Library — Fb bumped to version 0.7.1 with a few fixes

Version 0.7.1 is on RubyGems now. With following changes and bug fixes: Fix naive rounding logic affecting negative scaled values. Update for current rubygems, add license MIT like ar adapter, add rakefile. Fixes error: ‘isc_info_db_SQL_dialect’ undeclared (first use in this function) replaced in Firebird 3.0 and marked as deprecated from firebird 1.5.

[May 07, 2014] Sparx Systems — Enterprise Architect 11 uses Firebird

Sparx Systems now has a fully intergrated Firebird backend Database for its Enterprise Architect application

[May 02, 2014] Database .NET 11.2 released

Database .NET is an innovative, powerful and intuitive multiple database management tool, With it you can Browse objects, Design tables, Edit rows, Export data and Run queries with a consistent interface.

What's New (2014/05/02)
You're welcome to download the Database .NET right now at:

Free, All-In-One, Portable, Standalone (No Installation) and Multlanguage. Supported Platforms: Windows All (x86/x64)

[April 29, 2014] Database Workbench 4.4.6 released

Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: "Database Workbench 4.4.6 Pro". For more information, see here.
The Free Lite Editions will be released at a later stage. Database Workbench supports:
  • Borland InterBase (6.x - XE )
  • Firebird ( 1.x, 2.x )
  • MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express )
  • MySQL 4.x, 5.x
  • Oracle Database ( 8i, 9i, 10g, 11g )
  • Sybase SQL Anywhere ( 9, 10, 11 and 12 )
  • NexusDB ( 3.0 and up ) You like this news?
Twitter it! Share it! Check out the PromoProgram!

[April 29, 2014] Firebird for Android may arrive soon

Alex Peshkov commented in the fb-devel list that he plans to start working in a port of Firebird 3 for Android right after FB 3 Beta 1 is released. Beta 1 is supposed to be out in this quarter.

[April 28, 2014] Firebird Classic 2.5.x with xinetd on Ubuntu/Debian systems

By default Firebird Classic package uses openbsd-inetd You can inspect the config cat /etc/inetd.conf the max number of connections per minute is 255 after nowait you can suffix this field with a period, followed by the maximum number of connections authorized per minute for example nowait.10000 localhost:gds_db stream tcp nowait.10000 firebird /usr/sbin/tcpd /usr/sbin/fb_inet_server

To switch to xinetd an easier to use and popular alternative sudo apt-get install xinetd

This will stop openbsd-inetd and will start xinetd alternative You can inspect it with cat /etc/xinetd.d/firebird25

There are a few issues with default config and it will be cleaned in the next firebird-classic package versions. A good config should look like this where i configured an unlimited numer of instances per source (also you can tweak the cps)

[April 27, 2014] Jaybird 2.2.5 is released

Download links and information on Jaybird wiki page

[April 24, 2014] Planning the Firebird v4.0 development

Dmitry Yemanov wrote on Firebird-Devel mailing list:

We're getting closer to the v3.0 feature freeze which is going to happen this summer. Everything roadmapped for v3 but not implemented before the deadline will be postponed. The next-after-v3 release is likely to incorporate most of the postponed features, but there may be new features as well. So it makes sense to start discussing what could and should be done in the next version(s). We have a few months to collect the proposals, discuss technical details and make estimates about the required efforts.

This message is the invitation to both project members and users who closely follow the development. If you want to discuss something for potentially including into the new version(s), feel free to do that in separate threads. Please be prepared to protect your opinion and discuss the details, simple votes "I like feature X" don't count. A tracker ticket for the feature request is appreciated, please add its URL to your post.

Just for the reference, the top-voted tickets can be found here in jira

The ongoing results of the planning stage will be published on our website and scheduled for the next version(s) by the project admins.

[April 23, 2014] Firebird Tour: seminar in Moscow, June 4, 2014

Firebird Project invites you to the next "All About Transactions" seminar in the frames of Firebird Tour: next stop in Moscow, June 4, 2014. More details are here (in Russian).

[April 23, 2014] Mezzanine 3.1.1 released and is stable with firebird driver for Django 1.6.x

Mezzanine 3.1.1 is released and is considered stable with firebird driver for Django 1.6.x Updated instruction for Firebird are here.

[April 23, 2014] Firebird backend for Django 1.6.x stable version released

Firebird backend for Django 1.6.x stable version (final) is released on pypi (now with wheel support)

[April 22, 2014] New Database Mirroring Product: CopyCat LiveMirror

Microtec is pleased to annonce a new product for Firebird database mirroring, called CopyCat LiveMirror. Based on our CopyCat replication engine, LiveMirror is a simple to use tool geared specifically towards setting up a mirror of your production database for failover / backup purposes. LiveMirror is easy to setup, reliable, and affordably priced at 49 EUR per licence.

For more information about LiveMirror, please have a look at our product page here.

[April 22, 2014] TurboBird 1.0.2 stable version is released

TurboBird 1.0.2 is released as a stable version Changes: Adding Auto commit option. Minor bug fixes

[April 17, 2014] Current status of the Firebird bugfixing : Tracker Roadmap

Here in Tracker is the current status of the Firebird bugfixing for the next releases Firebird 2.5.3 and Firebird 3.0 Beta 1

[April 16, 2014] Firebird Language basic Reference ready This Year

Paul Vinkenoog wrote on firebird docs list

This is just to let you know that I'm making time available for the Language Reference this year. I'm working on the DML chapter now, and I'm somewhere in the middle of the SELECT statement. All the others are finished (the other DML statements, that is — not the other chapters!)

I will do my utmost to have a "basic" Language Reference ready this year, i.e. possibly without all the details on Dialect 1 and other things that people can hopefully live without for a while (or grab the IB6 LangRef if they can't).

Once finished, updating it to Firebird 3 shouldn't be a hell of a job.

But it ain't finished yet.

[April 15, 2014] pyfirebirdsql Version 0.9.3 is released with alternate crypt support for Windows

pyfirebirdsql Version 0.9.3 is released with alternate crypt support for Windows and a few refactorings pyfirebirdsql is included now in FreeBSD ports collection

[April 15, 2014] ADO.NET provider for Firebird is ready

ADO.NET provider for Firebird is ready

[April 14, 2014] FirebirdSQL driver for Go (golang) with support for Firebird 3.0 Auth protocol (SRP)

Hajime Nakagami created a Firebird SQL driver for Go with support for Firebird 3.0 Auth protocol (SRP) in pure golang

[April 11, 2014] Redsoft Database (based on Firebird) used in GosLinux systems for FSSP

Management of Information Technology of the Federal Bailiff Service (FSSP) Russia announced a new phase of implementation of the free software and "import information technology" — the appearance of their own GNU / Linux distribution called GosLinux.

GosLinux distribution is based on CentOS 6.4 and created by "Soft Red" in 2013 after a win of the Russian company in the competition for revision, implementation and maintenance of automated information systems for FSSP Russia. In the server infrastructure of the territorial distribution of the FSSP Russia CentOS was used since 2012, and now all units bailiff service can use a specialized system, which received a FSTEC certificate at the end of March.

Among the major software components of the distribution used in the FSSP Russia, referred to the: Apache Tomcat application server and "Red Soft" database based on relational open source database Firebird. And another article here

ps: Sorry for google translation

[April 10, 2014] FB TraceManager V3.5.1 has been released

FBTM_V3_48x48 Upscene Productions is excited to officially release FB TraceManager V3.5.1!

This release adds support for pre-defined purge options of stored trace data. Minor issues have been fixed as well. More information is available here

Or also directly in the V3.5 what's new section of the online product documentation: 

More information on the product is available in the FB TraceManager section on our website, including an edition comparison sheet, webcasts etc. Thanks for your continued support.

[April 08, 2014] How to patch, build and debug PHP extension: PDO Firebird

Vjacheslav V. Borisov wrote a tutorial on how to build and debug PDO Firebird driver:

I noticed that there is too many bugs open and too few developers who can do the work. And even this list is almost dead. Don't know what is the cause of that, but may be it is just hard to start ? I recently written some patches for php — work, which I never done before. And i can say, this really not so hard, if you know C/C++ (or at least php?) and linux. Most troublesome work is to setup build environment, so i decided to write instruction how to patch, build and debug PHP extension, so may be more web developers can contribute to php.

[April 04, 2014] Advanced Solutions How to : Coordinating transactions for multiple connections in single call

Leyne, Sean asked on Firebird-devel (You can read in that thread the details about problem requirements and proposed solutions)

Consider a large database (200GB, large tables with 450 Million rows) which is running on a kick-a** server with pool of enterprise SSDs for storage (more IOPS then Firebird could ever use), which I need to extract data from on a regular basis throughout the day for use by an external BI system. During the business day, the database is Live with over 300 connections active with 1 million+ DB transactions. I need to extract the BI data as a true "snapshot" of data (ensuring FKs are valid), in as short a timeframe as possible. Because runtime is critical, I want to break the extract process into logical pieces and run each piece is a separate process/thread (with its own connection) (aka run in parallel).

[April 03, 2014] Firebird in Calligra Office Suite discussion on calligra devel list

Discussion was on kde.devel.calligra there is a need for Firebird driver implementation in Kexi in the future. Any contributors for the new kexi driver?

[April 03, 2014] Java needed to run LibreOffice Base Database? No with Firebird SQL

You can try to use the Firebird Database within LibreOffice which doesn't need Java. This feature is still marked as experimental. Firebird Databases are available since LibreOffice 4.2. (see the release notes for further information To turn the experimental features on, you have to go to the Settings --> LibreOffice --> Advanced --> "Enable experimental features" (see screenshot bellow) Then you can uncheck the Java from the same Dialog.


There are few components written in Java if you use them: The Wizards, Report Builder, and Report Designer sub-components are written in Java. Full list of Java dependencies here. Original question and source is on To make Firebird Embedded default database in the new database dialog open Expert Configuration and change this key org.openoffice.Office.DataAccess/EmbeddedDatabases/DefaultEmbeddedDatabase/Value to sdbc:embedded:firebird

[April 01, 2014] Hopper v1.5.0 — stored routine debugger — now available!

Upscene Productions announces a new release of: "Hopper — a Stored Code Debugger"
Hopper is a Stored Routine and Trigger Debugger, available for Firebird, InterBase and MySQL.

For more information and a trial download, see the news @ Upscene Productions, pricing information is available.

Bugfixes include CHAR issues with InterBase and Firebird and a CAST error in MySQL.

You like this news? Twitter it! Share it! Check out the PromoProgram!

October 11, 2013
Firebird Tour is a series of seminars around the world in 2013 and 2014, devoted to Firebird, with members of Firebird Project as speakers.
The first seminar will be in Siegburg (Germany), November 22, 2013 (early bird registration is over, few places at regular price still available).
The second stop of Firebird Tour will be in Prague (Czech Republic), November 25, 2013.
Firebird 2013 Tour will be devoted to all aspects of transactions, from the basic idea, to the internal implementation, best practices and guidance how to effectively use transactions in the applications, and, of course, performance analysis of transactions and related areas.
List of topics to be covered:
  • -   Transactions from the beginning: isolation levels and specific Firebird parameters (no_rec_version, table locking, read/write, wait/nowait), examples of their usage
  • -   How to use effectively isolation levels and parameters in multi-user applications, typical errors in transactions management
  • -   Internal implementation of transactions in Firebird, including versioning, locking and multi-generation mechanism
  • -   Garbage, sweep, auto-sweep: what are they and how to make them work for you and not against you
  • -   Effective management of transactions in various development tools (Delphi, Java, .NET, etc)
  • -   Transactions monitoring: transaction markers, MON$ tables, Trace API, third-party tools, how to find bottlenecks in transaction management and optimize database performance with monitoring
  • -   Best practices of transaction management, special approaches to optimize transaction in closed sourced applications.
  • -   Overview of Firebird 3.0 features
The detailed schedule of talks will be published later.
Languages at seminar will English and Czech. Organizers of Firebird Tour are IBSurgeon Ltd ( and IBPhoenix (
Firebird seminar in Prague will take place in Hotel Extol Inn (, November 25, 2013, from 09-00 to 18-00.
Attendee’s fees
Attendee’s fee includes seminar attendance, coffee-breaks, lunch and beverages. Room is not included.
Early bird registration is available till November 1, 20, 2013. 
Early bird registration is EUR 25 
(, for group of 3+ attendees - EUR 19/person 
Regular price registration (after November 1, 2013) is EUR 35, for groups  3+ - 29 eur/person.
There are limited seats, so please take your chance and register as soon as possible.
Please feel free to ask any questions to organizer’s email
Home About Firebird Documentation Downloads Community Support Development Case Studies Back to Top
This site and the pages contained within are Copyright © 2000-2015, Firebird Project. Firebird® is a registered trademark of Firebird Foundation Incorporated. Developed by DQ Team.