Releases · IvorySQL/IvorySQL

Version Overview

[Release Date: Mar 12, 2026]

IvorySQL 5.3 is built on PostgreSQL 18.3 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

PostgreSQL 18.3

Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version.
Avoid incorrect complaint of invalid encoding when substring() is applied to "toasted" data.
Fix oversight in the fix for CVE-2026-2007.
Fix the volatility marking of json_strip_nulls() and jsonb_strip_nulls().
Fix computation of the set of potentially-nulling outer joins for the output of a LATERAL UNION ALL subquery.

For further details, visit PostgreSQL’s release notes.

PostgreSQL 18.2

Guard against unexpected dimensions of oidvector/int2vector.
Harden selectivity estimators against being attached to operators that accept unexpected data types.
Fix buffer overrun in contrib/pgcrypto's PGP decryption functions.
Fix inadequate validation of multibyte character lengths.
Harden contrib/pg_trgm against changes in string lowercasing behavior.

For further details, visit PostgreSQL’s release notes.

Key Features

Upgrade to PG 18.3 kernel: Feature #1199
PostgreSQL kernel upgraded to version 18.3.
Upgrade to PG 18.2 kernel: Feature #1195
PostgreSQL kernel upgraded to version 18.2.
IvorySQL 5.3 Online Experience: Feature #7
An interactive, browser-based environment will be launched to allow users to explore and evaluate IvorySQL 5.3 in real time — no installation required.
Packaging for All Platforms
Provides multi-platform media packages for X86, ARM, MIPS, LoongArch architecture.
Containerized Deployment Support
Supports one-click deployment of standalone or highly available IvorySQL 5.3 clusters via Docker Compose, Podman, Swarm, Helm, and the IvorySQL 5.3 Operator.
IvorySQL Cloud 5.3 released (Visual Database Lifecycle Management Platform)
Offers a fully managed, graphical control plane that handles IvorySQL 5.3 database subscriptions, orchestrates end-to-end lifecycle operations, and integrates surrounding ecosystem services.
PostgreSQL Extensions
Support for 10 Additional PostgreSQL Extensions: pg_cron, pgAudit, PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, system_stats, plpgsql_check, pgvector.

Fixed Issues

Clear build warnings: PR #1190
Fix raw_expression_tree_walker for ColumnRefOrFuncCall: Issue #1182
Fix the issue where upgrading from PostgreSQL to IvorySQL fails: Issue #1130
Improved error message about plisql usage is ivorysql.compatible_mode = 'pg': PR #1178
Fix array out-of-bounds read in token_is_col_id() - liboracle_parser.c: Issue #1159
Fix psql tab-completion showing INVISIBLEINCREMENT: Issue #1135
Fix variable reset bug in nested function expressions: Issue #1124
Fix type coercion failure with mixed positional/named parameters in packages and subprocedures: Issue #1006
Fix segfault when package procedure initializes local variable from parameter: Issue #1005
Fix regression failures caused by the new year: PR #1146

Source Code

IvorySQL's development is maintained across four main repositories:

IvorySQL database source code: https://github.com/IvorySQL/IvorySQL
IvorySQL official website: https://github.com/IvorySQL/Ivory-www
IvorySQL documentation: https://github.com/IvorySQL/IvorySQL_docs
IvorySQL Docker: https://github.com/IvorySQL/docker_library

Contributors

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

Cédric Villemain
Fawei Zhao
Ge Sui
Grant Zhou
Oreo Yang
Pierre Forstmann
Rophy Tsai
Shuntian Jiao
Steven Niu
Xiangyu Liang
Xiaohui Liu
Xinjie LYU
Xueyu Gao
Yasir Hussain Shah
Yuan Li
Zheng Tao
Zhenhao Pan
Zhe Zhang
Zhuoyan Shi

Complete Changelog

Version Overview

[Release Date: Dec 18, 2025]

IvorySQL 5.1 is built on PostgreSQL 18.1 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

PostgreSQL 18.1

