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. 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 Firebird Developers Day is an annual Firebird conference that happens in Brazil. So far, it was mainly a Portuguese speakers conference, but this year, when FDD completes its 15th birthday, we are checking the possibility to receive international attendees too. The conference date is August, 18 2018.
The first thing we need to do is to figure out if people outside Brazil has interest to participate in FDD. So, if you live outside Brazil, and would like to come to the 15th Firebird Developers Day, answer this 3 questions survey and let us know!
Firebird Project is happy to announce general availability of Firebird 3.0.3 — the third point release in the Firebird 3.0 series.
This sub-release offers many bug fixes (including fix for a recently reported security vulnerability) and also adds a few minor features and improvements, please refer to the Release Notes for the full list of changes. Binary kits for Windows and Linux on both 32-bit and 64-bit platforms are immediately available for download.
Microsoft, Apple and several Linux distros started to distribute patches to try to fix the recent security flaws found in Intel, AMD and ARM CPUs, in almost every CPU released in the last 20 years. The security flaws are known as Meltdown (affects Intel) and Spectre (affects Intel, AMD and some ARM processors).
The flaw allow softwares to access protected memory areas that should be accessed only by the Operating System kernel, and get sensitive data, like passwords, etc.
There are two problems with the fixes:
- They do not fix 100% of the problem, since it is related on how the CPUs were designed. So far, there is no 100% solution for the problem, and probably it will never exists.
- They impact badly in performance.
In a recent post to firebird-devel list, an user reported that the performance of the Firebird server dropped ~30% after he upgraded its Linux kernel to a version that “fix” those security flaws.
General reports over the internet shows that the most affected areas of the system are CPU, RAM and Disk, so any software that makes intensive use of some of those areas will probably have its performance significantly degraded.
Just to be clear: this performance loss doesn’t affect only Firebird, but any software!
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
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.
SouchProd.EntityFrameworkCore.Firebird is an Entity Framework Core provider built on top of the Firebird ADO.NET Data Provider. It enables use the Entity Framework Core 2.0 ORM with Firebird (2.x, 3.0) and Interbase.
CRUD operations are working (insert, update, delete, select), Scaffolding and migrations too (still contain a few bugs, some scenario could lead to an exception). Firebird 3 Identity columns are supported. Firebird 4 Alpha metadata charlength limitation (63 vs 31 before) supported.
Check more here.