Skip to content

IvorySQL

About IvorySQL

IvorySQL is an advanced, full-featured, Oracle open source compatible PostgreSQL with a firm commitment to always remain 100% compatible and a direct replacement for the latest PostgreSQL.

One of the highlights of IvorySQL is the PL/iSQL procedural language, which supports Oracle’s PL/SQL syntax. At the same time, IvorySQL implements Oracle-compatible functions by adding plug-ins ivorysql_ora bound to the kernel, and the functions currently implemented include built-in functions, data types, system views, merges, and the addition of GUC parameters, and will continue to implement new compatible functions in the form of plug-ins bound to the kernel in the future.

Competitive Advantages

Oracle Compatible

IvorySQL is designed to provide seamless Oracle compatibility, enabling users to transition from Oracle databases without significant rewrites or application changes. With support for key Oracle syntax, data types, and functions, IvorySQL makes migrations simple and cost-effective while maintaining performance and reliability.

Open-Source Community

As an open-source database, IvorySQL thrives on the strength of its vibrant community. Developers and businesses benefit from ongoing innovation, transparency, and collaboration, ensuring the database is always up to date with the latest advancements and features.

Multiple Compatibility Modes

IvorySQL offers multiple compatibility modes to suit diverse user requirements. Whether you’re working with Oracle or PostgreSQL-native applications, its flexible compatibility modes ensure smooth operation, simplifying development and deployment in hybrid environments.

Highly Customizable

IvorySQL is built to adapt to your specific needs, offering extensive customization options. From performance tuning to feature extensions, users can tailor the database to align with unique application requirements and business goals.

Powered By PostgreSQL

Built on PostgreSQL, IvorySQL inherits the power and reliability of one of the world’s most advanced open-source databases. This foundation ensures unmatched scalability, robustness, and a rich set of features for modern application development.

Numerous Compatibility Features

IvorySQL goes beyond basic compatibility, providing a comprehensive suite of features such as PL/SQL support, Oracle-style anonymous block, packages, XML function, sequences, invisible columns and many more!

Compatible Features

IvorySQL Community

IvorySQL is maintained by a core team of developers with commit rights to the main IvorySQL repository on GitHub. At the same time, we are very eager to receive contributions from anybody in the wider IvorySQL community. If you would like to contribute to the project, refer to our contributing guide here.

We are committed to the principles of the open source approach and we strongly believe in building a healthy and inclusive community. We insist that good ideas can come from anywhere. Only by including different perspectives can we make the best decisions. While the first release of IvorySQL focuses on Oracle-compatible features, the future roadmap and feature set will be defined by the community in an open source manner.

Requirement

  • CPI: 4 ~ 16 cores
  • RAM: 4 ~ 64 GB
  • Storage: 800 MB ~ 5GB+ (SSD or NvMe)
  • Network: 1Gpbs ~ 10Gbps network

Documentation