Ukukhishwa kwe-IvorySQL 2.1, isengezo se-PostgreSQL sokuhambisana kwe-Oracle

Ukukhishwa kwephrojekthi ye-IvorySQL 2.1 kushicilelwe, kuthuthukiswa uhlelo lwe-PostgreSQL DBMS, oluhlinzeka ngesendlalelo sokuqinisekisa ukuhambisana nezinhlelo zokusebenza eziklanyelwe ukusebenza ne-Oracle DBMS. Isengezo sithuthukiswa ngokwenza izinguquko ku-codebase yakamuva ye-PostgreSQL futhi abathuthukisi bathi kungenzeka ukusebenzisa i-IvorySQL njengokushintsha okusobala kwenguqulo yakamuva ye-PostgreSQL, umehluko ovela lapho wehlela ekubonakaleni kwesilungiselelo se-“compatible_db”. , okufaka imodi yokuhambisana ne-Oracle. Ikhodi ibhalwe ngo-C futhi isatshalaliswa ngaphansi kwelayisensi ye-Apache 2.0.

I-IvorySQL isebenzisa ulimi lwenqubo lwe-PL/iSQL, olulandela i-syntax ye-PL/SQL, futhi isekela amaphakheji wesitayela se-Oracle nemisebenzi yephakheji efana ne-"CREATE PACKAGE". I-IvorySQL iphinde futhi isekele i-syntax eqondene ne-Oracle yokusebenza, izinkulumo, kanye ne-ALTER TABLE, DELETE, UPDATE, CONNECT BY, GROUP BY, UNION, kanye nezitatimende ze-MINUS, futhi inikeza isethi yemisebenzi nezinhlobo ezihambisana ne-Oracle. Ukulingisa imisebenzi ye-Oracle, izinhlobo namaphakheji, i-IvorySQL isebenzisa ikhodi evela kusengezo se-Orafce PostgreSQL.

Inguqulo entsha ye-IvorySQL ihlinzeka ngokushintshela kusisekelo sekhodi ye-PostgreSQL 15.1 futhi isebenzise ukusekelwa kwezinkomba zomhlaba ezihlukile ezidalwe kusetshenziswa isisho esithi “DALA INHLOKO EYIHLUKILEYO global_index ON idxpart(bid) GLOBAL”. Izinkomba ezinjalo zingasetshenziswa ukudala inkomba eyingqayizivele kuthebula elihlukanisiwe elihlala lihlukile kuzo zonke izingxenye uma lifinyelelwa ngokhiye ongahlukanisiwe.

Source: opennet.ru