Develop an Oracle-compatible database based on Postgres - Grant Zhou - PGCon 2022

Develop a seamless Oracle-compatible database using Postgres, with native support for packages, functions, and procedures, and a migration tool for easy migration from Oracle to PostgreSQL.

Key takeaways
  • The I/O SQL project aims to create an Oracle-compatible database based on PostgreSQL.
  • Oracle-compatible syntax is achieved through syntax transformation inside the parser.
  • The project provides Oracle-compatible features, such as packages, functions, and procedures.
  • The project is an open source initiative, with a community-driven development process.
  • The project is built on top of PostgreSQL and provides Oracle-compatible data types, such as DATE and TIMESTAMP.
  • The project includes support for Oracle-compatible PL/SQL procedural language and GLC (Golden Layer Cache) for improved performance.
  • The project provides a migration tool for migrating Oracle databases to PostgreSQL.
  • The project is developed in collaboration with PostgreSQL experts and fans with decades of experience.
  • The project is licensed under the Apache 2.0 license.
  • The project is mainly developed in China, with thousands of products running in different customers in China.
  • The project aims to provide a cost-effective alternative to Oracle and is open to contributions from the community.
  • The project has a roadmap, with future developments planned to improve the compatibility and functionality of the database.
  • The project has a GitHub repository and opens issues and pull requests for community contributions.