Kutulutsidwa kwa pulojekiti ya IvorySQL 2.1 kwasindikizidwa, ndikupanga kope la PostgreSQL DBMS, lomwe limapereka chiwongolero chowonetsetsa kuti zikugwirizana ndi mapulogalamu opangidwa kuti azigwira ntchito ndi Oracle DBMS. Zowonjezerazo zikupangidwa popanga kusintha kwa codebase yaposachedwa ya PostgreSQL ndipo opanga amati kuthekera kogwiritsa ntchito IvorySQL ngati chosinthira chowonekera cha mtundu waposachedwa wa PostgreSQL, kusiyana komwe kumatsikira ku mawonekedwe a "compatible_db" , yomwe imaphatikizapo kuyanjana ndi Oracle. Khodiyo idalembedwa mu C ndikugawidwa pansi pa layisensi ya Apache 2.0.
IvorySQL imagwiritsa ntchito chilankhulo cha PL/iSQL, chomwe chimatsatira mawu a PL/SQL, ndikuthandizira mapaketi amtundu wa Oracle ndi magwiridwe antchito monga "CREATE PACKAGE". IvorySQL imathandiziranso mawu a Oracle okhudzana ndi magwiridwe antchito, mawu, ndi ALTER TABLE, DELETE, UPDATE, CONNECT BY, GROUP BY, UNION, and MINUS statements, ndipo imapereka ntchito ndi mitundu yogwirizana ndi Oracle. Kutsanzira ntchito za Oracle, mitundu ndi phukusi, IvorySQL imagwiritsa ntchito ma code kuchokera ku Orafce PostgreSQL add-on.
Mtundu watsopano wa IvorySQL umapereka kusintha kwa code code ya PostgreSQL 15.1 ndikugwiritsa ntchito chithandizo chamagulu apadera apadziko lonse lapansi opangidwa pogwiritsa ntchito mawu akuti "CREATE UNIQUE INDEX global_index ON idxpart(bid) GLOBAL". Ma index oterowo atha kugwiritsidwa ntchito kupanga cholozera chapadera patebulo logawikana lomwe limakhalabe lapadera pamagawo onse akafikiridwa ndi kiyi yosagawa.
Source: opennet.ru