{"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\/cs\/blog\/news\/vypusk-ivorysql-2-1-nadstrojki-nad-postgresql-dlya-obespecheniya-sovmestimosti-s-oracle","title":{"rendered":"Vyd\u00e1n\u00ed IvorySQL 2.1, nadstavby nad PostgreSQL pro zaji\u0161t\u011bn\u00ed kompatibility s Oracle","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Byl zve\u0159ejn\u011bn v\u00fdstup projektu IvorySQL 2.1, kter\u00fd vyv\u00edj\u00ed edici SGBD PostgreSQL, poskytuj\u00edc\u00ed vrstvu pro zaji\u0161t\u011bn\u00ed kompatibility s aplikacemi navr\u017een\u00fdmi pro SGBD Oracle. Roz\u0161\u00ed\u0159en\u00ed se vyv\u00edj\u00ed prost\u0159ednictv\u00edm \u00faprav \u010derstv\u00e9 k\u00f3dov\u00e9 z\u00e1kladny PostgreSQL a v\u00fdvoj\u00e1\u0159i tvrd\u00ed, \u017ee IvorySQL lze pou\u017e\u00edt jako transparentn\u00ed n\u00e1hradu posledn\u00ed verze PostgreSQL, jej\u00ed\u017e rozd\u00edl spo\u010d\u00edv\u00e1 v zaveden\u00ed nastaven\u00ed «compatible_db», zahrnuj\u00edc\u00edho re\u017eim kompatibility s Oracle. K\u00f3d je naps\u00e1n v jazyce C a \u0161\u00ed\u0159\u00ed se pod licenc\u00ed Apache 2.0. <\/p>\n

IvorySQL implementuje procedur\u00e1ln\u00ed jazyk PL\/iSQL, kter\u00fd se odr\u00e1\u017e\u00ed v syntaxi PL\/SQL, a podporuje bal\u00ed\u010dky ve stylu Oracle a operace s bal\u00ed\u010dky, jako je «CREATE PACKAGE». V IvorySQL je tak\u00e9 podporov\u00e1na specifick\u00e1 syntaxe Oracle pro operace, v\u00fdrazy a oper\u00e1tory ALTER TABLE, DELETE, UPDATE, CONNECT BY, GROUP BY, UNION a MINUS, poskytuje kompatibiln\u00ed sadu funkc\u00ed a typ\u016f s Oracle. K emulaci funkc\u00ed, typ\u016f a bal\u00ed\u010dk\u016f Oracle v IvorySQL je vyu\u017eit k\u00f3d PostgreSQL-dopl\u0148ku Orafce. <\/p>\n

V nov\u00e9 verzi IvorySQL do\u0161lo k p\u0159echodu na k\u00f3dovou z\u00e1kladnu PostgreSQL 15.1 a byla implementov\u00e1na podpora glob\u00e1ln\u00edch unik\u00e1tn\u00edch index\u016f, vytv\u00e1\u0159en\u00fdch pomoc\u00ed v\u00fdrazu «CREATE UNIQUE INDEX global_index ON idxpart(bid) GLOBAL». Takov\u00e9 indexy mohou b\u00fdt pou\u017eity pro vytv\u00e1\u0159en\u00ed unik\u00e1tn\u00edho indexu pro partitioned tabulku, kter\u00e1 zaji\u0161\u0165uje jedine\u010dnost pro v\u0161echny sekce p\u0159i v\u00fdb\u011bru podle kl\u00ed\u010de, kter\u00fd nen\u00ed v\u00e1z\u00e1n na sekce.
\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\udd47Vyd\u00e1n\u00ed IvorySQL 2.1, roz\u0161\u00ed\u0159en\u00ed nad PostgreSQL pro zaji\u0161t\u011bn\u00ed kompatibility s Oracle | ProHoster","description":"Bylo vyd\u00e1no vyd\u00e1n\u00ed projektu IvorySQL 2.1, kter\u00e9 vyv\u00edj\u00ed edici datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL, poskytuj\u00edc\u00ed vrstvu pro zaji\u0161t\u011bn\u00ed kompatibility s aplikacemi ur\u010den\u00fdmi pro pou\u017e\u00edv\u00e1n\u00ed datab\u00e1z\u00ed Oracle.","canonical_url":"https:\/\/prohoster.info\/cs\/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":"cs_CZ","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\/cs\/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\/cs\/wp-json\/wp\/v2\/posts\/106140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=106140"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/106140\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=106140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=106140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=106140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}