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[…]
(8 votes, average: 5.00 out of 5)
Loading...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.
(4 votes, average: 5.00 out of 5)Loading... (1 votes, average: 5.00 out of 5)Loading...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
(No Ratings Yet)Loading...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.
(5 votes, average: 4.20 out of 5)Loading...Older posts here.
(2 votes, average: 5.00 out of 5)Loading...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.
(No Ratings Yet)Loading...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
(7 votes, average: 5.00 out of 5)Loading... (No Ratings Yet)Loading...Inside the zip file you will find a nice pdf about why he uses Firebird and Euphoria Language example. I have uploaded the html version of the pdf here (transformed with pdftohtml)
Demonstration program for Firebird Server ODBC access using odbc.e and wxEuphoria with two-tone flexible datagrid. Uses the EMPLOYEE.FDB example database that comes standard with Firebird install.
(1 votes, average: 5.00 out of 5)Loading...
