# 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](https://github.com/IvorySQL/IvorySQL/issues/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](https://github.com/IvorySQL/IvorySQL/issues/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](https://github.com/IvorySQL/IvorySQL/issues/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](https://github.com/IvorySQL/IvorySQL/issues/575)) - New Ubuntu installation package support ([#703](https://github.com/IvorySQL/IvorySQL/issues/703)) ## Source Code Repositories - Database Source: [github.com/IvorySQL/IvorySQL](https://github.com/IvorySQL/IvorySQL) - Website Source: [github.com/IvorySQL/Ivory-www](https://github.com/IvorySQL/Ivory-www) For detailed changes, see the [Complete Changelog](https://github.com/IvorySQL/IvorySQL/commits/IVORY_REL_4_STABLE) 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.
