{"id":112886,"date":"2024-01-13T11:28:03","date_gmt":"2024-01-13T09:28:03","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-firebird-5-0"},"modified":"2024-01-13T11:28:03","modified_gmt":"2024-01-13T09:28:03","slug":"vypusk-subd-firebird-5-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/en\/blog\/news\/vypusk-subd-firebird-5-0","title":{"rendered":"Release of the Firebird 5.0 DBMS","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
After two and a half years of development, the release of the Firebird 5.0 relational database management system has arrived. Firebird continues the development of the InterBase 6.0 database code, which was opened in 2000 by Borland. Firebird is distributed under the MPL open license and supports ANSI SQL standards, including features such as triggers, stored procedures, and replication. Binary builds are prepared for Linux, Windows, macOS, and Android. <\/p>\n
Key innovations: <\/p>\n
\n
The ability to perform operations in a multithreaded mode has been implemented. Parallel processing is applicable when creating indexes, garbage collection (both automatic and manual sweep operations), creating backups, and restoring from them. gfix -sweep -parallel 4 dbname gbak -b -par 4 -user username -pass password dbname backupname\n
Partial index support has been added, which includes only selective records that meet the specified conditions at the time of index creation. CREATE INDEX IT1_COL ON T1 (COL) WHERE COL < 100;\n
In SELECT statements with LOCK, UPDATE, and DELETE, the syntax 'SKIP LOCKED' has been implemented, allowing for the exclusion of records that are locked at the time the query is sent (for instance, to avoid waiting for a lock to be released when intersecting with another transaction).\n
The ability to update the database to the latest intermediate version of the storage (ODS \u2014 On-Disk-Structure) on the fly (inline update) without creating and restoring from a backup has been added. For example, it is now possible to dynamically convert a database from Firebird 4.0 format (ODS 13.0) to Firebird 5.0 format (ODS 13.1).\n
A cache for compiled SQL expressions is implemented, automatically managed (obsolete records are cleared as needed). The cache size is set through the MaxStatementCacheSize parameter in firebird.conf.\n
An interface for profiling SQL and PSQL has been added, allowing the assessment of the execution time of each query, accumulation of statistics on the number of queries, and identification of performance issues.\n
Support for the conditional block 'WHEN NOT MATCHED BY SOURCE' has been added to the MERGE statement, which triggers when the source record does not match any records in the target set. MERGE INTO customers c USING new_customers nc ON (c.id = nc.id) \tWHEN MATCHED THEN \t\tUPDATE SET name = nc.name \tWHEN NOT MATCHED BY SOURCE THEN \t\tDELETE\n
The capability to return multiple rows with the RETURNING statement has been ensured if the specified DML statement covers multiple rows (previously, such situations resulted in the 'multiple rows in singleton select' error).\n
New built-in functions have been added: UNICODE_CHAR to return the unicode character corresponding to a given code, and UNICODE_VAL to return the code for a given character. The EXTRACT, FIRST_DAY, and LAST_DAY functions now include the QUARTER parameter to determine the quarter number.\n
A new system package RDB$BLOB_UTIL has been added, providing a set of operations for BLOBs for PSQL modules.\n
The record compression algorithm has been improved, now utilizing a variable-length counter for more efficient packing of repeating data sequences. This optimization has significantly increased the compression ratio of sparsely filled long VARCHAR fields containing UTF-8 encoded data.\n
Support for bi-directional cursors (scrollable) has been added for remote network access to the database.\n
Performance optimization for copying blobs has been completed.\n
Full support for the syntax of defining string literals as described in the SQL standard has been added. For example, strings can now be broken by comments or whitespace: select 'ab' \/* comment *\/ 'cd' from RDB$DATABASE; select 'ab' 'cd' from RDB$DATABASE; <\/ul>\n