Firebird Database Version 3.0 Released
Firebird Database Version 3.0 Released
Written by Kay Ewbank   
Monday, 25 April 2016

The latest version of the open-source Firebird SQL relational database has been released with a unified server architecture, improved support for SMP and multiple-core hardware platforms. 


Firebird began life as a fork of the open-source version of Borland Interbase back in 2000. Since then the code has essentially been rewritten, and Firebird is now available for Linux, Windows and Mac OS X. This latest version has undergone the largest reworking of the architecture since that initial release back in 2000.

The new multi-threaded engine processes and shared page caching have been designed to make better use of multi-core hardware and large address spaces, so providing what the developers describe as "dramatic performance increases". The new version also has improved threading of engine processes, and options for sharing page caches across thread and connection boundaries.

Firebird 3.0 has also been improved in terms of its SQL support, with added window and statistical functions. Support has also been added for the Boolean data type and the associated logical predications.

The security features have been improved with the addition of wire and database encryption, along with and multiple security databases. The performance of the garbage collection and incremental backup has also been improved.

Another change to the new version is the addition of a new public API that replaces the legacy one in new applications, especially object-oriented ones.

The main difference between the new API and the legacy one is that user defined routines (UDR)  can query and modify data in the same connection or transaction context as the user query that called that UDR. It is now possible to write external triggers and procedures, rather than being limited to external functions (UDFs).

According to developer Alex Peshkov, the old API had too many limitations:

"High on the list was the limitation of the 16-bit integer pervading the legacy API, encompassing message size, SQL operator length, BLOB data portions, to name a few examples. While 16-bit was probably adequate when that old API came to life, in today's environments it is costly to work around."


The new version is available now in 32 and 64 bit versions for both Windows and Linux.OS X and other platforms will be available "soon".


More Information

Firebird 3.0 

Related Articles

MySQL 5.7

SQLite 3.9

Amazon Launches Supercharged MySQL Alternative


To be informed about new articles on I Programmer, sign up for our weekly newsletter,subscribe to the RSS feed and follow us on, Twitter, FacebookGoogle+ or Linkedin



Google Provides Free Machine Learning For All

Google's Machine Learning Crash Course has already been delivered to more than 18,000 Googlers and now it it have been made available for free and to all as part of Learn with Google AI, a new ed [ ... ]

Google Summer Of Code 2018 Student Applications Now Open

Google Summer of Code, which gives students an opportunity to make a substantive contribution to Open Source projects with the motto "Flip  bits not burgers", has recruited more mentoring organiz [ ... ]

More News




or email your comment to:

Last Updated ( Monday, 25 April 2016 )

RSS feed of news items only
I Programmer News
Copyright © 2018 All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.