Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sx27s-007SwL-Cn for pgsql-announce@arkaria.postgresql.org; Sat, 05 Oct 2024 10:35:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sx27r-00G29r-OX for pgsql-announce@arkaria.postgresql.org; Sat, 05 Oct 2024 10:35:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sx23A-00FdTv-3s for pgsql-announce@lists.postgresql.org; Sat, 05 Oct 2024 10:30:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sx236-002b15-KV for pgsql-announce@lists.postgresql.org; Sat, 05 Oct 2024 10:30:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=6+IDOEdGEzdias27LR6dQ5pShmi5oihUpkq0HfEWxUM=; b=SjTYfbXpznjpgaa0cc+pAoJl4B eFH2zbTHaXUA43poWMhpaaMrFFF06cwYBVXSoWmWEPhy3KpQ4Icoih3pXLmXTLO86F8FpzfHgGJEo 1GR5Bhod4olSv5vhVz2YeWjH9k19/7qz8Qsl9K02Pwjec4kRP4+18MkXsVlcdl5LUE8dlpOpu0Xlw T9UwsmfqU63McSZhHq2lzM4x2shYvy5Ba46xbdNQJgaSVyxHnC6U0mGsTOeMAjoyTr6tqx7WUUljQ 8mSD4IzKhBzO+FvcLtVSW1bjgCCA1jL1l3/SMpuf9WOjpAmCIlvCum04l85pSxDaoAj4x8tX96aC5 CUd0cenQ==; Received: from wrigleys.postgresql.org ([217.196.149.60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sx235-008A2B-3M for pgsql-announce@lists.postgresql.org; Sat, 05 Oct 2024 10:30:08 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sx232-00FFLJ-JS for pgsql-announce@lists.postgresql.org; Sat, 05 Oct 2024 10:30:04 +0000 Content-Type: multipart/mixed; boundary="===============5725870085495515693==" MIME-Version: 1.0 Subject: Announcing IvorySQL 3.4: PostgreSQL 16.4 Support with Oracle Compatibility To: PostgreSQL Announce From: Highgo Software via PostgreSQL Announce Reply-To: grantzhou@highgo.ca Date: Sat, 05 Oct 2024 10:29:26 +0000 Message-ID: <172812416669.692.6947582821649109668@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: ac1fc36a25c73bf7773313a7afda43e5835d4823ee92fd65e371e926aa8e6114 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5725870085495515693== Content-Type: multipart/alternative; boundary="===============2526562328703395410==" MIME-Version: 1.0 --===============2526562328703395410== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Subject: Announcing IvorySQL 3.4: PostgreSQL 16.4 Support with Oracle Compa= tibility Dear Community Members, We are thrilled to announce the release of **IvorySQL 3.4**, based on Postg= reSQL 16.4. This version brings significant enhancements, bug fixes, and ne= w features to improve your database experience, with a focus on Oracle comp= atibility. #Key Highlights: ## PostgreSQL 16.4 Enhancements - Improved security with prevention of unauthorized code execution during p= g_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(), ASCII= STR(), 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 rel= ease notes at [IvorySQL GitHub Releases](https://github.com/IvorySQL/IvoryS= QL/releases), [IvorySQL Home Page](https://www.ivorysql.org/) and [IvorySQL= Documents](https://docs.ivorysql.org/en/ivorysql-doc/v3.4/) Contributions: We extend our heartfelt thanks to our diverse community of c= ontributors who have made this release possible. Your dedication and expert= ise continue to drive IvorySQL forward. ## Useful Links * **GitHub Repository**: [IvorySQL GitHub](https://github.com/IvorySQL/Ivor= ySQL) * **Homepage**: [IvorySQL Official Site](https://www.ivorysql.org) * **Documentation**: [IvorySQL Docs](https://docs.ivorysql.org/) * **Website Repository**: [Website GitHub](https://github.com/IvorySQL/Ivor= y-www) * **Document Repository**: [Document Site GitHub](https://github.com/IvoryS= QL/ivory-doc-builder) * **Download IvorySQL**: [Download Page](https://www.ivorysql.org/releases-= page) * **Support**: Report issues [here](https://github.com/IvorySQL/IvorySQL/) = or contact contact(at)highgo(dot)ca We encourage you to upgrade to IvorySQL 3.4 to take advantage of these impr= ovements, especially if you're looking for enhanced Oracle compatibility al= ongside PostgreSQL's latest features. As always, we welcome your feedback a= nd contributions to make IvorySQL even better. Thank you for your continued support and trust in IvorySQL. Best regards, The IvorySQL Team ------------------- **About IvorySQL**=20 IvorySQL is a new open-source database project initiated by Highgo Software= that extends PostgreSQL, one of the most advanced and widely-used relation= al database systems. It uniquely integrates Oracle compatibility features, = making it an ideal solution for users seeking the robustness and versatilit= y of PostgreSQL with the added benefit of Oracle compatibility. This integration facilitates easier migration from Oracle databases to Ivor= ySQL, allowing users to leverage PostgreSQL's performance, reliability, and= cost-effectiveness while maintaining familiarity with Oracle's functionali= ties. Designed to cater to a wide range of applications, from small-scale project= s to large enterprise systems, IvorySQL stands out for its commitment to co= mmunity-driven development, ensuring continuous improvement and adaptation = to the evolving needs of its users. --===============2526562328703395410== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Announcing IvorySQL 3.4: PostgreSQL 16.4 Support with Oracle Com= patibility
 

Announcing IvorySQL 3.4: PostgreSQL 16.4 Support with Oracle Compatib= ility

Subject: Announcing IvorySQL 3.4: PostgreSQ= L 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 bring= s significant enhancements, bug fixes, and new features to improve your dat= abase experience, with a focus on Oracle compatibility.

Key Highlights:

PostgreSQL 16.4 Enhancements
  • Improved securi= ty with prevention of unauthorized code execution during pg_dump
  • Enhanced accura= cy of Merge Right Anti Join plans
  • Resolved VACUUM= infinite loop issue
  • Fixed partition= attachment problems
  • Improved ISO-86= 01 time format handling

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

Additional Improvements

  • Expanded archit= ecture support for Debian in docker_library project
  • Multiple bug fi= xes 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 rel= ease notes at IvorySQL GitHub Releases<= /a>, IvorySQL Home Page and IvorySQL Documents

Contributions: We extend our heartfelt than= ks to our diverse community of contributors who have made this release poss= ible. 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 al= ways, we welcome your feedback and contributions to make IvorySQL even bett= er.

Thank you for your continued support and tr= ust in IvorySQL.

Best regards,

The IvorySQL Team

About IvorySQL

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

This integration facilitates easier migrati= on from Oracle databases to IvorySQL, allowing users to leverage PostgreSQL= 's performance, reliability, and cost-effectiveness while maintaining famil= iarity with Oracle's functionalities.

Designed to cater to a wide range of applic= ations, from small-scale projects to large enterprise systems, IvorySQL sta= nds out for its commitment to community-driven development, ensuring contin= uous improvement and adaptation to the evolving needs of its users.
This email was sent to you from Highgo Software. It was delivered on their = behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to Highgo Software.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============2526562328703395410==-- --===============5725870085495515693==--