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.
Firebird 3 was released almost a year ago and it has already got two minor releases. But there is still no official packages for MacOS. So this post is about my humble attempt to build it on MacOs from source code. Most of the instructions are taken from Paul Beach’s Firebird Devel list post or from his blog.
Read full article here.
Page is updated for Firebird 3 by Dimitry Yemanov
This document outlines how much Firebird conforms to the current SQL standard. Please note that the following information is not a full statement of conformance, but just information for those interested in the subject.
So, Firebird 3.0.1 is out, and you are planning to move to it. But are you prepared for this task? Migrating to previous versions was usually an easy task, but is this still true for Firebird 3.x? Answer the following questions to know if you are really prepared to move to Firebird 3!
1) Can I connect to a database created in Firebird 2.5, using Firebird 3?
- Yes, as it always happened in the previous versions!
- Firebird 3 cannot access databases created in older versions of Firebird, so it is necessary to PUMP the data to an empty database created in Firebird 3.
- Firebird 3 only access databases created with ODS = 12, so it is necessary to do a backup (gbak) before migrating to Firebird, and restore it in Firebird 3, to updated the ODS.
- Yes, but first you need to run gfix with the new parameter -ods=12 to updated the ODS of the database.
2) Is it correctly to say that Firebird 3 finally solved the problem of someone stoling the database file and access all its data?
- Of course, since now Firebird 3 comes with native database encryption!
- Yes, if you enable encryption in the database file, the security is guaranteed!
- Yes, if you create a good/safe encryption plugin, and take all precautions regarding dealing with the encryption key.
- Unfortunately, there is no way to avoid the stolen database file to have its data accessed.
3) Regarding SYSDBA, we can say...
- Firebird 3 doesn't even requires the existence of an user named SYSDBA.
- SYSDBA needs to exists, since he is the Firebird's administrator.
- The SYSDBA user is now called ADMIN.
4) What is the name of the Firebird executable on Windows?
- It depends on the selected architecture.
- For SuperServer, it is fbserver.exe. For Classic, it is named fb_inet_server.exe. For SuperClassic, it is fb_smp_server.exe
- Firebird 3 doesn't has an executable anymore, only a DLL which is plugged directly to the Operating System as a service.
5) Regarding the enhancements in the Firebird's communication protocol, to make it more efficient in high latency networks, we can say:
- In general, the data retrieved by selects will be transferred faster to the client.
- In general, the data retrieved by selects will be transferred much faster to the client, unless you are transfering blobs.
- Not only the selects, but insert, delete and update operations also became faster with the enhancements.
- Better user text files for storage! Databases are devil stuff.
6) It is impossible to connect to a Firebird 3 server using and older client library (fbclient). This statement is:
- Correct. Firebird 3 enhanced security forbids insecure connections from older client libraries.
- Incorrect. Disabling the wire encryption and enabling the legacy authentication plugins, older fbclient will be able to connect to Firebird 3.
- Incorrect. By default, older clients can connect to Firebird 3.
- Correct, but Firebird 3 will accept the connection only if the user is member of the Firebird Foundation.
7) What about centralized users?
- Firebird users are still centralized in the security database.
- The Developer/DBA defines for each database file, if its users will be stored locally or not.
- Firebird chooses automatically if the user being created will be stored locally or in the security database.
- Nothing changed compared to the previous versions.
Wanna save some precious time when moving to Firebird 3?
Buy the Migration Guide to Firebird 3 book right now!
Available in digital and printed formats.
The “Migration Guide to Firebird 3″ is now available in printed format too. Now people can choose to buy the digital version (PDF) or the Printed version. More information and buying links can be seen here.
The source code was just tagged in the repository, so we can expect the final release being out in the next days!
Are you prepared for Firebird 3? The Migration Guide to Firebird 3 eBook is here to help you to move quickly to Firebird 3. The eBook is available in English and in Brazilian Portuguese.
The Portuguese version of my new eBook, Guia de migração para o Firebird 3 (Migration guide to Firebird 3) was just released! The book has tips and explanations to make the life of anyone who wishes to move to Firebird 3 easier.
An English version of the guide will be available in the following weeks at Amazon, both in paperback and digital formats. This is my third book devoted to Firebird, and the first one to be published also in English.
Brazilians can buy the guide right now in the FireBase on-line store.
Carlos H. Cantu
The survey about Firebird 3 installer is closed, and results are now published (see below).
Thanks to everyone who participated and contributed with comments and ideas. I hope the result will help guiding the Project about what people expect/wants from the official installer 😉
The Firebird Project needs your opinion regarding some points in the Windows installer of the upcoming Firebird 3.0 final release. Please answer the survey available at https://eSurv.org?u=fb3installer based on your preferences.
Your answer can help to guide us in future enhancements. Survey will be online until 20-Nov-2015.