Category: General news

Active Record Firebird Adapter 0.8.7 updated
Fixes regression affecting delayed_job usage :
When a result set is not returned, exec_query still needs to return the number of rows affected.

Active Record Firebird Adapter 0.8.6 now supports pluck for efficiently retrieving a single column of a result set in an array.

Another change is : Handle cases where sql does not return a result set.

Here are a few fixes for v1.6.x Release Candidate 1 commited into master
————————————————————————————————————————————
Fixed missing date_interval_sql implementation. #21
Fixed datetime_trunc_sql NotImplementedError. #20
Fixed missing SQLDateTimeCompiler. #19
Fixed BigIntegerField is not supported in introspection. #18
Fixed BinaryField is not supported in introspection. #17
Fixed missing method name. #11
Fixed setup.py due to README extension change. #12
————————————————————————————————————————————

Also Django Firebird stable 1.5.2 is uploaded to pypi with a few fixes backported from master branch (if you use Django 1.5.x)

pyfirebirdsql Version 0.8.4 is released with following changes

• refactoring
• add repair() method in Services
• add is_disconnect() method in Connection

New feature preview feature in LibreOffice 4.2  : Firebird SQL connector for LibreOffice Base ( contributed by Andrzej Hunt). When creating a new Database, select Firebird Embedded in the drop down menu (you have to first enable the Experimental features in Tools ▸Options ▸ LibreOffice ▸ Advanced).

This allows creation of databases that perform many times faster than the previous built-in HSQLDB 1.8, avoiding the C++-to-Java overhead inherent in using HSQLDB. We plan to phase HSQLDB out over the next few releases, and provide a smooth migration path to Firebird.

Here is the history of Firebird -> Libo GSOC integration (idea ,code ,bugs, blog posts)

http://en.libreofficeforum.org/node/6062

Firebird ActiveRecord gem is updated to version 0.8.4 with a few fixes:

• Standardize on “gem build activerecord-fb-adapter.gemspec” rather than Rakefile to build new gems.
• Allow for the presence of both binds and encoded values within the SQL statement. Credit to Ray Zane.

New version 0.1.6 is released in the unstable area and here is the ChangeLog:

• Push down bitwise operators << and >> (FB 2.1 and later)
• Push down two-argument form of SUBSTRING()
• Push down CONCAT()
• Push down POSITION() / STRPOS()
• Don’t check for mutable functions – we are explicitly whitelisting functions which can be pushed down (need to double-check if that’s a valid approach)