Firebird 5.0.0 RC1

New features and improvements

• Use ParallelWorkers setting from firebird.conf as default for all parallelised operations (#7682)
• Make Android port (client / embedded) work inside apps (#7469)
• Add support for QUARTER to EXTRACT, FIRST_DAY and LAST_DAY (#5959)
• Better processing and optimization if IN <list> predicates (#7707)
• Make trace config parser resolve symlinks in database file path in trace configuration (#7692)
• Getting the current DECFLOAT ROUND/TRAPS settings (#7642)
• Allow nested parenthesized joined table (#7576)
• Optimize creation of expression and partial indices (#7559)
• Add ability to query current value of parallel workers for an attachment (#7536)
• Add COMPILE trace events for procedures/functions/triggers (#7466)
• Add REPLICA MODE to the output of the isql SHOW DATABASE command (#7425)
• Surface internal optimization modes (all rows vs first rows) at the SQL and configuration levels (#7405)
• Make ability to add comment to mapping (COMMENT ON MAPPING ... IS ...) (#7046)

More details can be found in the CHANGELOG.

Release Notes | Binary Packages

Firebird 4.0.3

Improvements

• RDB$GET/SET_CONTEXT(): quoting the missing namespace/variable makes output more readable (#7539)
• Avoid non necessary index reads (#7494)
• Add switch to control in guardian timeout before killing Firebird server process (#7468)
• Update zlib to version 1.2.13 (released 2022-10-13) (#7437)
• Add REPLICA MODE to the output of the isql SHOW DATABASE command (#7425)
• Improve reliability of plugin manager (#7418)
• Allow FB-known macros in replication.conf (#7294)
• Remove TcpLoopbackFastPath and use of SIO_LOOPBACK_FAST_PATH (#7259)
• Nbackup RDB$BACKUP_HISTORY cleanup (#7186)

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages

Firebird 3.0.11

What's new

• RDB$GET/SET_CONTEXT(): quoting the missing namespace/variable makes output more readable (#7539)
• Avoid non necessary index reads (#7494)
• Add switch to control in guardian timeout before killing Firebird server process (#7468)
• Update zlib to version 1.2.13 (released 2022-10-13) (#7437)
• Improve reliability of plugin manager (#7418)
• Remove TcpLoopbackFastPath and use of SIO_LOOPBACK_FAST_PATH (#7259)
• 41 bugs fixed

Release Notes | Quick Start Guide | Binary Packages

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