Ukukhutshwa kweprojekthi ye-IvorySQL 2.1 ishicilelwe, ephuhlisa uhlelo lwe-PostgreSQL DBMS ebonelela ngoluhlu lokuqinisekisa ukuhambelana nezicelo ezenzelwe ukusebenza kunye ne-Oracle DBMS. I-add-on iphuhliswa ngokwenza utshintsho kwi-codebase ye-PostgreSQL entsha, kwaye abaphuhlisi babhengeza ithuba lokusebenzisa i-IvorySQL njengento ecacileyo yoguqulelo lwamva nje lwe-PostgreSQL, umahluko ovela ezantsi kwimbonakalo ye "compatible_db" isicwangciso, esiquka indlela yokuhambelana ye-Oracle. Ikhowudi ibhalwe kwi-C kwaye isasazwe phantsi kwelayisensi ye-Apache 2.0.
I-IvorySQL isebenzisa ulwimi lwenkqubo lwe-PL/iSQL olulinganisa i-syntax ye-PL/SQL kwaye ixhasa iiphakheji ze-Oracle-style kunye nemisebenzi yephakheji efana ne-"CREATE PACKAGE". I-IvorySQL iphinde ixhase i-syntax ye-Oracle-specific ye-ALTER TABLE, DELETE, UPDATE, CONNECT BY, GROUP BY, UNION, kunye nokusebenza kwe-MINUS, iintetho, kunye neengxelo, kwaye ibonelela ngeseti ehambelana ne-Oracle yemisebenzi kunye neentlobo. I-IvorySQL isebenzisa ikhowudi yokongeza ye-Orafce PostgreSQL ukulinganisa imisebenzi ye-Oracle, iindidi, kunye neepakethi.
Uguqulelo olutsha lwenguqu ye-IvorySQL kwisiseko sekhowudi ye-PostgreSQL 15.1 kwaye iphumeza inkxaso yezalathisi ezikhethekileyo zehlabathi ezidalwe kusetyenziswa i-"CREATE UNIQUE INDEX global_index ON idxpart(bid) GLOBAL" statement. Ezo zalathisi zingasetyenziswa ukwenza isalathiso esisodwa kwitafile eyohluliweyo ekhethekileyo kuzo zonke izahlulo xa ulanda isitshixo esingahlulwanga.
umthombo: opennet.ru