Version 0.64 of SQL Relay, the powerful connection pool, load balancer, query router, and database proxy, is now available.
This release features support for Informix databases, support for remote and centralized configuration files, a better configure script for building from source on Windows, improvements to the drop-in replacement library for PostgreSQL, and a “softttl” parameter for dynamically spawned database connections. The tool is Open Source, and also supports Firebird database.
At the 12th Firebird Developers Day, I talked about Using Firebird in high latency networks (aka. internet). Below are two slides from my presentation, where you can see the improvements in Firebird 3 wire protocol, compared to FB 2.5 and to MySQL.
Enjoy!
Obs: Left axis values are expressed in seconds. Test server was hosted in Amazon (USA) and client accessing it was located in Brazil. Ping reported latency of 219ms. The smaller the bar, the better.
Above graph shows the result of fetching 10.000 records from a real table used to store customers data. Red bars represents records with all the fields filled (ie: there was no fields containing nulls) and blue bars represents fetching records where some of the fields were nulls. Tests where done with and without compression.
The same table used in previous graph was created in MySQL InnoDB (same data). Blue bars means that wire compression was disabled, and red has compression enabled. Left side graphs has all fields filled (ie. there wasn’t null fields) and in right side graphs, some records has some null fields.
As you see, FB 3 won 😉
I should mention that there was no blob fields in the table, and this makes a lot of difference. Fetching non-null blobs makes the fetch slower in Firebird (more roundtrips are needed).
PS: The improvements in the FB 3 wire protocol were sponsored by donations collected in the 9th edition of FDD conference, and were implemented by Dmitry Yemanov. Compression was implemented by Alex Peshkov.
For those who like to read database comparisions/benchmarks, here is one that probably all Firebird fans will like 🙂
During the registration process for the 12th edition of the Firebird Developers Day, people could donate money to the Firebird Foundation. In total, it was collected R$ 4.590,27 (~ USD 1.3k). The list of donors is available here.
Thanks to all who contributed! And remember that anyone can contribute, donating or becoming a member of the Firebird Foundation.
The report with lots of photos of the 12th Firebird Developers Day edition is now online (in English and Portuguese). You can check it here.
Last saturday we had the 12th edition of the Firebird Developers Day conference in Brazil! During all the day, hundreds of people had the chance to improve their knowledge about Firebird, and buy software with special discounts.
Thanks to all the attendees, speakers (Dmitry Yemanov, Alexandre Benson Smith, Alexey Kovyazin, Nilson Brasil and Marcelo Daibert), sponsors and supporters (Embarcadero, FastReports, ActiveDelphi, IBSurgeon and IBObjects, Steema, Woll2Woll and DevArt).
The conference report will be online soon, and several pictures already can be seen in facebook, g+ and twitter.
Today is the last day to subscribe online to the 12th edition of the Firebird Developers Day, which will happen in Piracicaba-SP, Brazil, in 08-August. www.FirebirdDevelopersDay.com.br
Firebird Project announces the second Beta release of Firebird 3.0, the next major version of the Firebird relational database, which is now available for testing.
This Beta release demonstrates the features and improvements currently under development by the Firebird development team. Our users are appreciated giving it a try and providing feedback to the development mailing list. Apparent bugs can be reported directly to the bugtracker.
Beta releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release.
Please read the Release Notes carefully before installing and testing this Beta release.
For the Brazilians…
Essa é a última semana para se inscrever no Firebird Developers Day pagando menos! A grade de palestras já está fechada, confira agora mesmo no site www.FirebirdDevelopersDay.com.br e se inscreva!
Lembrando que na véspera do evento, teremos uma MasterClass sobre otimização de performance, com Dmitry Yemanov e Alexey Kovyazin. Confira as informações sobre a MasterClass e se inscreva aqui.
The Firebird Developers Day is a Brazilian annual conference, held in Piracicaba-SP, with an average of 400 attendees. This year, the 12th edition of the conference will happen in 08-August, with the special presence of Dmitry Yemanov, chief of the Firebird development team.
All the details can be found in the conference site, and registrations can be done online. We invite all the Brazilians and Portuguese speakers to participate in this big event!
