Friday Fun with Firebird: Curious Backup sizes
There are some tricky and unclear things in Firebird, which do not affect the performance or reliability, but they are curious. Some of them we are going to show, but not explain.
There are some tricky and unclear things in Firebird, which do not affect the performance or reliability, but they are curious. Some of them we are going to show, but not explain.
Some nice blog post about switching to Firebird Embedded on .Net
Firebird project seems to have an embeddable library for .NET available. I’ve successfully used Firebird database in my Delphi projects in the past and it was the perfect solution for a client-server architecture I’ve developed.
TPDA (Tiny Perl Database Application) is a classic desktop, database application framework, written in Perl and pTk. TPDA has support for Firebird, Postgresql and MySQL.
Nicole Anderson from Computer Science Department Winona State University is using Firebird and Flamerobin in one of her Database Design course
From IBSurgeon on Tweeter – Harvard Business School: “The Business of Free Software” http://bit.ly/3Hn4ZV Firebird is in top 20 OSS list – not clear how it was counted.
Here is the ChangeLog for Firebird 2.1.3 package in Gentoo :
Bump to 2.1.2, mostly fixes #264955. Thanks to Vladimir, John W. Higgins and all the testers in the bug.
MySQL users are nervous about Oracle’s takeover of Sun Microsystems, according to InfoWorld. You can see their point: Why would a company whose main product is a proprietary database be interested in maintaining an open source competitor to it?
There are other open source databases available. PostgreSQL, Firebird, HSQLDB, even Apache Derby can all be called into service, depending on your needs. The developer communities behind any of these projects would be more than happy to help scores of ex-MySQL users migrate to their particular platform. They almost certainly already have tools to do it
Today I needed to convert a Delphi/Pascal code to Firebird PSQL. Part of the code used the integer value of a date to do some calcs. First, I tried to use Firebird CAST to convert a Date to Integer, but FB can’t do this type of cast (anyway, I’m not sure if the result would be the same as Delphi, since I don’t know what starting date Firebird uses for internal storage). So, the solution was to create a workaround and subtract the date from 30-December-1899 (Dublin Julian Day), ie:
my_int_var = current_date – cast(‘30.12.1899’ as date);
The above line will return the integer value of the today date, as Delphi/Pascal would do. In other words, it is the number of days since 30-Dec-1899.
Tsutomu Hayashi released DbBench 0.6.0.
List of changes :
* Move development environment to Delphi2010.
* Add “ENGINE INNODB” to MySQL CREATE TABLE script.
* Firebird now use dbExpress driver for firebird by Embarcadero.
* Add “WaitOnLocks = True” for each drivers parameter.
* Change processed transaction count method, now include rollbacked transaction.