Check for CREATE privileges on the schema in CREATE STATISTICS.
Avoid integer overflow in allocation-size calculations within libpq.
Prevent “unrecognized node type” errors when a SQL/JSON function such as JSON_VALUE has a DEFAULT clause containing a COLLATE expression.
Avoid incorrect optimization of variable-free HAVING clauses with grouping sets.
Do not use parallelism in hash right semi joins.
Avoid possible division-by-zero when creating ordered-append plans.
Fix planner failure with index types that can do ordered access but not index-only scans.

For further details, visit PostgreSQL’s release notes.

New Features

Upgrade to PG 18.1 kernel: Feature #1004
PostgreSQL kernel upgraded to version 18.1.
Online Experience: IvorySQL 5.1: Feature #6
An interactive, browser-based environment will be launched to allow users to explore and evaluate IvorySQL 5.1 in real time — no installation required.
Packaging for All Platforms: Feature #1136
Provides multi-platform media packages for X86, ARM, MIPS, LoongArch architecture.
Containerized Deployment Support
Supports one-click deployment of standalone or highly available IvorySQL 5.1 clusters via Docker Compose, Podman, Swarm, Helm, and the IvorySQL 5.1 Operator.
IvorySQL Cloud 5.1 released (Visual Database Lifecycle Management Platform)
Offers a fully managed, graphical control plane that handles IvorySQL 5.1 database subscriptions, orchestrates end-to-end lifecycle operations, and integrates surrounding ecosystem services.
PostgreSQL Extensions
Support for 10 Additional PostgreSQL Extensions: pg_cron, pgAudit, PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, system_stats, plpgsql_check, pgvector.

Fixed Issues

Clear build warnings: Issue #996
PL/iSQL Parser Rejects Parentheses in SELECT INTO Expression: Issue #981
Doc:Fix reports missing uuid-ossp during source installation: Issue #198

Source Code

IvorySQL's development is maintained across four main repositories:

IvorySQL database source code: https://github.com/IvorySQL/IvorySQL
IvorySQL official website: https://github.com/IvorySQL/Ivory-www
IvorySQL documentation: https://github.com/IvorySQL/IvorySQL_docs
IvorySQL Docker: https://github.com/IvorySQL/docker_library

Contributors

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

Amberwww1
Cédric Villemain
Fawei Zhao
Ge Sui
Grant Zhou
Oreo Yang
Rophy Tsai
Shuntian Jiao
Steven Niu
Xiangyu Liang
Xiaohui Liu
Xinjie Lv
Xueyu Gao
Yasir Hussain Shah
Yuan Li
Zheng Tao
Zhenhao Pan
Zhe Zhang
Zhibin Wang
Zhuoyan Shi

Complete Changelog

Version Overview

[Release Date: Nov 25, 2025]

IvorySQL 5.0 is built on PostgreSQL 18.0 and introduces major upgrades in Oracle compatibility, ecosystem component integration, and cloud-native capabilities. It also significantly enhances usability by providing mainstream full-platform installation packages and a smooth, seamless online experience. For a comprehensive list of updates, please visit our documentation site.

Enhancements

PostgreSQL 18.0

An asynchronous I/O (AIO) subsystem that can improve performance of sequential scans, bitmap heap scans, vacuums, and other operations.
pg_upgrade now retains optimizer statistics.
Support for "skip scan" lookups that allow using multicolumn B-tree indexes in more cases.
uuidv7() function for generating timestamp-ordered UUIDs.
Virtual generated columns that compute their values during read operations. This is now the default for generated columns.
OAuth authentication support.
OLD and NEW support for RETURNING clauses in INSERT, UPDATE, DELETE, and MERGE commands.
Temporal constraints, or constraints over ranges, for PRIMARY KEY, UNIQUE, and FOREIGN KEY constraints.
For further details, visit PostgreSQL’s release notes.

New Features

21 New Oracle Compatibility Features

