IvorySQL 5.1
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