September 26, 2024: PostgreSQL 17 Released!

Announcing IvorySQL 3.4: PostgreSQL 16.4 Support with Oracle Compatibility

Posted on 2024-10-05 by Highgo Software
Related Open Source

Subject: Announcing IvorySQL 3.4: PostgreSQL 16.4 Support with Oracle Compatibility

Dear Community Members,

We are thrilled to announce the release of IvorySQL 3.4, based on PostgreSQL 16.4. This version brings significant enhancements, bug fixes, and new features to improve your database experience, with a focus on Oracle compatibility.

Key Highlights:

PostgreSQL 16.4 Enhancements

  • Improved security with prevention of unauthorized code execution during pg_dump
  • Enhanced accuracy of Merge Right Anti Join plans
  • Resolved VACUUM infinite loop issue
  • Fixed partition attachment problems
  • Improved ISO-8601 time format handling

Oracle Compatibility Features

  • Oracle sequence support added
  • New xmlisvalid function
  • Character type limit set to 2000 in Oracle mode
  • Support for adding constraints to existing tables using ALTER TABLE ADD (CONSTRAINT ...)
  • New Oracle-compatible functions: TO_MULTI_BYTE(), TO_SINGLE_BYTE(), ASCIISTR(), COMPOSE(), DECOMPOSE()

Additional Improvements

  • Expanded architecture support for Debian in docker_library project
  • Multiple bug fixes to enhance stability and performance

To access the source code and contribute: For a detailed list of all the new features and fixes, please visit our release notes at IvorySQL GitHub Releases, IvorySQL Home Page and IvorySQL Documents

Contributions: We extend our heartfelt thanks to our diverse community of contributors who have made this release possible. Your dedication and expertise continue to drive IvorySQL forward.

Useful Links

We encourage you to upgrade to IvorySQL 3.4 to take advantage of these improvements, especially if you're looking for enhanced Oracle compatibility alongside PostgreSQL's latest features. As always, we welcome your feedback and contributions to make IvorySQL even better.

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.