- News - lists.ivorysql.org

Announcing IvorySQL 3.2: New Oracle XML Function Compatibility and Upgrade to PostgreSQL 16.2
by GRANT ZH 12 Apr '24

12 Apr '24

Dear Community Members, We are excited to introduce IvorySQL 3.2, a significant update that includes a brand new feature for Oracle XML function compatibility alongside an upgrade to PostgreSQL 16.2. This release strengthens our PostgreSQL-based database project with improved capabilities and compatibility. ### What's New in IvorySQL 3.2: * **New Oracle XML Function Compatibility**: Introduces compatibility with a variety of Oracle XML functions, broadening our support for Oracle-based systems. * **Upgraded to PostgreSQL 16.2**: Updates the core database engine to PostgreSQL 16.2, incorporating the latest enhancements and bug fixes. ### Fixed Issues: * Resolved a documentation build failure: [Issue #645]( https://github.com/IvorySQL/IvorySQL/issues/645) * Eliminated build warnings: [Issue #649]( https://github.com/IvorySQL/IvorySQL/issues/649) * Corrected a parameter issue with the `to_date` function: [Issue #592]( https://github.com/IvorySQL/IvorySQL/issues/592) * Fixed label issues in the `create function` syntax: [Issue #624]( https://github.com/IvorySQL/IvorySQL/issues/624) For a detailed list of all the new features and fixes, please visit our release notes on [IvorySQL GitHub Releases]( https://github.com/IvorySQL/IvorySQL/releases) and the [IvorySQL Release Page](https://www.ivorysql.org/releases-page). ### Acknowledgments and Contributions: A huge thank you to all our users who contributed patches, reported bugs, and proposed new features. The names of all contributors to this release are listed in the release notes. IvorySQL thrives on community contributions. We warmly welcome your ideas, feature requests, or patches. Please share your contributions on our [GitHub page](https://github.com/IvorySQL/IvorySQL/). ### Useful Links: * **Homepage**: [IvorySQL Official Site](https://www.ivorysql.org) * **Documentation**: [IvorySQL Docs](https://docs.ivorysql.org/) * **GitHub Repository**: [IvorySQL GitHub]( https://github.com/IvorySQL/IvorySQL) * **Website Repository**: [Website GitHub]( https://github.com/IvorySQL/Ivory-www) * **Document Repository**: [Document Site GitHub]( https://github.com/IvorySQL/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 look forward to your feedback on IvorySQL 3.2 and your continued support in making IvorySQL even better. Best regards, The IvorySQL Development Team

1 0

Announcing IvorySQL 3.0: Enhanced PostgreSQL 16 Support with Oracle Compatibility
by GRANT ZH 16 Dec '23

16 Dec '23

Dear Community Members, We are thrilled to announce the launch of IvorySQL 3.0, a landmark update to our PostgreSQL-based database system, now featuring enhanced Oracle compatibility. What's New in IvorySQL 3.0: - Dual Parsers: Seamlessly supports different database parsers on two distinct listening ports. - initdb -m Feature: Flexibility to choose between postgres mode or oracle mode for tailored database management. - Oracle-Compatible Commands: Integration of Oracle Merge, Q escaping, and other similar functionalities. - Enhanced PL/SQL Support: Introduction of features like anonymous blocks to bolster compatibility. For a comprehensive rundown of all the new enhancements and fixes, we invite you to peruse our release notes on IvorySQL GitHub Releases <https://github.com/IvorySQL/IvorySQL/releases> and the IvorySQL Release Page <https://ivorysql.org/releases>. Acknowledgments and Contributions: Our heartfelt gratitude goes out to all users who contributed patches, reported bugs, or proposed novel features. The names of all contributors to this release can be found in the release notes. IvorySQL thrives thanks to community contributions. We warmly welcome your creative ideas, feature requests, or patches. Please share your contributions on our GitHub page <https://github.com/IvorySQL/IvorySQL>. Useful Links: - Homepage: IvorySQL Official Site <https://ivorysql.org/> - Documentation: IvorySQL Docs <https://docs.ivorysql.org/> - GitHub Repository: IvorySQL GitHub <https://github.com/IvorySQL/IvorySQL> - Website Repository: Website GitHub <https://github.com/IvorySQL/website> - Document Repository: Document Site GitHub <https://github.com/IvorySQL/docs> - Download IvorySQL: Download Page <https://ivorysql.org/download> - Support: Report issues here <https://github.com/IvorySQL/IvorySQL/issues> or contact contact(at)highgo(dot)ca <contact(a)highgo.ca> Your feedback on IvorySQL 3.0 is invaluable to us, and we eagerly await your insights and continued support in enhancing IvorySQL. Best regards, The IvorySQL Development Team

1 0

IvorySQL 1.2 official release announcement
by Usama Muhammad 28 Feb '22

