Dear Community Members,
We are excited to announce the release of IvorySQL 5.0, our largest Oracle compatibility expansion to date, built on PostgreSQL 18.0 with cloud-native deployment options and multi-platform distribution.
What's New in IvorySQL 5.0:
PostgreSQL 18.0 Foundation: Inherits all PostgreSQL 18.0 enhancements including the asynchronous I/O subsystem, optimizer statistics retention through pg_upgrade, skip scan lookups, uuidv7(), virtual generated columns, OAuth authentication, and temporal constraints.
21 Oracle Compatibility Features: ROWID support, PL/iSQL enhancements (CALL syntax, %ROWTYPE, %TYPE), NLS parameter compatibility, empty string to NULL translation, per-session parser switching, GB18030 encoding, SYS_GUID/SYS_CONTEXT/USERENV functions, OUT parameter support for functions and procedures, nested subprograms, and Oracle-compatible INSTR, FORCE VIEW, and LIKE operator.
Cloud-Native Deployment: Full support for Docker Compose, Docker Swarm, and Kubernetes with Helm charts. IvorySQL Operator 5.0 and IvorySQL Cloud 5.0 provide visual lifecycle management.
10 PostgreSQL Extensions: pg_cron, pgAudit, PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, system_stats, plpgsql_check, and pgvector.
Multi-Platform Distribution: Installation packages available for X86, ARM, MIPS, and LoongArch architectures.
Online Experience: An interactive, browser-based environment to explore and evaluate IvorySQL 5.0 — no installation required. Try it at https://ivorysql.org
For a detailed list of all the new features and fixes, please visit our release notes at https://github.com/IvorySQL/IvorySQL/releases/tag/IvorySQL_5.0
Acknowledgments and Contributions:
A huge thank you to all our users who contributed patches, reported bugs, and proposed new features. The names of all contributors to this release are listed in the release notes.
IvorySQL thrives on community contributions. We warmly welcome your ideas, feature requests, or patches. Please share your contributions on our GitHub page.
Source Code:
Useful Links:
We look forward to your feedback on IvorySQL 5.0 and your continued support in making IvorySQL even better.
Best regards,
IvorySQL Dev Team
About IvorySQL
IvorySQL is an open-source database initiated by Highgo Software that extends PostgreSQL with Oracle compatibility features, providing a practical migration path from Oracle while leveraging PostgreSQL's performance and reliability. Designed for applications ranging from small projects to enterprise systems, IvorySQL is driven by community contributions and adapts to the evolving needs of its users.