IvorySQL is a PostgreSQL-based relational database that extends PostgreSQL with compatibility features for applications originally developed for Oracle Database.
The project retains PostgreSQL functionality while adding support for Oracle SQL syntax, procedural constructs and database objects. Its compatibility layer is intended to reduce the changes required when migrating Oracle applications to a PostgreSQL-based environment.
IvorySQL provides separate PostgreSQL and Oracle compatibility modes, allowing database administrators and developers to select the appropriate behaviour for their applications. Its PL/iSQL procedural language implements Oracle-style programming constructs, including stored procedures and packages, while preserving access to PostgreSQL database facilities.
This is free and open source software.
Key Features
- PostgreSQL-based relational database with additional Oracle compatibility functionality.
- Configurable compatibility modes allow applications to use PostgreSQL or Oracle-style SQL behaviour.
- PL/iSQL procedural language supports Oracle-compatible stored procedures and functions.
- Oracle-style packages provide facilities for grouping related procedures, functions and other program elements.
- Additional Oracle-compatible SQL syntax reduces application changes during database migration.
- Support for Oracle-oriented data types and database expressions improves compatibility with existing applications.
- Oracle-compatible extensions provide additional database functions and procedural capabilities.
- PostgreSQL transaction processing, indexing and query optimisation remain available.
- PostgreSQL extensions and administration tools can be used alongside IvorySQL-specific functionality.
- Compatibility settings allow database environments to accommodate applications with different SQL dialect requirements.
Website: github.com/IvorySQL/IvorySQL
Support:
Developer: IvorySQL community
License: Apache License 2.0
IvorySQL is written in C. Learn C with our recommended free books and free tutorials.
Related Software
| Relational Databases | |
|---|---|
| MariaDB | High compatibility with MySQL, ensuring drop-in replacement capability |
| PostgreSQL | Award winning Object-relational database management system |
| MySQL | Multithreaded, multi-user SQL database management system |
| SQLite | Embeddable SQL Database Engine |
| TiDB | Cloud-native, distributed SQL database |
| DuckDB | In-process SQL OLAP database management system |
| Turso | In-process relational database engine |
| YugabyteDB | PostgreSQL-compatible distributed SQL database |
| rqlite | Distributed database built on SQLite |
| MonetDB | High performance relational database system for analytics |
| Dolt | Version-controlled SQL database |
| Firebird | Relational database offering many ANSI SQL features |
| H2 | Relational database management system written in Java |
| HSQLDB | JDBC interface, client-server version, query tool, grid and more |
| CUBRID | Database engine with built-in enterprise grade features |
| Apache Cloudberry | Massively parallel processing database |
| Virtuoso | Data Management with Web Application Server and Web Services |
| Apache Derby | Full-featured relational database implemented entirely in Java |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.