Firebird 2.1 adds support for Common Table Expressions
The developers of Firebird have released version 2.1 of the open source database system, originally derived from Borland's Interbase. This new major release has received an enthusiastic response from Firebird fans. Significantly, it supports Common Table Expressions (CTE), which allow recursive, dynamic queries and global temporary tables. The engine creates these in separate files that comply with the standard so that persistent data from the flow of complex transactions do not have to be stored permanently from the outset.
Other entries in the comprehensive list of new features include an
UPDATE OR INSERT command that can be used to update a data record or, depending on the situation, create a new one. Firebird 2.1 can also manipulate text BLOBS (binary large objects) with a maximum of 32 kB as though they were normal
Firebird 2.1 has been ported to the 64-bit version of Windows Server 2003, and both PPC and Intel versions of Mac OS X. Both source and binary packages are available to download. Those wishing to switch current databases to the new version will find tips in the documentation provided.