Ho lokolloa ha morero oa IvorySQL 2.1 ho hatisitsoe, ho nts'etsapele khatiso ea PostgreSQL DBMS, e fanang ka lera bakeng sa ho netefatsa ho lumellana le likopo tse etselitsoeng ho sebetsa le Oracle DBMS. Tlatsetso e ntse e ntlafatsoa ka ho etsa liphetoho ho codebase ea morao-rao ea PostgreSQL mme bahlahisi ba bolela monyetla oa ho sebelisa IvorySQL e le phetisetso e hlakileng bakeng sa mofuta oa morao-rao oa PostgreSQL, phapang ho tloha ho eona e theohelang ponahalong ea "compatible_db" , e kenyeletsang mokhoa oa ho lumellana le Oracle. Khoutu e ngotsoe ka C mme e ajoa tlasa laesense ea Apache 2.0.
IvorySQL e sebelisa puo ea tsamaiso ea PL/iSQL, e latelang syntax ea PL/SQL, 'me e tšehetsa liphutheloana tsa mokhoa oa Oracle le ts'ebetso ea liphutheloana tse kang "CREATE PACKAGE". IvorySQL e boetse e tšehetsa li-syntax tse khethehileng tsa Oracle bakeng sa ts'ebetso, lipolelo, le ALTER TABLE, DELETE, UPDATE, CONNECT BY, GROUP BY, UNION, le MINUS statements, mme e fana ka lihlopha le mefuta e lumellanang le Oracle. Ho etsisa mesebetsi ea Oracle, mefuta le liphutheloana, IvorySQL e sebelisa khoutu e tsoang ho tlatsetso ea Orafce PostgreSQL.
Mofuta o mocha oa IvorySQL o fana ka phetoho ho PostgreSQL 15.1 code base mme e sebelisa ts'ehetso bakeng sa li-index tse ikhethileng tsa lefats'e tse entsoeng ka poleloana "CREATE UNIQUE INDEX global_index ON idxpart(bid) GLOBAL". Li-index tse joalo li ka sebelisoa ho theha index e ikhethang holim'a tafole e arotsoeng e lulang e ikhethile likarolong tsohle ha e fihleloa ka senotlolo se sa arolang.
Source: opennet.ru