Qhov kev tso tawm ntawm IvorySQL 2.1 qhov project tau luam tawm, tsim cov ntawv tshaj tawm ntawm PostgreSQL DBMS, uas muab cov txheej txheem kom ntseeg tau tias muaj kev sib raug zoo nrog cov ntawv thov tsim los ua haujlwm nrog Oracle DBMS. Cov add-on tau tsim los ntawm kev hloov pauv mus rau PostgreSQL codebase qhov tseeb thiab cov neeg tsim khoom thov qhov muaj peev xwm ntawm kev siv IvorySQL raws li kev hloov pob tshab rau qhov tseeb version ntawm PostgreSQL, qhov sib txawv los ntawm qhov tshwm sim ntawm "compatible_db" chaw. , uas suav nrog hom kev sib raug zoo nrog Oracle. Cov cai sau rau hauv C thiab muab faib raws li Apache 2.0 daim ntawv tso cai.
IvorySQL siv PL / iSQL cov txheej txheem lus, uas ua raws li PL / SQL syntax, thiab txhawb nqa Oracle-style pob thiab kev ua haujlwm pob xws li "CREATE PACKAGE". IvorySQL tseem txhawb nqa Oracle cov lus qhia tshwj xeeb rau kev ua haujlwm, cov lus qhia, thiab ALTER TABLE, DELETE, Hloov Kho, Txuas Los ntawm, PIB BY, UNION, thiab MINUS nqe lus, thiab muab cov Oracle-tshaj cov haujlwm thiab hom. Txhawm rau ua raws li Oracle kev ua haujlwm, hom thiab pob khoom, IvorySQL siv cov cai los ntawm Orafce PostgreSQL ntxiv-rau.
Tus tshiab version ntawm IvorySQL muab kev hloov pauv mus rau PostgreSQL 15.1 code puag thiab siv kev txhawb nqa rau lub ntiaj teb tshwj xeeb indexes tsim siv cov lus qhia "CREATE UNIQUE INDEX global_index ON idxpart(bid) GLOBAL". Cov kev ntsuas zoo li no tuaj yeem siv los tsim ib qho kev ntsuas tshwj xeeb ntawm lub rooj sib faib uas tseem muaj qhov tshwj xeeb thoob plaws txhua qhov kev faib tawm thaum nkag los ntawm tus yuam sij tsis sib faib.
Tau qhov twg los: opennet.ru