28 Feb '22

IvorySQL Global Development Group is pleased to announce the availability of IvorySQL 1.2 IvorySQL 1.2 is an incremental release and contains numerous bug fixes and enhancements. For more details please see the release notes: https://www.ivorysql.org/ivorysql-v1-2-release-page You can read the IvorySQL documentation on: https://www.ivorysql.org/docs/intro Source code and packages available at: https://github.com/IvorySQL/IvorySQL/releases/tag/Ivory_REL_1_2 Subscribe to IvorySQL mailing lists https://lists.ivorysql.org/postorius/lists/ GitHub: https://github.com/IvorySQL/IvorySQL ... Muhammad Usama Highgo Software (Canada/China/Pakistan) URL : http://www.highgo.ca ADDR: 10318 WHALLEY BLVD, Surrey, BC

1 0

IvorySQL 1.1 official release announcement
by Usama Muhammad 27 Jan '22

27 Jan '22

IvorySQL Global Development Group is pleased to announce the availability of IvorySQL 1.1 IvorySQL 1.1 is an incremental release of IvorySQL 1 and contains numerous bug fixes and usability improvements. For more details please see the release notes: https://www.ivorysql.org/ivorysql-v1-1-release-page You can read the IvorySQL documentation on: https://www.ivorysql.org/docs/intro Source code and packages available at: https://github.com/IvorySQL/IvorySQL/releases/tag/Ivory_REL_1_1 Subscribe to IvorySQL mailing lists https://lists.ivorysql.org/postorius/lists/ GitHub: https://github.com/IvorySQL/IvorySQL ... Muhammad Usama Highgo Software (Canada/China/Pakistan) URL : http://www.highgo.ca ADDR: 10318 WHALLEY BLVD, Surrey, BC

1 0

Announcing IvorySQL
by Usama Muhammad 18 Jan '22

18 Jan '22

Hello and Welcome, We are excited to announce the very first release of IvorySQL. The only open source Oracle compatible PostgreSQL. IvorySQL at Glance IvorySQL is Apache 2.0 licensed Open Source Oracle compatible PostgreSQL. The very first release of IvorySQL is derived from PostgreSQL 14 with a firm commitment to always remain 100% compatible and a Drop-in replacement of the latest PostgreSQL. IvorySQL adds a compatible_db GUC on top of existing standard PostgreSQL configuration parameters. The “compatible_db” is a toggle switch to switch between Oracle and PostgreSQL compatibility modes. Another major highlight of IvorySQL is PL/iSQL procedural language that supports oracle’s PL/SQL syntax. These two additions sit at the core of Oracle compatibility of IvorySQL without breaking the standard PostgreSQL compatibility. The “compatible_db” switches the behaviour of functions and objects that exist in both Oracle and PostgreSQL and acts differently, while PLISQL builds the foundation for running the Oracle code on IvorySQL with minimal changes. IvorySQL 1.0 comes with numerous Oracle compatibility features including Oracle style PACKAGES, data types, and conversion functions. For details of Oracle compatibility features in IvorySQL 1.0 refer to IvorySQL documentation https://www.ivorysql.org/docs/intro We are committed to following the principles of the open source way IvorySQL is committed to abiding by the principles of open-source ways https://opensource.com/open-source-way and we strongly believe in building a healthy and inclusive community. We maintain that good ideas can come from anywhere, and the best ideas should win. Only by including diverse perspectives, we can reach the best decision. While the first version of IvorySQL is mainly focused on Oracle Compatibility features, going forward the future road map and feature set will be determined by the community in an open-source way. Contributing to the IvorySQL There are plenty of ways to contribute to IvorySQL. You can contribute by providing the documentation updates, by providing the translations for the documentation. If you have design skills you can contribute to the IvorySQL website project. Testing the IvorySQL and reporting issues or by issuing pull requests for bug fixes or new features or answering the questions on mailing lists are some ways to contribute to the IvorySQL project and all types of contributions are welcomed and appreciated by the IvorySQL community. Getting Started All IvorySQL related projects, including database server, website, and documentation are hosted and managed through Github. You can download the source code or released packages and track the current issues, pull requests, and discussions through the IvorySQL Github page https://github.com/IvorySQL/. Visit http://www.ivorysql.org/ for project documentation and contribution guidelines. Download the https://github.com/IvorySQL/IvorySQL/releases/tag/Ivory_REL_1_0 Join the IvorySQL community by subscribing to https://lists.ivorysql.org/postorius/lists/ and don't forget to give us a star on https://github.com/IvorySQL/IvorySQL ... Muhammad Usama Highgo Software (Canada/China/Pakistan) URL : http://www.highgo.ca ADDR: 10318 WHALLEY BLVD, Surrey, BC

1 0