{"id":106140,"date":"2022-12-17T21:36:43","date_gmt":"2022-12-17T19:36:43","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-ivorysql-2-1-nadstrojki-nad-postgresql-dlya-obespecheniya-sovmestimosti-s-oracle"},"modified":"2022-12-17T21:36:43","modified_gmt":"2022-12-17T19:36:43","slug":"vypusk-ivorysql-2-1-nadstrojki-nad-postgresql-dlya-obespecheniya-sovmestimosti-s-oracle","status":"publish","type":"post","link":"https:\/\/prohoster.info\/en\/blog\/news\/vypusk-ivorysql-2-1-nadstrojki-nad-postgresql-dlya-obespecheniya-sovmestimosti-s-oracle","title":{"rendered":"Release of IvorySQL 2.1, an extension on PostgreSQL for Oracle compatibility","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
The release of the IvorySQL 2.1 project has been published, which enhances the PostgreSQL database system by providing a layer for compatibility with applications designed to work with the Oracle database. The upgrade is developed by making changes to the latest PostgreSQL code base, and the developers claim that IvorySQL can be used as a transparent replacement for the latest version of PostgreSQL, with the only difference being the introduction of the 'compatible_db' setting that enables compatibility mode with Oracle. The code is written in C and is distributed under the Apache 2.0 license. <\/p>\n
IvorySQL implements the procedural language PL\/iSQL, mirroring the syntax of PL\/SQL and supports packages in the Oracle style as well as package operations such as 'CREATE PACKAGE'. IvorySQL also supports Oracle-specific syntax for operations, expressions, and commands like ALTER TABLE, DELETE, UPDATE, CONNECT BY, GROUP BY, UNION, and MINUS, providing an Oracle-compatible set of functions and types. Code from the PostgreSQL extension Orafce is used to emulate Oracle's functions, types, and packages in IvorySQL. <\/p>\n
The new version of IvorySQL has transitioned to the PostgreSQL 15.1 code base and has implemented support for global unique indexes, created using the expression 'CREATE UNIQUE INDEX global_index ON idxpart(bid) GLOBAL'. Such indexes can be used to create a unique index for a partitioned table that maintains uniqueness across all partitions when querying by a key that is not bound to the partitions. \n Source: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"