Firebird 2.5.3

Firebird是一套功能全面且強大的資料庫軟體。它支援跨平台系統的應用，提供SQL-99標準功能，並且支援嵌入式數據庫應用。支援管理多個獨立的資料庫並同時與多個客戶端進行連接，是一個非常專業的資料庫軟體喔。

• 支援跨平台系統的應用。
• 提供SQL-99標準功能。
• 支援嵌入式數據庫應用。
• 支援管理多個獨立的資料庫並同時與多個客戶端進行連接。

* New context variables have been added to the SYSTEM namespace to retrieve more information about the current connection and current transaction. The added variables: SYSTEM::CLIENT_PID and SYSTEM::CLIENT_PROCESS for the current connection, SYSTEM::LOCK_TIMEOUT and SYSTEM::READ_ONLY for the current transaction.
* Some limits have increased:
- The maximum number of connections on Windows for Superserver and Superclassic has been raised from 1024 to 2048 connections.
- The maximum number of input parameters for external functions (UDFs) has increased to 15.
* Error reporting improvements, including:
- More details are now reported for “object in use” errors.
- The relation name is now added to the text of validation constraint error messages, to help identify the error context.
- Error reporting for index and constraint violations has been extended to include the problematic key value.
* Physical backup (using ALTER DATABASE BEGIN/END BACKUP or the nBackup utility) was improved to speed up extension of the main database file when backup state changes from stalled to merge.
- Contention for the allocation table lock while a database is in the stalled physical backup state has been reduced.
- Faster file growth has been enabled on Linux systems that support fallocate().
- Attachments no longer block others when the allocation table is being read for the first time.
* Execution of a SET STATISTICS INDEX statement no longer blocks or slows down concurrent attachments.
* The scan for limbo transactions at the end of a sweep has been improved.
* Support for the UPDATE OR INSERT statement and the RETURNING clause have been implemented for Embedded SQL (ESQL).