Firebird package updated in Debian : 2.5.4.26856.ds4-2

This version will make the build reproducible.

The reproducible builds initiative aims to enable anyone to reproduce bit by bit identical binary packages from a given source, thus enabling anyone to independently verify that a binary matches the source code from which it was said it was derived. For example, this allow the users of Debian to rebuild packages and obtain exactly identical packages to the ones provided by the Debian repositories.

Prune tool sets the creation stamp in the database header to a fixed value (taken from the last changelog stanza) and
prunes unused space on index/data pages of shipped databases

Firebird 3 protocol benchmark

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.

fb3_1

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.

fb3_2

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.

 

Firebird 3 beta 2 is released

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.

Firebird 3.0 Revision 61479 uploaded to #ubuntu firebird3.0 ppa

Firebird 3.0 Revision 61479 was uploaded to Debian/experimental.

Now you can install on  Ubuntu 14.04 LTS  or latest release  15.04 (Vivid) from firebird3.0 ppa

Changes:
* Remove extra ‘;a=summary’ from the Vcs-Browser URL
* -server.postinst: s/LOGDIR/LOG_DIR/ spelling mistake (This solved an package install issue – basically it stopped the installation process)
* Imported Upstream subversion snapshot r61579
* fix populating -dev with include/firebird/* content

Time to try Firebird for Android

androidIn a private email exchange to Alex Peshkov, he allowed be to publish his “cloud” link, containing a test version of Firebird 3 for Android.

Archives with tools for accessing databases in embedded mode are available at https://cloud.mail.ru/public/0b09cf605ed8/FbAndr

Note that Embedded can be used also as a client to access remote Firebird servers.

Embedded version should be _embedded_ into target application. It’s not installed separately. It can be accessed by the well known ISC API, and there is also the new OO API.

Alex need people to try it out and report/comment about problems, etc.

If you expect to see an official Android Firebird build in the future, you must start helping testing and sending feedback.

Firebird for Android is coming

shell@hwH30-U10:/data/local/tmp/firebird/bin $ ./isql employee
Database: employee
SQL> show version;
ISQL Version: LI-T3.0.0.31567 Firebird 3.0 Beta 2
Server version:
Firebird/Linux/ARM (access method), version “LI-T3.0.0.31567 Firebird
3.0 Beta 2”
on disk structure version 12.0
SQL>

Alex.

Firebird Security Updates for v2.1 and v2.5 series

The Firebird project has released Security Updates for the currently maintained 2.1.x and 2.5.x versions (v2.1.7 and v2.5.3 SU1). These updates fix a recently discovered security vulnerability (CORE-4630) that may be used for a remote DoS attack that could be performed by unauthorised users. We recommend Firebird users to upgrade as soon as is practical.

http://www.firebirdsql.org/en/news/security-updates-for-v2-1-and-v2-5-series-66011/

Firebird 3 Beta 1 released

Firebird Project announces the first 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 here. 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.
Download page:
http://www.firebirdsql.org/en/firebird-3-0-0-beta1/

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


Dmitry Yemanov

1 3 4 5 6 7 27