[ANNOUNCE] IvorySQL 4.0 Released - Enhanced Oracle Compatibility with PostgreSQL 17.0 FoundationIvorySQL 4.0 Release NotesRelease 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 EnhancementsOracle Compatibility FeaturesInvisible 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 ImprovementsEnhanced 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 RepositoriesFor detailed changes, see the Complete Changelog Thank you for your continued support and trust in IvorySQL. Best regards, The IvorySQL Team About IvorySQLIvorySQL 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. |