Google Code Project Hosting on Google Code will close on January 25th, 2016
If you have Firebird related open source project please migrate to github.
Category: General news
Firebird related news
Database .NET 14.9 released
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)
- New features and improvements from 14.3 to 14.9 (2015/03/30)
- Updated to FirebirdSql.Data.FirebirdClient.dll 4.6.1.0
- Improved Graphical User Interface
- Added My Favorites
- Added Displaying Data Types on the column header
- Added Connection Process Manager for Firebird
- Added Maximum number of answer rows to display
- Added Specifying dynamic variables
- Added Specifying specific printers
- Added Pin to Start Menu and Pin to Taskbar
- Added Default placeholders for Code Snippet Manager
$DATE$, $TIME$, $USER$, $MACHINE$, $SERVER$, $DBNAME$, $SCHEMANAME$, $OBJECTNAME$ - …and more.
You’re welcome to download it from http://fishcodelib.com/Database.htm
Free, All-In-One, Portable, Single executable file and Multi-language.
Aggregate linear regression functions added in Firebird 3.0
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
Firebird V2.5.4 is taged in svn tree
Here is the list of changes : What’s new in Firebird 2.5.4
Cool stuff in firebird 2.5.4 : Ability to validate tables and indices online
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
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.
Firebird Perl extension DBD-Firebird version 1.19 is released
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]
New SQL standard feature : Scrollable cursors
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 fixes
New Statistical Functions to be added covar_samp, covar_pop, corr
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