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 1tRDc9-0085l2-85 for pgsql-announce@arkaria.postgresql.org; Fri, 27 Dec 2024 16:55: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 1tRDc8-00BuzK-Ax for pgsql-announce@arkaria.postgresql.org; Fri, 27 Dec 2024 16:55:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tRDXO-00BX25-Dz for pgsql-announce@lists.postgresql.org; Fri, 27 Dec 2024 16:50:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tRDXK-001u8d-RB for pgsql-announce@lists.postgresql.org; Fri, 27 Dec 2024 16:50:09 +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=p/5+siDRKHX/63xWa9GAxLnvuCi5M47Nyj219NZfDFU=; b=yR3TGslo2QMHsUZP3IDYfbKoTn ptCVc7Ut2EzKODqR3y3wC0NQfwSMnlQNbcQpOfvzahe3sQWUf/QZI6i9i2HH5/cis4OywfnCtvVVs TQ0Rlt8wKh0BhELWof8lSXoTNAPHAvZaBCfH01lKqfnn85tvWTiO5GSlBQrWb1PRvf99za+wn5zWZ vJ7/+Om1wSEd/RlB3ayFFCCKoMqpaOwCu5GsNe7/HnNel0cE5AfOdbFAgVq205ou+yMESg+6jSusw lsowjku350Ojua6+t5Hfiuqm5YvNmQ8GGzJOnkrHOL5gFRgs1g7CQkl2FmLYyOpHCmLdV/MxHV8RQ rsIIpKew==; 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 1tRDXJ-005OwB-4q for pgsql-announce@lists.postgresql.org; Fri, 27 Dec 2024 16:50:05 +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 1tRDXG-007q71-38 for pgsql-announce@lists.postgresql.org; Fri, 27 Dec 2024 16:50:02 +0000 Content-Type: multipart/mixed; boundary="===============8989536488006975117==" MIME-Version: 1.0 Subject: [ANNOUNCE] IvorySQL 4.0 Released - Enhanced Oracle Compatibility with PostgreSQL 17.0 Foundation To: PostgreSQL Announce From: Highgo Software via PostgreSQL Announce Reply-To: contact@highgo.ca Date: Fri, 27 Dec 2024 16:49:44 +0000 Message-ID: <173531818408.680.5945434246914836617@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: 582575de9f20c7483b5adc37b411791d26ae806ff335a7f70b79c7f9a85fb6e7 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8989536488006975117== Content-Type: multipart/alternative; boundary="===============6997333103213313936==" MIME-Version: 1.0 --===============6997333103213313936== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable # 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 enhanc= es database functionality while maintaining strong compatibility with Oracl= e systems. ## IvorySQL 4.0 Enhancements ### Oracle Compatibility Features #### **Invisible Columns Support** ([#608](https://github.com/IvorySQL/Ivor= ySQL/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/Ivor= ySQL/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/Iv= orySQL/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/IvoryS= QL/IvorySQL/issues/575)) - New Ubuntu installation package support ([#703](https://github.com/Ivo= rySQL/IvorySQL/issues/703)) ## Source Code Repositories - Database Source: [github.com/IvorySQL/IvorySQL](https://github.com/IvoryS= QL/IvorySQL) - Website Source: [github.com/IvorySQL/Ivory-www](https://github.com/IvoryS= QL/Ivory-www) For detailed changes, see the [Complete Changelog](https://github.com/Ivory= SQL/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 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. --===============6997333103213313936== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable [ANNOUNCE] IvorySQL 4.0 Released - Enhanced Oracle Compatibility= with PostgreSQL 17.0 Foundation
 

[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 an= d introduces significant Oracle compatibility features along with various i= mprovements. This release enhances database functionality while maintaining= strong compatibility with Oracle systems.

IvorySQL 4.0 Enhancements

Oracle Compatibility Features

Invisible Columns Suppo= rt (#608)

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

PL/SQL Package Manageme= nt (#589)

  • Complete packag= e lifecycle management (create, alter, describe)
  • New \k command = in psql for package operations
  • Advanced privil= ege management with new ACL functions
  • Performance opt= imization through package caching

Core Improvements

Enhanced pg_get_functio= ndef (#696)

  • Support for mul= tiple function OIDs in parameter list
  • Improved functi= on definition export for overloaded functions

Installation and Setup<= /strong>

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

Source Code Repositories

For detailed changes, see the Complete Changelog

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/.
 
--===============6997333103213313936==-- --===============8989536488006975117==--