Published release of the project IvorySQL 5.0, developing the edition PostgreSQL DBMS, which provides compatibility with applications designed to work with Oracle DBMS. IvorySQL claims to be able to work as a transparent replacement for the latest version of PostgreSQL, the difference from which comes down to the appearance of the “compatible_db” setting, which enables Oracle compatibility mode. The code is written in C and distributed under the Apache 2.0 license.
IvorySQL implements the procedural language PL/iSQL, repeating the syntax PL/SQL on Oracle, supports Oracle-style packages and package operations such as “CREATE PACKAGE”. Provides an Oracle set of functions and types, and supports Oracle-specific syntax for operations, expressions, and statements such as ALTER TABLE, DELETE, UPDATE, CONNECT BY (hierarchical queries), GROUP BY, UNION and MINUS.
In new version:
- The transition to the PostgreSQL codebase has been completed 18.
- Compatibility with the Oracle DBMS has been improved: support has been implemented for nested routines, ROWID, NLS and OUT parameters, translation of empty strings to NULL, changing parsers in connection with sessions, GB18030 encoding, SYS_GUID, SYS_CONTEXT and USERENV functions.
- Added Oracle-compatible INSTR, FORCE VIEW and LIKE operators.
- Enhanced PL/iSQL capabilities: added support for CALL syntax, %ROWTYPE and %TYPE.
- Added full support for Docker Compose, Docker Swarm and Kubernetes with the Helm package manager. IvorySQL Operator 5.0 and IvorySQL Cloud 5.0 add tools for visual lifecycle management.
- Support for ten extensions to PostgreSQL is provided: pg_cron, pgAudit, PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, system_stats, plpgsql_check and pgvector.
- Installation packages have been generated for the X86_64, ARM64, MIPS and LoongArch architectures.
- An online environment has been prepared for working with IvorySQL from a browser, allowing you to do without installing IvorySQL on your system.
Additionally, you can note release