{"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\/hu\/blog\/news\/vypusk-ivorysql-2-1-nadstrojki-nad-postgresql-dlya-obespecheniya-sovmestimosti-s-oracle","title":{"rendered":"Megjelent az IvorySQL 2.1, a PostgreSQL-hez k\u00e9sz\u00fclt b\u0151v\u00edtm\u00e9ny, amely biztos\u00edtja az Oracle-lel val\u00f3 kompatibilit\u00e1st.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Megjelent az IvorySQL 2.1-es kiad\u00e1sa, amely a PostgreSQL adatb\u00e1zis-kezel\u0151 rendszert fejleszti, biztos\u00edtva a Oracle adatb\u00e1zisra tervezett alkalmaz\u00e1sokkal val\u00f3 kompatibilit\u00e1st. A kieg\u00e9sz\u00edt\u00e9s a PostgreSQL \u00faj k\u00f3dalapj\u00e1nak m\u00f3dos\u00edt\u00e1s\u00e1val fejl\u0151dik, \u00e9s a fejleszt\u0151k azt \u00e1ll\u00edtj\u00e1k, hogy az IvorySQL \u00e1tl\u00e1that\u00f3 alternat\u00edvak\u00e9nt haszn\u00e1lhat\u00f3 az utols\u00f3 PostgreSQL verzi\u00f3val szemben, amelynek k\u00fcl\u00f6nbs\u00e9ge az «compatible_db» be\u00e1ll\u00edt\u00e1s megjelen\u00e9s\u00e9re korl\u00e1toz\u00f3dik, amely t\u00e1mogatja az Oracle kompatibilit\u00e1si m\u00f3dot. A k\u00f3d C nyelven k\u00e9sz\u00fclt \u00e9s az Apache 2.0 alatt terjed. <\/p>\n

Az IvorySQL megval\u00f3s\u00edtja a PL\/iSQL elj\u00e1r\u00e1si nyelvet, amely a PL\/SQL szintaxis\u00e1t k\u00f6veti, \u00e9s t\u00e1mogatja az Oracle-st\u00edlus\u00fa csomagokat \u00e9s a csomagokkal kapcsolatos m\u0171veleteket, mint p\u00e9ld\u00e1ul a «CREATE PACKAGE». Az IvorySQL-ban az Oracle-specifikus m\u0171veletek, kifejez\u00e9sek \u00e9s ALTER TABLE, DELETE, UPDATE, CONNECT BY, GROUP BY, UNION \u00e9s MINUS oper\u00e1torok szintaxisa is t\u00e1mogatott, valamint kompatibilis Oracle funkci\u00f3k \u00e9s t\u00edpusok \u00e9rhet\u0151k el. Az Oracle funkci\u00f3k, t\u00edpusok \u00e9s csomagok emul\u00e1l\u00e1s\u00e1hoz az IvorySQL a PostgreSQL Orafce kieg\u00e9sz\u00edt\u0151 k\u00f3dj\u00e1t haszn\u00e1lja. <\/p>\n

Az \u00faj IvorySQL verzi\u00f3 a PostgreSQL 15.1 k\u00f3dalapj\u00e1ra val\u00f3 \u00e1t\u00e1ll\u00e1st biztos\u00edtja, \u00e9s t\u00e1mogatja a glob\u00e1lis egyedi indexek l\u00e9trehoz\u00e1s\u00e1t a «CREATE UNIQUE INDEX global_index ON idxpart(bid) GLOBAL» kifejez\u00e9s seg\u00edts\u00e9g\u00e9vel. Az ilyen indexek felhaszn\u00e1lhat\u00f3k egy szegment\u00e1lt t\u00e1bl\u00e1zat egyedi index\u00e9nek l\u00e9trehoz\u00e1s\u00e1ra, amely meg\u0151rzi az egyedis\u00e9get minden szegmens eset\u00e9ben, ha egy nem szegmensekhez k\u00f6t\u00f6tt kulcs alapj\u00e1n k\u00e9rdezik le.
\n
Forr\u00e1s: 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\udd47IvorySQL 2.1 kiad\u00e1s, a PostgreSQL-re \u00e9p\u00fcl\u0151 b\u0151v\u00edtm\u00e9ny Oracle-kompatibilit\u00e1ssal | ProHoster","description":"Megjelent az IvorySQL 2.1-es verzi\u00f3ja, amely a PostgreSQL adatb\u00e1zis-kezel\u0151 rendszer szerkeszt\u00e9s\u00e9t fejleszti, \u00e9s egy r\u00e9teget biztos\u00edt az Oracle adatb\u00e1zissal k\u00e9sz\u00fclt alkalmaz\u00e1sok kompatibilit\u00e1s\u00e1hoz.","canonical_url":"https:\/\/prohoster.info\/hu\/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":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/106140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=106140"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/106140\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=106140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=106140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=106140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}