Migration Guide to Firebird 3
Learn more.
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!
Firebird 3 is released!
Press Release: English | Russian | Brazilian Portuguese
The primary goals for Firebird 3.0 were to unify the server architecture and to improve support for SMP and multiple-core hardware platforms. Parallel objectives were to improve threading of engine processes and the options for sharing page cache across thread and connection boundaries.
Alongside these aims came new strategies to improve performance, query optimization, monitoring and scalability and to address the demand for more security options. A number of popular features were introduced into the SQL language, including the long-awaited support for the Boolean data type and the associated logical predications.
Documentation: Release Notes (PDF available), Quick Start Guide (PDF available) and other manuals.
Download it here.
A “Migration Guide to Firebird 3” eBook, written by Carlos H. Cantu, is also available.
Firebird 3 final is about to be released
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.
“Guia de migração para o Firebird 3” is released
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
ODBC driver updated
Firebird ODBC driver 2.0.4 was released today, with the following changes:
- fixed bug, URL: http://tracker.firebirdsql.org/browse/ODBC-79, “Problem with case sensitivity for table/relations name in SET TRANSACTION RESERVING clause”
- fixed bug, URL: http://tracker.firebirdsql.org/browse/ODBC-174, “SIGSEGV received in libOdbcFb.so: memcpy in JString constructor incorrect input parameter”
- fixed bug, URL: http://tracker.firebirdsql.org/browse/ODBC-184, “CHAR(X) fields have invalid length if using UTF8 charset and collations”
- fixed bug, URL: http://tracker.firebirdsql.org/browse/ODBC-190, “ODBC function SQLGetInfo fails if SQL_KEYWORDS InfoType is requested”
- fixed bug, URL: http://tracker.firebirdsql.org/browse/ODBC-191, “ODBC driver doesn’t show error message for Test connection button in DSN dialog. Improvements in Windows DSN dialog interface”
- fixed bug, URL: http://tracker.firebirdsql.org/browse/ODBC-192, “Incorrect conversion of time values when retrieved as string”
- correct alignment issues for Sun Solaris and HPUX – updated Linux makefile to support both iODBC and unixODBC, thanks to Paul Beach
You can download it at sourceforge.net/projects/firebird/files/firebird-ODBC-driver/2.0.4-Release/
Firebird 3.0 RC2 is released
Firebird Project announces the second Release Candidate of Firebird 3.0, the next major version of the Firebird relational database, which is now available for testing.
This Release Candidate demonstrates the complete set of features and improvements developed for the new release. Release Candidates are generally considered stable enough and may be recommended for testing in “almost-production” environments. Please report about any found bugs to the bugtracker.
Please read the Release Notes carefully before installing and testing this Release Candidate.
The Haversine formula => Calculate distance between to WGS84 Points
Hi,
I think might be helpful, today for a customer i do the Haversine formulas for Firebird Sql as a stored procedure.
This formula allow you to calculate the distance in meter between two WGS84 datum points(degree points of Earth).
You can call the procedure like this:
SELECT * FROM HAVERSINE_GENERIC(1, 45,474081, 9,179348, 45,456091, 9)
Firebird 3 RC2 expected release date
Dmitry Yemanov just confirmed that we can expect Firebird Release Candidate 2 to be released this month (January/16). The source code should be tagged in the next 2 weeks, and after that, it is just a matter of the documentation team finishing the release notes.
Merry Christmas!
Of course, we could not miss the chance to post again the video of our preferred band (The Firebird Core-Developers band)! 🙂
Merry Christmas to everyone!
Personalize funny videos and birthday eCards at JibJab!
Band is:
Drums: Alex “Bonham” Peshkov
Guitar: Vlad “Vai” Khorsun
Guitar: Claudio “Friedman” Valderrama
Bass: Adriano “Harris” Fernandes
Vocal: Dmitry “Plant” Yemanov
Campanha para Guia de migração para o Firebird 3
Sorry, for now, this is only for Brazilians…
Entrou no ar a campanha (crowdfunding) para financiamento do meu novo livro: “Guia de Migração para o Firebird 3”. Todas as informações e o formulário para contribuir estão disponíveis em www.firebase.com.br/guiafb3.php
Esse é um projeto totalmente independente, e depende de você para se tornar realidade! Dependendo de como for essa experiência, ela servirá de base para lançamentos futuros.
Acesse o link, leia e contribua se julgar interessante.Carlos H. Cantu