Category: Worth Reading

Content not direct related to FB, but interesting reading.

One more reason to upgrade to Firebird 2.5.2 : CVE-2012-5529

Leave a comment

News via oss-sec and [pkg-firebird-general] mailing list
A denial of service flaw was found in the way the TraceManager of
Firebird, performed preparation of an empty dynamic SQL query. When the trace mode was
enabled, a remote, authenticated database user could use this flaw
to cause the Firebird server to crash with a NULL pointer dereference.

References: [1] http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=693210
[2] http://tracker.firebirdsql.org/browse/CORE-3884
[3] https://bugzilla.redhat.com/show_bug.cgi?id=876613

Relevant upstream patch: [4]
http://firebird.svn.sourceforge.net/viewvc/firebird?pathrev=54702&revision=54702&view=revision

FBClone 2.2.1 released – This is not only a bugfix version it can “normalize” a multi charset database

Leave a comment

FBClone 2.2.1 is released to google code
This is more than a “bugfix release” for FBClone here are a few of new features and fixes:
-It Can “normalize” a multi charset database by ignoring all “character set” definitions from source db
See flags -ics -ko in combination with -tc UTF8.
-It supports domains in SP parameters as well as NOT NULL, TYPE OF and COLLATE.
-It’s changed creation order of UNIQUE/FOREIGN and VIEW TRG/TABLE TRG as suggested by users in issues.

You need to use it from command line and specify the source and target database
fbclone source employee.fdb target new_db.fdb user sysdba password *****
News via Pierre Yager tweet

FBCon 10 session video: ODS related optimizations in Firebird 3

Leave a comment

From the FBCon 10 session videos another one is uploaded: ODS related optimizations in Firebird 3

Presentation By Vlad Khorsun. Session contents: Major change. ODS12 contains a few important features to make some IO-hungry operations such as sweep and natural scan more efficient. I’ll show in detail what was changed and how these changes will affect performance.

http://www.youtube.com/watch?v=oszA2-fPRH4

1 … 14 15 16 17 18 … 84