IvorySQL Files

Version Overview

[Release Date: Dec 23, 2024]

This release is based on PostgreSQL 17.0 and introduces new Oracle compatibility features along with various bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements and Bug Fixes

• PostgreSQL 17.0

• New memory management system for VACUUM, which reduces memory consumption and can improve overall vacuuming performance.

• New SQL/JSON capabilities, including constructors, identity functions, and the JSON_TABLE() function, which converts JSON data into a table representation.
• Various query performance improvements, including for sequential reads using streaming I/O, write throughput under high concurrency, and searches over multiple values in a btree index.
• Logical replication enhancements.
• New client-side connection option, sslnegotiation=direct, that performs a direct TLS handshake to avoid a round-trip negotiation.
• pg_basebackup now supports incremental backup.
• COPY adds a new option, ON_ERROR ignore, that allows a copy operation to continue in the event of an error.

For further details, please visit PostgreSQL’s release notes.

• IvorySQL 4.0

• Oracle invisible columns compatibility: [#608] Add support for invisible columns and describe invisible columns in psql extended description (\d+) in oracle mode only. Any general access to a table will not display invisible columns. Invisible columns must be explicitly referenced by their column name for queries and other operations to access them.

• Oracle package compatibility: [#589] Support PL/SQL package management, including creating, altering, and describing packages and package bodies. The PostgreSQL interactive terminal (psql) has been enhanced with a new \dk command for package-related operations. Additionally, advanced privilege management is enabled through new ACL functions, and package caching has been implemented to boost performance.
• Function pg_get_functiondef enhancement: [#696] Support multiple function OIDs in parameter list. It also can export function definition with same name but different parameters now.
• Add 'ivorysql' as default database: #575
• Provide Ubuntu installation package: [#703]

Source Code

IvorySQL's development is maintained across two main repositories: - IvorySQL database source code: https://github.com/IvorySQL/IvorySQL - IvorySQL official website: https://github.com/IvorySQL/Ivory-www

Contributors

The following individuals (in alphabetical order) have contributed to this release as patch authors, committers, reviewers, testers, or reporters of issues.

• Bei Fu
• Cary Huang
• Fawei Zhao
• Grant Zhou
• Hope Gao
• Imran Zaheer
• Jiajie Zhou
• jerome-peng
• Jiao Ren
• Li Wang
• Ruohang Feng
• Shawn Yan
• Shiji Niu
• Shoubo Wang
• Shuntian Jiao
• Xiangyu Liang
• Xinjie Lv
• Yi Wen
• Zhenwei Xu

Complete Changelog