Firebird V2.5.4 has been released and is available for download.
Firebird 2.5.4 is currently the latest stable release. Detailed information about new features and improvements can be found in the release notes.
Firebird 2.5.4 is currently the latest stable release. Detailed information about new features and improvements can be found in the release notes.
If you have Firebird related open source project please migrate to github.
Database .NET is an innovative, powerful and intuitive multiple database management tool, With it you can Browse objects, Design tables, Edit rows, Export data and Run queries with a consistent interface. (Full support for Firebird 1.5~3.0)
You’re welcome to download it from http://fishcodelib.com/Database.htm
Free, All-In-One, Portable, Single executable file and Multi-language.
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:
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.