Oracle-compatible ROWID support: Feature #126
Ensures IvorySQL row identifiers align with Oracle semantics for seamless cross-database tooling.
PL/iSQL CALL invocation syntax: Feature #764
Adds the Oracle-style CALL entry point so stored procedures can be invoked consistently.
PL/iSQL %ROWTYPE support: Feature #765
Allows variables to mirror entire table or cursor rows for concise PL/iSQL coding.
PL/iSQL %TYPE support: Feature #766
Enables variables to adopt the data type of existing columns or variables to reduce drift.
Case-sensitive compatibility switch: Feature #767
Preserves identifier case to match Oracle behavior when required.
NLS parameter compatibility: Feature #768
Honors Oracle-style NLS settings such as NLS_DATE_FORMAT and NLS_TIMESTAMP_FORMAT.
Empty string to NULL translation: Feature #769
Converts zero-length strings to NULL to match Oracle compatibility rules.
Parser switching capability: Feature #770
Adds toggles between Oracle and PostgreSQL parsers for per-session flexibility.
GB18030 database encoding: Feature #771
Provides GB18030 initialization and create-database options for full Chinese market coverage.
Oracle-compatible SYS_GUID: Feature #773
Implements the Oracle SYS_GUID function to generate RAW-based GUIDs.
Oracle-compatible SYS_CONTEXT: Feature #774
Delivers the Oracle SYS_CONTEXT API for querying session and environment metadata.
Oracle-compatible USERENV: Feature #775
Adds the USERENV function so sessions can inspect Oracle-style contextual details.
Oracle-compatible function syntax: Feature #776
Supports Oracle constructs such as EDITIONABLE/NONEDITIONABLE, RETURN, IS, and OUT ... NOCOPY options.
Oracle-compatible procedure syntax: Feature #777
Enables procedure DDL with Oracle options, EXEC invocation, and ALTER PROCEDURE support.
libpq OUT parameter plumbing: Feature #778
Extends client protocol handling so OUT parameters can be consumed like OCI.
Procedure OUT parameter support: Feature #779
Allows stored procedures to declare IN, OUT, and IN OUT modes per Oracle conventions.
Function OUT parameter support: Feature #780
Permits Oracle-style OUT parameters within functions, including IN OUT combinations.
Nested subprograms: Feature #781
Introduces support for declaring functions or procedures within other subprograms, including overloading.
Oracle-compatible INSTR: Feature #782
Matches Oracle INSTR behavior for substring searches and position checks.
Oracle-compatible FORCE VIEW: Feature #783
Lets views be created even when referenced objects do not yet exist, mirroring Oracle's FORCE option.
Oracle-compatible LIKE operator: Feature #784
Aligns pattern-matching semantics with Oracle for predictable wildcard behavior.

Online Trial and Multi-Platform Distribution Packages

Online Experience: IvorySQL 5.0: Feature #887
An interactive, browser-based environment will be launched to allow users to explore and evaluate IvorySQL 5.0 in real time — no installation required.
Packaging for All Platforms: Feature #949
Provides multi-platform media packages for X86, ARM, MIPS, LoongArch architecture.

Cloud-Native & Containerized

Containerized Deployment Support (Docker Compose & podman & Docker Swarm):
Supports deployment of standalone IvorySQL databases and high-availability clusters in Docker Compose , podman and Docker Swarm environments.
Containerized Deployment Support (Kubernetes):
Supports deployment of standalone IvorySQL databases and high-availability clusters on Kubernetes (K8s) using Helm.
IvorySQL Operator 5 released (Kubernetes):
The IvorySQL Operator 5.0 has been adapted to support IvorySQL 5.0, with upgrades to system component versions and database extension versions.
IvorySQL Cloud 5.0 released (Visual Database Lifecycle Management Platform):
Offers a fully managed, graphical control plane that handles IvorySQL 5.0 database subscriptions, orchestrates end-to-end lifecycle operations, and integrates surrounding ecosystem services.

Support for 10 Additional PostgreSQL Extensions

