Firebird 2.5.0 RC1

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 RC1
File Size:: 7.0 MB
Requirements:: Windows 9x / 2000 / XP / Vista / Windows7 / Windows8
Language:: en-us
License:: Open Source
Date Added:: 25 Dec 2009
Publisher:: Firebird Project
Homepage:: http://www.firebirdsql.org
MD5 Checksum:: 1EC632226E15718870D1679C438698D5

* Other New Features:
- Administrative Enhancements
- Other SQL Language Additions and Enhancements
- Data-handling Enhancements
- API Additions
- International Language Support

* Changes in the Firebird Engine:
- New Threading Architecture
- Thread-safe Client Library
- Other Improvements

* Changes to the Firebird API and ODS:
- ODS (On-Disk Structure) Changes
- API (Application Programming Interface) Extensions

* Reserved Words and Changes:
- Clean-up of Reserved Words
- Newly Reserved Words
- Keywords Added as Non-reserved

* Configuration Parameter Additions and Changes:
- AuditTraceConfigFile
- Parameters Affecting Filesystem Cache Usage
- Authentication
- MaxUserTraceLogSize
- OldSetClauseSemantics
- RemoteAuxPort For Classic and Superclassic
- Use Hostname for RemoteBindAddress
- RemoteFileOpenAbility

* Administrative Features:
- New RDB$ADMIN System Role
- Trace and Audit Services
- Monitoring Improvements

* Security Hardening:
- Windows Platforms changes

* Data Definition Language (DDL):
- Visibility of Procedure Definition Changes on Classic
- CREATE/ALTER/DROP USER
- Syntaxes for Altering Views
- Extensions for CREATE VIEW
- ALTER Mechanism for Computed Columns
- Extensions for SQL Permissions
- Default COLLATION Attribute for a Database
- ALTER CHARACTER SET Command
- Evolution of CREATE DATABASE

* Data Manipulation Language (DML):
- RegEx Search Support using SIMILAR TO
- Hex Literal Support
- New UUID Conversion Functions
- SOME_COL = ? OR ? IS NULL Predication
- Extension to LIST() Function
- Optimizer Improvements
- Other Improvements

* Procedural SQL (PSQL):
- Autonomous Transactions
- Borrow Database Column Type for a PSQL Variable
- New Extensions to EXECUTE STATEMENT
- Other PSQL Improvements

* International Language Support (INTL):
- Default COLLATION Attribute for a Database
- ALTER CHARACTER SET Command
- Connection Strings & Character Sets
- Other Improvements

* Command-line Utilities:
- fbtracemgr
- Retrieve Password from a File or Prompt
- gsec
- fbsvcmgr
- gbak
- nBackup
- isql
- gpre (Precompiler)
- gstat