Firebird/RDB supported by the largest banking software maker in Russia
RedDB (based on Firebird) is now supported by BSS, the largest banking software maker in Russia. Read more (translated with Google).
RedDB (based on Firebird) is now supported by BSS, the largest banking software maker in Russia. Read more (translated with Google).
Adriano has published in his blog some information about the implementation of the OVER function in Firebird 3. Really cool.
By the SQL specification, window functions are a kind of aggregation, but which does not “filter” the result set of a query. The aggregated data is mixed with the query result set. That sort of functions are used with the OVER clause. Users of Oracle also knows window functions as analytical functions[…]
Today, on January 18, 2010, IBProvider celebrates its 10th anniversary. The grand banquet is preceded by the release of the latest IBProvider version with enhanced support of DDL and updatable rowsets.
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
Database Master is a powerful database development, management and administration software for the Oracle, SQL Server, MySQL, PostgreSQL, FireBird and SQLite database systems. It allows you to manage databases, tables, views, procedures, indexes, triggers and provides productivity features for rapidly creating and executing SQL queries and connect some major database systems via ODBC and OleDb. Database Master is being imagesed for modern multi-cpu/core architecture.
Older posts here.
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.
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