{"id":106140,"date":"2022-12-17T21:36:43","date_gmt":"2022-12-17T19:36:43","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-ivorysql-2-1-nadstrojki-nad-postgresql-dlya-obespecheniya-sovmestimosti-s-oracle"},"modified":"2022-12-17T21:36:43","modified_gmt":"2022-12-17T19:36:43","slug":"vypusk-ivorysql-2-1-nadstrojki-nad-postgresql-dlya-obespecheniya-sovmestimosti-s-oracle","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-ivorysql-2-1-nadstrojki-nad-postgresql-dlya-obespecheniya-sovmestimosti-s-oracle","title":{"rendered":"Vydanie IvorySQL 2.1, nadstavby nad PostgreSQL pre zabezpe\u010denie kompatibility s Oracle","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Bol vychovan\u00fd projekt IvorySQL 2.1, ktor\u00fd roz\u0161iruje ed\u00edciu DBMS PostgreSQL, poskytuj\u00faci vrstvu na zabezpe\u010denie kompatibility s aplik\u00e1ciami navrhnut\u00fdmi pre DBMS Oracle. Roz\u0161\u00edrenie sa vyv\u00edja prostredn\u00edctvom zmien v \u010derstvej k\u00f3dovej z\u00e1kladni PostgreSQL a v\u00fdvoj\u00e1ri tvrdia, \u017ee je mo\u017en\u00e9 pou\u017e\u00edva\u0165 IvorySQL ako transparentn\u00fa n\u00e1hradu najnov\u0161ej verzie PostgreSQL, ktorej rozdiel spo\u010d\u00edva v pridan\u00ed nastavenia \u201ecompatible_db\u201c, ktor\u00e1 zah\u0155\u0148a re\u017eim kompatibility s Oracle. K\u00f3d je nap\u00edsan\u00fd v jazyku C a distribuuje sa pod licenciou Apache 2.0. <\/p>\n

IvorySQL implementuje procedur\u00e1lny jazyk PL\/iSQL, ktor\u00fd imituje syntaktick\u00fd jazyk PL\/SQL, a podporuje bal\u00edky v \u0161t\u00fdle Oracle a oper\u00e1cie s bal\u00edkmi, ako s\u00fa \u201eCREATE PACKAGE\u201c. V IvorySQL je tie\u017e podporovan\u00e1 \u0161pecifick\u00e1 pre Oracle syntax oper\u00e1ci\u00ed, v\u00fdrazov a oper\u00e1torov ALTER TABLE, DELETE, UPDATE, CONNECT BY, GROUP BY, UNION a MINUS, s kompatibiln\u00fdm setom funkci\u00ed a typov Oracle. Na emul\u00e1ciu funkci\u00ed, typov a bal\u00edkov Oracle v IvorySQL je pou\u017eit\u00fd k\u00f3d roz\u0161\u00edrenia PostgreSQL Orafce. <\/p>\n

V novej verzii IvorySQL bol zabezpe\u010den\u00fd prechod na k\u00f3dov\u00fa z\u00e1klad\u0148u PostgreSQL 15.1 a bola implementovan\u00e1 podpora glob\u00e1lnych unik\u00e1tnych indexov, ktor\u00e9 sa vytv\u00e1raj\u00fa pomocou v\u00fdrazu \u201eCREATE UNIQUE INDEX global_index ON idxpart(bid) GLOBAL\u201c. Tak\u00e9to indexy m\u00f4\u017eu by\u0165 pou\u017eit\u00e9 na vytvorenie unik\u00e1tneho indexu pre rozdelen\u00fa tabu\u013eku, ktor\u00fd zachov\u00e1va jedine\u010dnos\u0165 pre v\u0161etky sekcie pri v\u00fdbere pod\u013ea k\u013e\u00fa\u010da, ktor\u00fd nie je viazan\u00fd na sekcie.
\n
Zdroj: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430 IvorySQL 2.1, \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0449\u0435\u0433\u043e \u0440\u0435\u0434\u0430\u043a\u0446\u0438\u044e \u0421\u0423\u0411\u0414 PostgreSQL, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0443\u044e \u0441\u043b\u043e\u0439 \u0434\u043b\u044f \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0435\u043d\u0438\u044f \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u0438 \u0441 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u043c\u0438, \u0440\u0430\u0441\u0441\u0447\u0438\u0442\u0430\u043d\u043d\u044b\u043c\u0438 \u043d\u0430 \u0440\u0430\u0431\u043e\u0442\u0443 \u0441 \u0421\u0423\u0411\u0414 Oracle. \u041d\u0430\u0434\u0441\u0442\u0440\u043e\u0439\u043a\u0430 \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u043f\u0443\u0442\u0451\u043c \u0432\u043d\u0435\u0441\u0435\u043d\u0438\u044f \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u0432 \u0441\u0432\u0435\u0436\u0443\u044e \u043a\u043e\u0434\u043e\u0432\u0443\u044e \u0431\u0430\u0437\u0443 PostgreSQL \u0438 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0438 \u0437\u0430\u044f\u0432\u043b\u044f\u044e\u0442 \u043e \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f IvorySQL \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u043f\u0440\u043e\u0437\u0440\u0430\u0447\u043d\u043e\u0439 \u0437\u0430\u043c\u0435\u043d\u044b \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0439 \u0432\u0435\u0440\u0441\u0438\u0438 PostgreSQL, \u043e\u0442\u043b\u0438\u0447\u0438\u0435 \u043e\u0442 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0441\u0432\u043e\u0434\u0438\u0442\u0441\u044f \u043a \u043f\u043e\u044f\u0432\u043b\u0435\u043d\u0438\u044e \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 «compatible_db», \u0432\u043a\u043b\u044e\u0447\u0430\u044e\u0449\u0435\u0439 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-106140","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Uvo\u013enenie IvorySQL 2.1, roz\u0161\u00edrenia nad PostgreSQL na zabezpe\u010denie kompatibility s Oracle | ProHoster","description":"Bol uvo\u013enen\u00fd projekt IvorySQL 2.1, ktor\u00fd rozv\u00edja ed\u00edciu datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL a poskytuje vrstvu na zabezpe\u010denie kompatibility s aplik\u00e1ciami navrhnut\u00fdmi pre pr\u00e1cu s datab\u00e1zov\u00fdm syst\u00e9mom Oracle.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-ivorysql-2-1-nadstrojki-nad-postgresql-dlya-obespecheniya-sovmestimosti-s-oracle","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0412\u044b\u043f\u0443\u0441\u043a IvorySQL 2.1, \u043d\u0430\u0434\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u043d\u0430\u0434 PostgreSQL \u0434\u043b\u044f \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0435\u043d\u0438\u044f \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u0438 \u0441 Oracle | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430 IvorySQL 2.1, \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0449\u0435\u0433\u043e \u0440\u0435\u0434\u0430\u043a\u0446\u0438\u044e \u0421\u0423\u0411\u0414 PostgreSQL, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0443\u044e \u0441\u043b\u043e\u0439 \u0434\u043b\u044f \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0435\u043d\u0438\u044f \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u0438 \u0441 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u043c\u0438, \u0440\u0430\u0441\u0441\u0447\u0438\u0442\u0430\u043d\u043d\u044b\u043c\u0438 \u043d\u0430 \u0440\u0430\u0431\u043e\u0442\u0443 \u0441 \u0421\u0423\u0411\u0414 Oracle.","og:url":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-ivorysql-2-1-nadstrojki-nad-postgresql-dlya-obespecheniya-sovmestimosti-s-oracle","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2022-12-17T19:36:43+00:00","article:modified_time":"2022-12-17T19:36:43+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/106140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=106140"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/106140\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=106140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=106140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=106140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}