TPDA (Tiny #Perl Database Application) 0.70.1 released
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.
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.
Great PPT from Alex Peshkoff (Firebird Core developer) regarding Firebird Security is published: http://bit.ly/3ITICI
via ibsurgeon’s tweet
Firebird 2.1.3 package is uploaded to Debian Unstable (Sid) and here is the list of package changes
* fix repack.sh invocation in watch file
* make executable
* New upstream release
+ drop patches released upstream
– cvs_CVE-2009-2620_DOS.patch was deleted (fixed upstream in 2.1.3)
– cvs_autogen.sh-autoreconf.patch
* refresh all patches to apply cleanly
* no longer regster QuickStart.pdf with doc-base; it was dropped upstream
* -classic.postinst: remove stray stop rc.d symlinks
What is interesting is to see the import diff vs the 2.1.2 package