Author: mariuz

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.

PyFirebirdsql Version 0.9.7 is released with Firebird 3 Wire Protocol changes

– null indicator fixes for Firebird 3
– PyCrypto dependency added for Firebird 3

One example is in test basic api file

Hajime Nakagami contributed new Statistical functions : covar_samp(), covar_pop(), corr()

You can find a few examples in the pull request.

ps:Now is merged