Category: General news

FDB Python driver for Firebird v1.4.5 is available for download. This is
pure bugfix release. Solves problems with memory and db resource leaks
caused by Python GC due to circular references.

https://pypi.python.org/pypi/fdb

Warning : there are some issues with django in this release (reported by Maximiliano Robaina)

If you have Firebird related open source project please migrate to github.

Linear regression functions added in Firebird 3.0 :

REGR_AVGX(Y, X) = SUM(X) / N
REGR_AVGY(Y, X) = SUM(Y) / N
REGR_COUNT(Y, X) = N
REGR_INTERCEPT(Y, X) = REGR_AVGY(Y, X) – REGR_SLOPE(Y, X) * REGR_AVG_X(Y, X)
REGR_R2(Y, X) = POWER(CORR(Y, X),2)
REGR_SLOPE(Y, X) = COVAR_POP(Y, X)
REGR_SXX(Y, X) = N * VAR_POP(X)
REGR_SXY(Y, X) = N * COVAR_POP(Y, X)
REGR_SYY(Y, X) = N * VAR_POP(Y)

Contributed by Hajime Nakagami.

Github pull request: https://github.com/FirebirdSQL/core/pull/4

Here is the list of changes : What’s new in Firebird 2.5.4

Vlad Khorsun contributed New feature CORE-4707 in firebird 2.5.4:
Ability to validate tables and indices online
See also:
/doc/README.online_validation
/doc/README.services_extension

Roadmap for a distributed Firebird? was posted on firebird-devel list By Jim Starkey.

Goal: Morph Firebird into a high performance, distributed, fully redundant database.

Revision history for Perl extension DBD::Firebird for 1.19:

• Fix $VERSION in Firebird.pm [mapopa]
• Fix typo in ISC_PASSWORD spelling [stefbv70]
• Positive logic and early return [Tux]
• Allow re-executing/fetch on prepared sth [RT#92810, Tux]
• Add rests for $dbh->{Name} and others [mjp]
• Implement $dbh->{Name} [mjp]
• Fix attributions to Mike Pomraning [mjp]
• use strict and warnings in all modules [dmn]
• add a test for inserting/fetching float and double numbers as an attempt to reproduce RT#101650 [dmn]
• fix File::Which configure prerequisite declaration [RT#101672, dmn]
• 03-dbh-attr.t: plan tests after creating the TestFirebird object [dmn]
• Buffer Overflow in dbdimp.c [Debian #780925, stefan.roas]
• use snprintf instead of sprintf everywhere [dmn]

Dmitry Yemanov added documentation for the new feature : Scrollable cursors in PSQL, DSQL with additional API support

Function:
Allow to navigate through the open cursor in any direction rather than sequentially fetching records forward.