“Guia de migração para o Firebird 3” is released

FB 3 GuideThe 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)

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

Are you fluent in English and SQL?

The Firebird Docs team is calling for people who are fluent in both English and Firebird’s SQL to assist with reviewing the English text of the Firebird 2.5 Language Reference manual. Of 10 chapters and 8 Appendices, 4.5 chapters are still untouched by reviewers.  It would be good to have the reviewing done to coordinate with the forthcoming 2.5.5 release but correctness takes priority.

Still to do are:  half of the DDL chapter, DML, PSQL, Functions and Variables, Transactions.

If you feel able to help with the review, please subscribe to the [firebird-docs] list here and make yourself and your preferred topics known.

1 13 14 15 16 17 100