Last day to subscribe to FDD (before price raises)
Today is the last day to register for the 13th Firebird Developers Day, to be held in Brazil, 9-July.
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!
13th Firebird Developers Day
The Conference is for Portuguese speakers…
As inscrições para a 13a. edição do Firebird Developers Day já podem ser feitas pelo site oficial do evento.
O FDD é a maior conferência sobre Firebird no mundo, e será realizada no dia 09/Julho, em Piracicaba – SP. Com o recente lançamento do Firebird 3, teremos diversas palestras sobre novas funcionalidades dessa versão, mas também abordaremos temas de interesse aplicáveis à qualquer versão.
Migration Guide to Firebird 3
Learn more.
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.