IvorySQL 5.1 is built based on PostgreSQL 18.1, including multiple bug fixes and functional improvements. For the complete update list, please refer to the official documentation site.

Enhanced Features from PostgreSQL 18.1

  • Check the CREATE permission for Schemas in CREATE STATISTICS.
  • Avoid potential integer overflows in size allocation calculations in libpq.
  • Prevent the "unrecognized node type" error when the DEFAULT clause of SQL/JSON functions (e.g., JSON_VALUE) contains COLLATE expressions.
  • Avoid incorrect optimization of constant HAVING clauses that include grouping sets.
  • Disable parallel execution in hash right semi joins.
  • Avoid potential division-by-zero errors when generating ordered-append execution plans.
  • Fix the issue where the query planner might fail for index types that support ordered access but not index-only scans.

For more details, see the official PostgreSQL 18.1 Release Notes.

New Features of IvorySQL 5.1

  • Upgraded to PG 18.1 Kernel
  • Online Experience: IvorySQL 5.1 launches a browser-based interactive experience environment, allowing users to explore and evaluate its features in real time without local installation.
  • Full-Platform Installation Package Support: Provide multi-platform installation packages covering X86, ARM, MIPS and LoongArch architectures.
  • Containerized Deployment Support: Enable one-click deployment of IvorySQL 5.1 standalone instances or high-availability clusters via Docker Compose, Podman, Swarm, Helm and Operator tools.
  • Synchronized Release of IvorySQL Cloud 5.1: Integrate the IvorySQL 5.1 database and its surrounding ecosystem to realize visual full-lifecycle management including database provisioning and deprovisioning, monitoring and operation.
  • PostgreSQL Extension Support: Add support for 10 PostgreSQL extensions, namely pg_cron, pgAudit, PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, system_stats, plpgsql_check and pgvector.

Fixed Issues

  • Clean up warning messages during the compilation process.
  • Fix the issue where the PL/iSQL parser rejects parenthesized syntax in SELECT INTO expressions.
  • Correct the documentation description about the missing uuid-ossp extension during source code installation.

Source Code

The development and maintenance of IvorySQL are mainly carried out in the following four code repositories:

Contributors

The following individuals (in alphabetical order) participated in this release as patch authors, committers, reviewers, testers or issue reporters:

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.

Thanks to all the contributors!

Try It Out Now

We welcome all community members to try IvorySQL 5.1. If you encounter any issues, please submit feedback via GitHub Issues. We will send you exclusive IvorySQL merchandise as a gift!