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)

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 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]
1 2 3