Firebird 2.5.0 RC2

Firebird Project - (Open Source)

Firebird is the perfect database for developing a small program or a large enterprise information system.

Firebird is a relational database that can better manage your database and to track the behavior of your SQL programs. By implementing this tool you can refresh your data and make the correction scripts. The software runs on Windows 95/98/Millenium/2000 / XP platforms. SQL Monitor Interbase / Firebird is a freeware software.

Firebird offers good performance regardless of the size of databases, ranging from a few kilobytes to several gigabytes, without slowdowns. Among the features there can be mentioned multi-generational architecture, support for external functions (UDFs), the ACID transaction model, full support of Stored Procedures and Triggers, full internal language for Stored Procedures and Triggers (PSQL), support for External Functions (UDFs), full implementation of cursors in PSQL, incremental Backups, referential Integrity, many third-party tools, including graphical tools aministration, replication, etc, many drivers database access : Napi , dbExpress driver , ODBC, OLEDB , pilot Net native JDBC type 4 driver module, Python , PHP , Perl, etc and more.

Title:: Firebird 2.5.0 RC2
File Size:: 6.9 MB
Requirements:: Windows 9x / 2000 / XP / Vista / Windows7 / Windows8
Language:: en-us
License:: Open Source
Date Added:: 03 Apr 2010
Publisher:: Firebird Project
Homepage:: http://www.firebirdsql.org
MD5 Checksum:: CD6746B1A9A36FF0839313132E802C3E

* Administrative Enhancements

- System audit tracing and user trace sessions via the Services API, making it possible to monitor and analyse everything going on in a database in real time
- New system role RDB$ADMIN in the ODS 11.2 database allows SYSDBA to transfer its privileges to another user on a per-database basis
- More information in the monitoring tables
- Asynchronous cancellation of connections
- Capability for ordinary users to monitor any of their own attachments as well as CURRENT_CONNECTION

* Other SQL Language Additions and Enhancements
- Regular expression support using the SIMILAR TO predicate
- ALTER COLUMN for computed columns
- Autonomous transactions within a PSQL module (stored procedure, trigger or dynamically executable PSQL block)
- Enhanced access to stored procedures in view definitions
- Optional GRANTED BY or GRANTED AS for GRANT and REVOKE statements, enabling the grantor to be a user other than the CURRENT_USER (the default).
- REVOKE ALL syntax to dispose of all privileges for a user or role at once
- Support for WHERE SOME_COL = ? OR ? IS NULL predications
- Removal of â€œreservedâ€ status for all but a handful of keywords that are not reserved in the SQL standard

* Data-handling Enhancements
- New built-in functions for converting UUID CHAR(16) OCTETS strings to RFC4122-compliant format and vice versa
- Ability to pass 32-bit and 64-bit integers as hexadecimal in numeric literal and X-prefixed binary string literal formats

* API Additions
- Statements now return an SQL-2003 standard 5-alphanumeric SQLSTATE completion code
- New constant DSQL_unprepare available for use with isc_dsql_free_statement for efficient unpreparing of statements

* International Language Support
- Default COLLATE clause for CREATE DATABASE
- Ability to change the default COLLATE for a used character set
- GBAK restore switches FIX_FSS_DATA and FIX_FSS_METADATA to restore legacy databases with UNICODE_FSS data and/or metadata correctly without resorting to scripts and manual techniques
- Accent-insensitive collation for Unicode