IVORYSQL 2.1, superstructures over postgreSQL to ensure compatibility with Oracle

published the project ivorysql 2.1 , developing the editorial office of the PostgreSQL DBMS, providing a layer to ensure compatibility with applications designed to work with the Oracle DBMS. The superstructure develops by making changes to the fresh code base PostgreSQL and developers declare the possibility of using iVorySQL as a transparent replacement of the latest version of postgreSQL, the difference from which comes down to the emergence of the Compatible_DB settings, which includes a compatibility mode with Oracle. The code is written in the language of si and spreads under the license Apache 2.0.

iVorySQL implements the procedural language pl/isql , repeating PL/SQL syntax, and supports packages in the Oracle style and operations with packages, such as” Create Package “. IVORYSQL also supports the syntax of operations, expressions and operators alter table , Delete , /a>, connect by , Group by , union =”https://www.ivorysql.org/docs/next/compathillity_features/minus”> minus , a set of functions and types compatible with Oracle. To emulate the functions, types and Oracle packets in IvorySQL, the postgreSQL code is used orafce .

In the new version of ivorysql provided transition to the code PostgreSQL 15.1 and support of global unique indexes is implemented created using the expression “Create Unique Index Global_index on IDXPART (BID) Global”. Such indices can be used to create a unique index for a sectioned table, which retains uniqueness for all sections when sample by a key -related key.