Firebird 5.0 Beta 1

New features

• Parallel (multi-threaded) operations (#1783, #3374, #7447)
• Support for partial indices (#7257)
• SKIP LOCKED clause (#7350)
• Inline minor ODS upgrade (#7397)
• Compiled statement cache (#7144)
• PSQL and SQL profiler (#7086)
• Support for WHEN NOT MATCHED BY SOURCE in the MERGE statement (#6681)
• Built-in functions UNICODE_CHAR and UNICODE_VAL (#6798)
• RDB$BLOB_UTIL new system package (#281)
• Support multiple rows being returned by DML with the RETURNING clause (#6815)
• Optimize the record-level RLE algorithm for a denser compression of shorter-than-declared strings and sets of subsequent NULLs (#4723)
• More cursor-related details in the plan output (#7441)

More details can be found in the CHANGELOG.

Release Notes | Binary Packages

Firebird 4.0.2

Improvements

• New built-in function BLOB_APPEND (#6983)
• Trace: provide performance statistics for DDL statement (#7208)
• Make it possible to avoid fbclient dependency in Pascal programs using firebird.pas (#7194)
• Ignore missing UDR libraries during restore (#7168)
• Update zlib to version 1.2.12 (#7161)
• Improve indexed lookup speed of strings when the last keys characters are part of collated contractions (#7093)
• Improve performance of CURRENT_TIME (#7092)
• ON DISCONNECT triggers are not executed during forced attachment shutdown (#7042)
• Firebird port for Apple M1 architecture (#7041)
• Improve performance of STARTING WITH with insensitive collations (#7038)
• Trace: provide ability to see STATEMENT RESTART events (or their count) (#6730)

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages

Firebird 3.0.10

What's new

• Make it possible to avoid fbclient dependency in Pascal programs using firebird.pas
• Update zlib to version 1.2.12
• Improve indexed lookup speed of strings when the last keys characters are part of collated contractions
• Faster execution of indexed STARTING WITH with UNICODE collation
• 17 bugs fixed

Release Notes | Quick Start Guide | Binary Packages

Firebird 3.0.9

What's new

• 14 bugs fixed

Release Notes | Quick Start Guide | Binary Packages

Firebird 4.0.1

Improvements

• Add IBatch::getInfo() method to the API (#6959)
• fb_info_protocol_version support (#6954)
• Add support of PKCS v.1.5 padding to RSA functions, needed for backward compatibility with old systems (#6929)
• Allow attribute DISABLE-COMPRESSIONS in UNICODE collations (#6915)
• Make it possible to create ICU-based collations with locales keywords (#6903)
• Faster indexed STARTING WITH execution with UNICODE collations (#6872)
• Use precise limit of salt length when signing messages and verifying the sign (#6810)
• Integer hex-literal support for INT128 (#6809)

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages

Firebird 3.0.8

What's new

• Added database creation time to the output of ISQL's command SHOW DATABASE
• More efficient implementation of SUBSTRING for UTF8 character set
• Freeing a statement using DSQL_drop or DSQL_unprepare sends the free packet immediately
• Increased number of formats/versions of views from 255 to 32K
• 60 bugs fixed

Release Notes | Quick Start Guide | Binary Packages

Firebird 4.0.0

Improvements

• Rename functions RSA_SIGN and RSA_VERIFY (#6806)
• Add session time zone to system context (#6786)
• More efficient implementation of SUBSTRING for UTF8 character set (#6769)
• Add ability for a replication plug-in to refuse attachment (#6767)
• Freeing a statement using DSQL_drop or DSQL_unprepare should send free packet immediately (#6748)
• Provide time zone ID constants in public headers (#6715)
• RDB$GET_TRANSACTION_CN should work the same way in Super and Classic (#6253)

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages

Firebird 4.0 Release Candidate 1

New features

• ALTER SESSION RESET command (CORE-5832)
• Virtual table RDB$CONFIG (CORE-3708)
• Report replica mode through isc_database_info, MON$DATABASE and SYSTEM context (CORE-6474)
• Ability to trace session management commands (CORE-6469)
• INT128 as explicit basic type for high precision numerics (CORE-6342)

More details can be found in the CHANGELOG.

Release Notes | Binary Packages

Firebird 3.0.7

What's new

• Detach server from the security database when missing plug-in data structures cause an error
• Better diagnostic for the 'Missing security context' error
• Remove PIDFile/-pidfile option from Super(Server/Classic) systemd unit
• 16 bugs fixed

Release Notes | Quick Start Guide | Binary Packages

Firebird 3.0.6

What's new

• Better transaction control in ISQL
• Relocation support on MacOS
• Increased parsing speed of long queries
• Better performance when using SRP plugin
• 43 bugs fixed

Release Notes | Quick Start Guide | Binary Packages