This package is meant to enter experimental, due to the high pace of upstream
development. Its goal is to provide easy testing of the new features of
Firebird and to have early exposure of the packaging helping to discover any
firebird3.0 is the third group of packages for Firebird. Squeeze is going to
release with firebird2.1 and firebird2.5. The plan for wheezy is to drop
firebird2.1 and add firebird3.0, if that has proven stable by the time wheezy
approaches releasable state.
Preliminary packagiing is available at
Firebird 3.0 represents the project’s next milestone release and it currently
gets the most of the development efforts. It’s going to offer some important
and highly anticipated features that were promised for a long time already.
* Revised architecture, including new authentication and configuration
* Scalable (SMP/multi-core friendly) multi-threaded engine with a shared page
* New ODS (version 12) with new system and monitoring tables
* External (Java, C++, etc) stored procedures/triggers/functions
* Reworked optimizer and new data access methods
* Security enhancements
* Various SQL extensions
Thhe first alpha release is planned for Q1 2011
released in Q1 2011
Be aware that the ODS (on-disk structure) hasn’t been finalized yet, so
databases could be incompatible between different unstable builds and you’ll
have to either recreate them or migrate them via backup/restore.
Posted By Adriano dos Santos Fernandes on his blog:
Here I’m going to explain how Firebird DDL commands works in the architecture, why it stops innovation and how it is supposed to work in Firebird 3.0.
FB/Java is a plugin for FB external engines feature, to be presented in
v3.0, that allows execution of Java code at the server side. The plugin
allows classes/resources in the file system or stored in the database.
File system classes/resources are global and the code run with all
permissions. Database classes/resources are per-database and code runs
accordingly with per-engine configured security policy.
Also it seems that is quite fast from Adriano’s tweets
Hello, Dear Firebird Team Members!
After almost two years in development, four betas and four release
candidates, Red Database 2.1 is finally released.
Information about the release is present here:
We are not interested at all in forking basic engine functionality, so
here are my thoughts on what major features Red Database engine has, and
how they can me merged into Firebird:
We’re pretty much in sync with Firebird HEAD regarding this feature.
Roman Simakov and our QA team collaborate very effectively with Dmitry
Emanov. Nothing special needs to be done.
Java Stored Procedures
Implementation is based on the same original ideas as ExtEngines branch
and earlier implementations, is simple and rugged. Can serve as proof of
As ExtEngines work progresses parts of our infrastructure should become
unnecessary and the feature should converge into single code base.
We hope that Eugeny Putilin collaborates further with Firebird team, so
Firebird project can gain from our experience (and maybe replicate our
system tables structure).
While testing we gained quite a bit of understanding of JRE behaviors in
From Firebird project point of view, this is very experimental feature,
which shows how complete working full-text-search can be implemented for
I ask project members to review it from the architectural standpoint. It
is implemented as ESPs in Java. When the feature becomes architecturally
stable, we may want to migrate it to Lucene C.
Again, Eugeny Putilin have done most of the work, and should be in a
position to help.
PSQL debugger for SP/triggers
Proof of concept implementation, which currently uses CORBA for
communication with debugger on the client side, and server-side debugger
engine implemented in Java. We have discussed with Eugeny that Y-Valve
can be extended to accomodate communication with debugger via the
variety of supported protocols (INET, XNET, etc). Server-side Java
helper on the server side becomes unnecessary in this case. We’re not
planning to extend it much further from what is done now, but debugger
API works, in can be re-worked and polished by the community and user
The feature set aims to ensure complete coverage of ISO 27000 standard
requirements which can be implemented by the database engine.
There are similar projects for PostgreSQL (see SE-PosgreSQL), MySQL and
commercial DBMS, but we hope our approach is much more comprehensive.
However item-by-item consideration needs to be given to the features for
merging. For example, Trace API has been in use for years already, and
is quite stable.
Extensions for using it as the audit trail tool were simple and should
not cause problems. RBAC rework (e.g. access checking for GENERATORS and
DDL operations, cumulative force of roles assigned to the user) can be
merged in a relatively straightforward fashion. Things related to
cryptography and row-level security obviously need more work and
architectural review before they can be merged into Firebird.
There are also NBACKUP stabilization changes and Trace API feature,
which in my opinion can make their way into Firebird in 2.5 time frame,
subject to Roman Simakov (or somebody else) availability to perform the
Additionally we have designed “External Engine sandboxes” feature, using
the same extensions as XNET/INET communication mechanism for debugger to
communicate with ESP running in separate processes, but this work is
unlikely to progress further in the nearest future. No code was written
to implement this design to the best of my knowledge.
All features have detailed specs, but in Russian only. Unfortunately,
not all our specialists and contractors are proficient in English.
Release notes describe all the features in still bad, but hopefully
Source code is included with the install packages. Internally, patches
are kept in merge-friendly form in an SVN branch growing from hand-made
Firebird baseline (currently based on two-month-old Firebird HEAD +
We hope that working implementation of some of the features targeted for
Firebird 3.0 release can make it become available sooner.
Thanks and Best Regards,
Nikolay Samofatov, MBA
Red Soft International