pg_cron: Feature #882
Scheduled job execution within the database layer will be available through pg_cron integration.
pgAudit: Feature #929
Provides detailed session and/or object audit logging via the standard PostgreSQL logging facility.
PostGIS: Feature #880
Spatial data processing and geospatial analytics will be enabled through PostGIS compatibility.
pgRouting: Feature #881
Network and routing analysis features will be introduced with pgRouting support.
PGroonga: Feature #879
Full-text search capabilities will be enhanced via planned PGroonga support.
ddlx: Feature #877
Support for ddlx to enable advanced schema introspection and automated DDL generation.
pgsql-http: Feature #883
Allow the database to initiate HTTP/HTTPS requests internally, enabling seamless communication between the database and external web services.
system_stats: Feature #946
System level statistics will be provided by system_stats support.
plpgsql_check: Feature #915
Static code analysis on PL/pgSQL functions to identify errors, warnings, and potential issues before runtime execution.
pgvector: Feature #878
Integration with pgvector to empower AI/ML workloads through native vector similarity search.

Fixed Issues

Repaired unused_oids and duplicate_oids catalog tooling so header scans correctly detect conflicts without false positives: Issue #841
Added .gitignore coverage for libpq/ivytest artifacts to prevent generated binaries and logs from polluting developer trees: Issue #843
Extended GitHub workflow regression runs to cover builds configured with --with-libnuma, preventing future breakages on NUMA-enabled hosts: Issue #869
Eliminated the MainLoop dangling-pointer scenario that triggered intermittent segmentation faults under concurrency stress: Issue #898
Re-enabled oracle_test/modules/*/sql cases by fixing harness assumptions so Oracle-compatibility suites execute end-to-end again: Issue #897
Updated README.md and README_CN.md to reflect IvorySQL 5.0 feature set, packaging, and onboarding instructions: Issue #896
Corrected globally unique index enforcement so related regression tests now pass reliably across supported platforms: Issue #894

Source Code

IvorySQL's development is maintained across four main repositories:

IvorySQL database source code: https://github.com/IvorySQL/IvorySQL
IvorySQL official website: https://github.com/IvorySQL/Ivory-www
IvorySQL documentation: https://github.com/IvorySQL/IvorySQL_docs
IvorySQL Docker: https://github.com/IvorySQL/docker_library

Contributors

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

Carlos Chong
ccwxl
Cédric Villemain
Fu Bei
Fawei Zhao
Ge Sui
Grant Zhou
Imran Zaheer
jerome-peng
Jiaoshun Tian
luss
Martin Gerhardy
Mingran Feng
omstack
otegami
Ruike Sun
rophy
Shaolin Chu
Shawn Yan
Shihua Yang
shlei6067
Shuisen Tong
Shuntian Jiao
Steven Niu
sjw1933
Xiangyu Liang
Xiaohui Liu
Xinjie Lv
xuexiaoganghs
Xueyu Gao
yangchunwanwusheng
Yanliang Lei
Yasir Hussain Shah
Yuan Li
Zhe Zhang
Zheng Tao
Zhenhao Pan
Zhuoyan Shi

Complete Changelog

Version Overview

[Release Date: Sep 10, 2025]

IvorySQL 4.6, based on PostgreSQL 17.6 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

PostgreSQL 17.6 Enhancements

Tighten security checks in planner estimation functions.
Prevent pg_dump scripts from being used to attack the user running the restore.
Convert newlines to spaces in names included in comments in pg_dump output.
Fix incorrect distance calculation in BRIN numeric_minmax_multi_ops support function.
Avoid regression in the size of XML input that we will accept.
For further details, visit PostgreSQL’s release notes.

New Features

Upgrade to PG 17.6 kernel: Feature #859
MongoDB-compatible solution: Feature #860
Provide a MongoDB-compatible solution using FerretDB and DocumentDB.
LoongArch Packaging for All Platforms: Feature #738 #829
Provides multi-platform media packages for LoongArch architecture, supporting both domestic and international mainstream operating systems, including Red Hat, Debian, Kylin, UOS, and NSAR OS, etc. It also supports x86, ARM, and MIPS architectures.
IvorySQL Online trail: Feature #4
Provide users with a web-based platform to experience IvorySQL V4.6 in an online environment, enabling database interaction directly through a browser interface.
Containerized Deployment Support (Docker Swarm):
Supports deployment of standalone IvorySQL databases and high-availability clusters in Docker Swarm environments.
Containerized Deployment Support (Kubernetes):
Supports deployment of standalone IvorySQL databases and high-availability clusters on Kubernetes (K8s) using Helm.
IvorySQL Cloud v4.0 released
The IvorySQL Cloud platform currently supports subscription management for IvorySQL v4 databases, as well as comprehensive management of its surrounding ecosystem.

Fixed Issues

Missing libcrypt on aarch64 platform: Issue #826
prefix test_ extension are wrongly compiled and installed while exec make and make install:Issue #836
Doc:fix some typos: Issue #143
Doc:Fix document errors in the installation section: Issue #142
Doc:Update the community contribution process: Issue #130

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.

caffiendo
Cédric Villemain
Fawei Zhao
flyingbeecd
Ge Sui
Grant Zhou
huchangqiqi
Pedro Lopez
RRRRhl
Ruohang Feng
shangwei007
Shawn Yan
Shaolin Chu
Shihua Yang
Shiji Niu
Shuntian Jiao
tiankongbuqi
Xiangyu Liang
Xinjie Lv
Xueyu Gao
Yanliang Lei
Yasir Hussain Shah
Yuan Li
Zheng Tao
Zhenhao Pan
Zhuoyan Shi

Complete Changelog

Version Overview

[Release Date: Jun 4, 2025]

IvorySQL 4.5, based on PostgreSQL 17.5 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

PostgreSQL 17.5 Enhancements

Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding.
Handle self-referential foreign keys on partitioned tables correctly.
Avoid data loss when merging compressed BRIN summaries in brin_bloom_union().
Correctly process references to outer CTE names that appear within a WITH clause attached to an INSERT/UPDATE/DELETE/MERGE command that's inside WITH.
Fix ALTER TABLE ADD COLUMN to correctly handle the case of a domain type that has a default.
For further details, visit PostgreSQL’s release notes.

New Features

Upgrade to PG 17.5 kernel: Feature #807
MIPS Packaging for All Platforms: Feature #736
Provides multi-platform media packages for MIPS architecture, supporting both domestic and international mainstream operating systems, including Red Hat, Debian, Kylin, UOS, and NSAR OS, etc.
IvorySQL Online trail: Feature #1
Provide users with a web-based platform to experience IvorySQL V4.5 in an online environment, enabling database interaction directly through a browser interface.
Add code of conduct: Feature #808
Update the community contribution guide: Feature #121
Automate Documentation Build and Website Update via Pull Requests: Feature #115
Enhanced Contributor Workflow: Self-Assign Issues by using the '/assign' command: Feature #109
IvorySQL Operator V4 has been adapted to support IvorySQL 4.5, with upgrades to system component versions and database extension versions : Feature #79

Fixed Issues

Wrong enum value in check_compatible_mode and assign_compatible_mode: Issue #763
Wrong test result in GUC Framework: Issue #111
Update oracle compatibility parameters: Issue #74
Update README path to a hyperlink: PR #156
Force the search_path to be re-computed when compatible_mode is changed: Issue #760
Rename ModifyTableContext and UpdateContext for better compatibility: PR #794
Set identifier_case_switch to value in pg_control file so that configure file value can take effect : Issue #797

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.

Cary Huang
Cédric Villemain
Denis Lussier
Fawei Zhao
Flyingbeecd
Ge Sui
Grant Zhou
Hulin Ji
Hope Gao
Lily Wang
Renli Zou
Shawn Yan
Shihua Yang
Shiji Niu
Shoubo Wang
Shuntian Jiao
Xiangyu Liang
Xinjie Lv
Zheng Tao
Zhenhao Pan
Zhuoyan Shi

Complete Changelog

Version Overview

[Release Date: Mar 26, 2025]

IvorySQL 1.17, based on PostgreSQL 14.17 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

PostgreSQL 14.8-14.17 Enhancements

Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign.
Fix handling of unknown-type arguments in DISTINCT "any" aggregate functions.
Tighten security restrictions within REFRESH MATERIALIZED VIEW CONCURRENTLY.
Restrict visibility of pg_stats_ext and pg_stats_ext_exprs entries to the table owner.
Prevent unauthorized code execution during pg_dump.
Ensure cached plans are marked as dependent on the calling role when RLS applies to a non-top-level table reference.
Repair ABI break for extensions that work with struct ResultRelInfo.
Harden PQescapeString and allied functions against invalidly-encoded input strings.
Improve behavior of libpq's quoting functions.
For further details, visit PostgreSQL’s release notes.

New Features

ARM64 Packaging for All Platforms
Provides multi-platform media packages for ARM architecture, supporting both domestic and international mainstream operating systems, including Red Hat, Debian, Kylin, UOS, and NSAR OS, etc.
X86 Packaging for All Platforms
Provides multi-platform media packages for X86 architecture, supporting both domestic and international mainstream operating systems, including Red Hat, Debian, Kylin, UOS, and NSAR OS, etc.
Support for more open source plugins
Such as ddlx0.20, pgvector v0.8.0, PGroonga 3.0.0, PostGIS 3.4.0 and pgRouting3.5.1.

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.

Dapeng Wang
Grant Zhou
Shiji Niu
Shuntian Jiao
Xinjie Lv
Xueyu Gao
Zhenhao Pan
Zheng Tao

Complete Changelog

Version Overview

[Release Date: Mar 10, 2025]

IvorySQL 4.4, based on PostgreSQL 17.4 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

PostgreSQL 17.3 Enhancements

Harden PQescapeString and allied functions against invalidly-encoded input strings.
Restore auto-truncation of database and user names appearing in connection requests.
Exclude parallel workers from connection privilege checks and limits.
Drop “Lock” suffix from LWLock wait event names.
Fix possible re-use of stale results in window aggregates.
Prevent checkpoints from starting during relation truncation.
For further details, visit PostgreSQL’s release notes.

PostgreSQL 17.4 Enhancements

Improve behavior of libpq's quoting functions.
Fix small memory leak in pg_createsubscriber.
Fix meson build system to correctly detect availability of the bsd_auth.h system header.
For further details, visit PostgreSQL’s release notes.

New Features

ARM64 Packaging for All Platforms: Feature #729
Provides multi-platform media packages for ARM architecture, supporting both domestic and international mainstream operating systems, including Red Hat, Debian, Kylin, UOS, and NSAR OS, etc.
X86 Packaging for All Platforms: Feature #735
Provides multi-platform media packages for X86 architecture, supporting both domestic and international mainstream operating systems, including Red Hat, Debian, Kylin, UOS, and NSAR OS, etc.
Add a new kernel architecture design document framework: Feature #739
Adds a new series on kernel architecture design, starting with Oracle compatibility. This series delves into the framework , design and implementation principles of each module, aiming to help users gain a deeper understanding of the Oracle compatibility framework.
Analysis of the Dual Parser Architecture Principle in the Oracle Compatibility Framework : Feature #740
Introduces the design and implementation principles of the dual parser architecture within the Oracle compatibility framework.
Analysis of the initdb Architecture Principle in the Oracle Compatibility Framework: Feature #741
Introduces the design and implementation principles of the initdb architecture within the Oracle compatibility framework.
IvorySQL official website adds chat room feature: Feature #742 #133
Adds a chat room feature to the official website, enabling intelligent interactions and Q&A sessions related to IvorySQL.

Fixed Issues

incomplete sql when using invisible columns and pg_dump: Issue #731
installation package for EulerOS: Issue #745

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.

Alex Guo
Cary Huang
Denis Lussier
Fawei Zhao
Flyingbeecd
Grant Zhou
Imran Zaheer
Kang Wang
Lily Wang
Mingran Feng
Renli Zou
Ruohang Feng
Shawn Yan
Shiji Niu
Shoubo Wang
Shuntian Jiao
Xiangyu Liang
Xinjie Lv
Xueyu Gao
Zhenhao Pan

Complete Changelog

Version Overview

[Release Date: Jan 13, 2025]

IvorySQL 4.2, based on PostgreSQL 17.2 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

PostgreSQL 17.1 Enhancements

Ensure cached plans are marked as dependent on the calling role when RLS applies to a non-top-level table reference.
Make libpq discard error messages received during SSL or GSS protocol negotiation.
Fix unintended interactions between SET SESSION AUTHORIZATION and SET ROLE.
Prevent trusted PL/Perl code from changing environment variables.
Fix updates of catalog state for foreign-key constraints when attaching or detaching table partitions.
For further details, visit PostgreSQL’s release notes.

PostgreSQL 17.2 Enhancements

Repair ABI break for extensions that work with struct ResultRelInfo.
Restore functionality of ALTER {ROLE|DATABASE} SET role.
Fix cases where a logical replication slot's restart_lsn could go backwards.
Avoid deleting still-needed WAL files during pg_rewind.
Fix race conditions associated with dropping shared statistics entries.
For further details, visit PostgreSQL’s release notes.

Fixed Issues

Fix issue for pg_upgrade: Issue #721
Provide Rocky9 installation package: Issue #724
EN grammatical fixes in ivorysql_docs: Issue #95

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.

Cary Huang
Denis Lussier
Fawei Zhao
Grant Zhou
Hope Gao
Lily Wang
Shawn Yan
Shiji Niu
Shoubo Wang
Shuntian Jiao
Xiangyu Liang
Xinjie Lv
Zhibin Wang

Complete Changelog

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

Version Overview

[Release Date: Nov 18, 2024]
This release based on PostgreSQL 14.8 and includes multiple oracle compatibility features. For a comprehensive list of updates, please visit our documentation site.

New changes

PostgreSQL 14.8

Prevent CREATE SCHEMA from defeating changes in search_path
Enforce row-level security policies correctly after inlining a set-returning function
Avoid crash when the new schema name is omitted in CREATE SCHEMA
Fix enabling/disabling of cloned triggers in partitioned tables
Disallow altering composite types that are stored in indexes

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

IvorySQL 1.8

Add "ivorysql" database as default database
Support for both X86 and ARM architectures
Compatibility with domestic Chinese operating systems, such as Kylin V10
Update some IvorySQL regression test cases
Support for more open source plugins, such as ddlx0.20, pgvector v0.8.0, and PGroonga 3.0.0.

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.

Grant Zhou
Jichao Ma
Shiji Niu
Shuntian Jiao
Xiangyu Liang
Xinjie Lv
Xueyu Gao
Yingze Wang
Zhenchao Qiu

Complete Changelog

Releases: IvorySQL/IvorySQL

IvorySQL 5.3

Version Overview

Enhancements

Key Features

Fixed Issues

Source Code

Contributors

Uh oh!

IvorySQL 5.1

Version Overview

Enhancements

New Features

Fixed Issues

Source Code

Contributors

Uh oh!

IvorySQL 5.0

Version Overview

Enhancements

New Features

21 New Oracle Compatibility Features

Online Trial and Multi-Platform Distribution Packages

Cloud-Native & Containerized

Support for 10 Additional PostgreSQL Extensions

Fixed Issues

Source Code

Contributors

Uh oh!

IvorySQL 4.6

Version Overview

Enhancements

New Features

Fixed Issues

Source Code

Contributors

Uh oh!

IvorySQL 4.5

Version Overview

Enhancements

New Features

Fixed Issues

Source Code

Contributors

Uh oh!

IvorySQL 1.17

Version Overview

Enhancements

New Features

Source Code

Contributors

Uh oh!

IvorySQL 4.4

Version Overview

Enhancements

New Features

Fixed Issues

Source Code

Contributors

Uh oh!

IvorySQL 4.2

Version Overview

Enhancements

Fixed Issues

Source Code

Contributors

Uh oh!

IvorySQL 4.0

Version Overview

Enhancements and Bug Fixes

Source Code

Contributors

Uh oh!

IvorySQL 1.8

Version Overview

New changes

Source Code

Contributors

Uh oh!