IvorySQL 5.0 Released - Major Oracle Compatibility Expansion on PostgreSQL 18.0 Foundation

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

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:</s...

Get the full details here: https://www.postgresql.org/about/news/ivorysql-50-released-major-oracle-compatibility-expansion-on-postgresql-180-foundation-3180/