A Christmas gift is coming?
Ho Ho Ho… One of the Santa’s reindeers told us that we may find a nice Christmas gift in the following days. Firebird 4 Beta 1 should arrive with the replication engine ready for testing! Stay tuned for more news…
Author: Cantu
I'm the owner of the www.Firebase.com.br site and the author of the books Firebird Essencial, Firebird 2 and Migration Guide to Firebird 3. Loving Firebird even before it was born!
Migration Guide to FB 3 – Cyber Monday promotion!
From today up to 26-November, the Migration Guide to Firebird 3 eBook (PDF version) is being sold for USD 12 instead of USD 16. The promotion is valid only for payments done using Paypal.
If you haven’t moved to Firebird 3 yet, this is a great chance to buy the Migration Guide for a lower price, and save you some hours of headache.
Click here for more information and to buy it online.
[PROMOTION ALREADY ENDED]
RAD Studio 10.3 support for FB 3
RAD Studio 10.3 (Rio) was released today, and includes updated FireDac components with official support to Firebird 3. Check all the new features here.
Improvements for Firebird
- Support for Firebird v 3.0, including new:
- local connection protocol.
- FB$OUT package.
- isc_database_info() information items.
- Statistics feature in gbak output.
- Support for statement length > 64Kb.
- New TFDFBOnlineValidate component.
- New GUIDEndian=Little|Big connection parameters.
Firebird 3.0.4 sub-release is available
Firebird Project is happy to announce general availability of Firebird 3.0.4 — the 4th point release in the Firebird 3.0 series.
This sub-release offers many bug fixes and also adds a few improvements, please refer to the Release Notes for the full list of changes. Binary kits for Windows, Linux and Android platforms are immediately available for download, Mac OS kits will follow shortly.
Please note that some of the changes includes a new ODS minor version (12.2) for some platforms (Windows and Intel Linux will keeps using 12.0) and a new parameter Srp256 (SHA-256) for AuthClient and AuthServer. Be sure to read the release notes to be aware of all the improvements and bugfixes.
Still using an old Firebird version? Migrate now and don’t forget to read my Migration Guide to Firebird 3 to save you a few hours of headache.
Firebird_fdw 0.4.0 for PostgreSQL
FYI I’ve just release firebird_fdw 0.4.0 for PostgreSQL.
This update, together with an update of the underlying Firebird API wrapper libfq to version 0.3.0, is a general cleanup/bugfix release, with improvements including:
– new function firebird_fdw_version()
– bug in INSERT … RETURNING … fixed
– miscellaneous minor bug fixes and code cleanup
– TAP regression tests have been addedCentOS rpm packages are available via the Fedora Copr build system.
See: http://sql-info.de/postgresql/firebird-fdw/firebird-fdw-0.4.0-released.html
Regards
Ian Barwick
15th Firebird Developers Day – Report
The report of the 15th Firebird Developers Day conference, due in Brazil at August, 18 2018 is now published, both in English and Portuguese.
Check it out and get to know the biggest Firebird conference in the world!
Last week to register for the 15th FDD
[This is mostly for Brazilians]
The online subscriptions for the Brazilian’s 15th Firebird Developers Day conference will end on Friday, August 10. The attendees of the conference will be able to buy several tools and components with exclusive discounts from our sponsors and supporters: IBSurgeon, FastReports, uniGUI, TeeChart, IBObjects, IBExpert, Woll2Woll, ACBr and Gnostice.
Visit the conference site to check all the information and register for the conference.
15th Firebird Developers Day
Only for Brazilians:
O 15º FDD acontecerá em Piracicaba – SP, no dia 18 de Agosto de 2018, e contará com a presença mais do que especial de Vlad Khorsun, um dos principais core developers do Firebird! Vlad é responsável pela implementação de alguns dos recursos mais interessantes e úteis do Firebird, como Execute Block, Global Temporary Tables, CTe – Common Table Expressions, além de aperfeiçoamentos no nBackup, execute statement, etc. Alexey Kovyazin, especialista em recuperação e otimização de bases de dados, estará mais uma vez presente além, é claro, de vários nomes da comunidade brasileira. A grade de palestras ainda não está completa, mas já é nítido que o assunto performance terá um grande foco nessa edição. Inscreva-se agora, garanta sua vaga e pague menos!
Migration Guide to Firebird 3 (review)
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…
Steve Naidamast
Sr. Software Engineer
Black Falcon Software
The Migration Guide to Firebird 3 is available both on paper and PDF formats.
The Frustrations of the long distance Database Application Developer
Though I have extensive database application development experience, I do not consider myself an expert with the Firebird Database Engine to any degree. The following article is completely based upon observations and experiences during my attempts to learn and understand this highly capable engine. As a result, if there are misunderstandings or mistakes I have promoted in my writing, please do not hesitate to send in comments either correcting them or offering alternatives.
See full article here.