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.

Firebird 3.0 RC1 is now released

Firebird Project announces the first 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.

Download page:
http://www.firebirdsql.org/en/firebird-3-0-0-rc1/

Release Notes:
http://web.firebirdsql.org/download/prerelease/rlsnotes/Firebird-3.0.0_RC1-ReleaseNotes.pdf

Dmitry Yemanov

fb3_horizontal

1 14 15 16 17 18 101