Window Functions (part2) – cumulative aggregates
adrianosf twiteed
New blog post – Window Functions (part2) – cumulative aggregates – http://bit.ly/8sgfKU.
And here the Hebrew version of the article
Author: mariuz
http://wiki.ubuntu.com/Mariuz
Good news for #Debian #kFreeBSD and #FreeBSD
New release – Sinática Monitor 2.1.6 for Firebird
You can download the new release here , read the release notes and see the nice screenshots there or follow sinatica on twitter for news related to Monitor
#Fisheye in the Firebird #jira tracker
From the cool stuff department if found the Fisheye in the Jira tracker and it shows all bugs closed and related code changes (diffed)
Book about Firebird as basis for open documentation
JVCS 2.45 released
he JVCS team is happy to announce JEDI VCS 2.45 release, which is intended as a maintenance release for 2.40.
Most important changes from between 2.44 and 2.45 are:
-
– Improved database system migration tool for Firebird and MS-SQL Server based repositories
– Performance improvement for blank modules
– changed server log file location for better compatibility with Windows VISTA/7/2003/2008
– bug fixes
Installer is available on sourceforge in the file section or follow this link:
https://sourceforge.net/projects/jedivcs/files/2.45/
Please consider to help this project we always need helping hands for design, usablitity, programming, test, writing documentation.
If you’re interested please check “Positions Available” or contact us by E-Mail.
JVCS Team
Firebird Complete Introduction #Book in #Japanese is launched
#Python bug: float compared to decimal is silently incorrect
Python Bug that can trigger some errors when upgrading from kinterbasdb 3.2 to kinterbasdb 3.3
if python/kinterbasdb users upgrade kinterbasdb they must be aware of this python bug, because all existing code must be inspected for “(retrieved Decimal value) compare (float)” statements, which before upgrade were Ok (retrieved float value) compare (float)) statements
Firebird Tracker is Restored
Firebird’s Jira Tracker is now restored on the new VM, with data up to 5 December 2009. However, we have lost attachments from the last two years. Missing ticket headers from after Dec 5 will need to be reconstructed from notification messages. Read more
Firebird support for Identity Columns in 3.0
An identity column is a column associated with an internal sequence generator and has it value automatically set when omitted in an INSERT statement.
Example:
create table objects (
id integer generated by default as identity primary key,
name varchar(15)
);insert into objects (name) values (‘Table’);
insert into objects (name) values (‘Book’);
insert into objects (id, name) values (10, ‘Computer’);select * from objects;
ID NAME
============ ===============
1 Table
2 Book
10 Computer