Steve Naidamast kindly sent me his personal review of my Firebird 3 Migration Guide. I’m more than happy to share it here:
The Migration Guide to Firebird 3.0 is an excellently written technical manual that is filled with all the essential information anyone wanting or needing to work with Firebird 3.0 (now 3.0.x) will require.
Though called a migration guide, this well designed manual provides far more information than simply being relegated to how to move between earlier versions of the Firebird Database Engine and the most recent version of this highly capable database system. As a result, far exceeding the discussion of moving between database systems, this guide provides thorough explanations in detail on the various, unique server types that Firebird offers and how to decide which one is the best option for the requirements at hand, the necessary security configurations for each type of server and how to define users and their associated roles, enhancements to the PSQL language (the SQL variation used by Firebird), discussions on physical access to the server (ie: wire protocols), connection string enhancements, and last but not least, discussion on the Firebird Embedded Database Engine for desktop application development, which has been upgraded from the current 2.5 version.
Though written from the perspective of the needs of a Database Administrator, this manual should be an addition to any professional’s library who is serious about working with Firebird for the long term.
It is by far one of the superior manuals I have read over the years on the subject of database systems. Such manuals should surely aid in the growth of the Firebird Community so that this database system can take its rightful place among the current standards of use in today’s database application development endeavors…
Sr. Software Engineer
Black Falcon Software
The Migration Guide to Firebird 3 is available both on paper and PDF formats.
DBMS migration in LibreOffice continues with HSQLDB binary import
I’m proud to announce a new update to my Migration Guide to Firebird 3 eBook! The changes in revision 1.20 are mostly concentrated in the chapters about Connecting to Firebird 3 using an old client library, Testing application’s queries, Jaybird, .NET Provider and the two new sections about permissions for creating databases and for generators and exceptions.
In the next days, all those who already bought the eBook will receive an email with instructions about how to download the new revision.
The printed version
will also get updated asap is already updated to 1.20. Those who already bought the printed book (rev 1.02) can email me to receive a PDF with the changes.
Click here for more information and to buy the eBook.
IBSurgeon is offering 10% discount on the HQBird Standard to all buyers of the eBook. More information here.
The first pre-beta release of the English version of the Firebird 3 Develoepers Guide is now publicly available. Please report any problems or mistakes. The translation work, from Russian to English, was sponsored by a crowdfunding campaign. Thanks to all who contributed!
The first version (200 pages) of the German translation of Firebird 2.5 Language Reference is ready – you can download it here.
Many thanks to Martin Koeditz, the editor of German version!
Here is an article describing some points to consider, when moving from an older version to Firebird 3. It is a starting point for those who plans to upgrade their installations and wants to save from some headaches.
Things to consider when migrating to Firebird 3
It is easy to get a powerful server if you are ready to spend many $$$: there are leading vendors like Dell, HP, and many less known hardware companies, they will be happy to sell you a powerful machine.
However, money is always a problem, especially for small businesses and start-ups, so there is a great demand for «good-enough» cheap solutions.
The new article from IBSurgeon describes the practical approach for building «good-enough» database server with the sufficient performance for small business. It also contains calculations and links to the specific products we recommend.
The recording of the HQBird presentation at the 14th Firebird Developers Day is now publicly available here. Speaker’s audio is in English, but there is consecutive translation to Portuguese.