Kuburitswa kweiyo IvorySQL 2.1 purojekiti yakatsikiswa, ichigadzira edition yePostgreSQL DBMS, iyo inopa layer yekuona kuenderana nezvikumbiro zvakagadzirirwa kushanda neOracle DBMS. Iyo yekuwedzera iri kuvandudzwa nekuita shanduko kune yazvino PostgreSQL codebase uye vagadziri vacho vanoti mukana wekushandisa IvorySQL sekutsiva kwakajeka kweiyo yazvino vhezheni yePostgreSQL, mutsauko unobva pakuonekwa kwe "compatible_db" kuseta. , iyo inosanganisira kuenderana maitiro neOracle. Iyo kodhi yakanyorwa muC uye yakagoverwa pasi peiyo Apache 2.0 rezinesi.
IvorySQL inoshandisa PL/iSQL procedural language, iyo inotevera PL/SQL syntax, uye inotsigira Oracle-style mapakeji uye mashandiro epasuru akadai se "CREATE PACKAGE". IvorySQL inotsigirawo Oracle-specific syntax yekushanda, kutaura, uye ALTER TABLE, DELETE, UPDATE, CONNECT BY, GROUP BY, UNION, uye MINUS zvirevo, uye inopa Oracle-inoenderana seti yemabasa nemhando. Kutevedzera Oracle mabasa, mhando uye mapakeji, IvorySQL inoshandisa kodhi kubva kuOrafce PostgreSQL yekuwedzera.
Iyo itsva vhezheni yeIvorySQL inopa shanduko kuenda kuPostgreSQL 15.1 kodhi base uye inoshandisa tsigiro yepasi rose yakasarudzika indexes yakagadzirwa uchishandisa izwi rekuti "GADZIRA UNIQUE INDEX global_index ON idxpart(bid) GLOBAL". Ma indexes akadaro anogona kushandiswa kugadzira indekisi yakasarudzika patafura yakakamurwa inoramba yakasarudzika pamativi ese kana yasvikwa nekiyi isina-kupatsanurwa.
Source: opennet.ru