[ANNOUNCE] IvorySQL 4.0 Released - Enhanced Oracle Compatibility with PostgreSQL 17.0 Foundation

IvorySQL 4.0 Release Notes

Release Date: December 23, 2024

IvorySQL 4.0 is built on PostgreSQL 17.0 and introduces significant Oracle compatibility features along with various improvements. This release enhances database functionality while maintaining strong compatibility with Oracle systems.

IvorySQL 4.0 Enhancements

Oracle Compatibility Features

Invisible Columns Support (#608)

• Implementation of invisible columns
• Enhanced psql support with extended description (\d+) in Oracle mode
• Columns remain hidden unless explicitly referenced by name

PL/SQL Package Management (#589)

• Complete package lifecycle management (create, alter, describe)
• New \k command in psql for package operations
• Advanced privilege management with new ACL functions
• Performance optimization through package caching

Core Improvements

Enhanced pg_get_functiondef (#696)

• Support for multiple function OIDs in parameter list
• Improved function definition export for overloaded functions

Installation and Setup

• Added 'ivorysql' as default database (#575)
• New Ubuntu installation package support (#703)

Source Code Repositories

• Database Source: github.com/IvorySQL/IvorySQL
• Website Source: github.com/IvorySQL/Ivory-www

For detailed changes, see the Complete Changelog

Thank you for your continued support and trust in IvorySQL.

Best regards,

The IvorySQL Team

About IvorySQL

IvorySQL is a new open-source database project initiated by Highgo Software that extends PostgreSQL, one of the most advanced and widely-used relational database systems. It uniquely integrates Oracle compatibility features, making it an ideal solution for users seeking the robustness and versatility of PostgreSQL with the added benefit of Oracle compatibility.

This integration facilitates easier migration from Oracle databases to IvorySQL, allowing users to leverage PostgreSQL's performance, reliability, and cost-effectiveness while maintaining familiarity with Oracle's functionalities.

Designed to cater to a wide range of applications, from small-scale projects to large enterprise systems, IvorySQL stands out for its commitment to community-driven development, ensuring continuous improvement and adaptation to the evolving needs of its users.