IvorySQL adds Oracle compatibility layer to PostgreSQL with PL/iSQL and dialect switching

IvorySQL is an open-source relational database built on PostgreSQL that introduces a compatibility layer for Oracle Database applications. The project implements dual-mode operation, allowing administrators to select either standard PostgreSQL behavior or Oracle-style SQL syntax and procedural constructs at runtime. This architecture targets organizations seeking to migrate Oracle-dependent applications without complete application rewrites.

The project's core additions include PL/iSQL, a procedural language supporting Oracle-compatible stored procedures, functions, and packages for grouping related program elements. IvorySQL preserves underlying PostgreSQL facilities including transaction processing, indexing, query optimization, and extension ecosystems. The software is developed by the IvorySQL community and released under the Apache License 2.0, with source code written in C.

Oracle compatibility architecture and implementation

• Dual compatibility modes: IvorySQL provides separately configurable PostgreSQL and Oracle compatibility modes, allowing runtime selection of SQL dialect behavior without maintaining separate database forks.
• PL/iSQL procedural language: The project implements a custom procedural language supporting Oracle-style stored procedures, functions, and packages that group related procedural elements, operating alongside standard PostgreSQL facilities.
• Oracle SQL syntax and data types: The compatibility layer adds Oracle-oriented SQL syntax, database expressions, and data types intended to reduce required application changes during migration from Oracle Database.
• PostgreSQL core preservation: IvorySQL retains PostgreSQL's transaction processing, indexing, query optimization engine, and extension compatibility, allowing existing PostgreSQL administration tools and extensions to function alongside Oracle-specific features.
• Open-source licensing and implementation: The project is written in C, hosted on GitHub under the IvorySQL organization, and distributed under the Apache License 2.0.

Why it matters

IvorySQL addresses a persistent gap in the open-source database landscape by targeting Oracle workload migration, a use case where proprietary licensing costs drive significant enterprise demand for alternatives. For Linux distribution maintainers and database administrators, the project's compatibility approach offers a potential drop-in path that avoids the operational complexity of maintaining parallel database systems or extensive application rewrites. The Apache 2.0 licensing and PostgreSQL foundation may attract contributors from existing PostgreSQL ecosystems while providing enterprises with clearer legal footing than some previous Oracle compatibility efforts.