{"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\/sq\/blog\/novosti-interneta\/vypusk-ivorysql-2-1-nadstrojki-nad-postgresql-dlya-obespecheniya-sovmestimosti-s-oracle","title":{"rendered":"L\u00ebshimi i IvorySQL 2.1, nj\u00eb shtes\u00eb mbi PostgreSQL p\u00ebr t\u00eb siguruar p\u00ebrputhshm\u00ebrin\u00eb me Oracle.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\u00cbshte publikuar versioni i projektit IvorySQL 2.1, i cili zhvillon nj\u00eb botim t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave PostgreSQL, duke ofruar nj\u00eb shtres\u00eb p\u00ebr t\u00eb siguruar kompaktibilitetin me aplikacionet e nd\u00ebrtuara p\u00ebr t\u00eb punuar me bazat e t\u00eb dh\u00ebnave Oracle. Shtesa zhvillohet duke b\u00ebr\u00eb ndryshime n\u00eb kodin e fundit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave PostgreSQL dhe zhvilluesit deklarojn\u00eb mund\u00ebsin\u00eb e p\u00ebrdorimit t\u00eb IvorySQL si nj\u00eb z\u00ebvend\u00ebsim transparent p\u00ebr versionin m\u00eb t\u00eb fundit t\u00eb PostgreSQL, me dallimin q\u00eb p\u00ebrfshin cil\u00ebsimin \"compatible_db\", i cili p\u00ebrfshin nj\u00eb modalitet t\u00eb kompaktibilitetit me Oracle. Kodi \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn C dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn Apache 2.0. <\/p>\n

IvorySQL implementon gjuh\u00ebn procedurale PL\/iSQL, e cila p\u00ebrs\u00ebrit sintaks\u00ebn PL\/SQL, dhe mb\u00ebshtet paketat n\u00eb stilin Oracle dhe operacionet me paketat, t\u00eb tilla si \"CREATE PACKAGE\". N\u00eb IvorySQL, gjithashtu mb\u00ebshtetet sintaksa specifike p\u00ebr Oracle p\u00ebr operacionet, shprehjet dhe operator\u00ebt ALTER TABLE, DELETE, UPDATE, CONNECT BY, GROUP BY, UNION dhe MINUS, duke ofruar nj\u00eb grup funksionesh dhe tipash t\u00eb kompaktibilitetit me Oracle. P\u00ebr t\u00eb imituar funksionet, tipat dhe paketat e Oracle n\u00eb IvorySQL, p\u00ebrdoret kodi i shtes\u00ebs PostgreSQL Orafce. <\/p>\n

N\u00eb versionin e ri t\u00eb IvorySQL \u00ebsht\u00eb siguruar kalimi n\u00eb kodin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave PostgreSQL 15.1 dhe \u00ebsht\u00eb realizuar mb\u00ebshtetje p\u00ebr indekset unike globale, t\u00eb krijuara p\u00ebrmes shprehjes \"CREATE UNIQUE INDEX global_index ON idxpart(bid) GLOBAL\". T\u00eb tilla indekse mund t\u00eb p\u00ebrdoren p\u00ebr t\u00eb krijuar nj\u00eb indeks unik p\u00ebr nj\u00eb tabel\u00eb t\u00eb ndar\u00eb (partitioned), i cili ruan unik\u00ebsin\u00eb p\u00ebr t\u00eb gjitha ndarjet kur b\u00ebhet seleksionim n\u00ebp\u00ebrmjet nj\u00eb \u00e7el\u00ebsi t\u00eb pa lidhur me ndarjet.
\n
Burimi: 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-novosti-interneta"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\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\n","aioseo_head_json":{"title":"\ud83e\udd47Lan\u00e7imi i IvorySQL 2.1, shtes\u00eb mbi PostgreSQL p\u00ebr t\u00eb garantuar p\u00ebrputhshm\u00ebrin\u00eb me Oracle | ProHoster","description":"Doli i projektit IvorySQL 2.1 \u00ebsht\u00eb publikim, q\u00eb zhvillon edicionin e DBMS PostgreSQL, duke ofruar nj\u00eb shtres\u00eb p\u00ebr garantimin e p\u00ebrputhshm\u00ebris\u00eb me aplikacione q\u00eb jan\u00eb planifikuar t\u00eb punojn\u00eb me DBMS Oracle. Shtesa zhvillohet p\u00ebrmes ndryshimeve n\u00eb kodin m\u00eb t\u00eb ri t\u00eb PostgreSQL dhe zhvilluesit deklarojn\u00eb se \u00ebsht\u00eb e mundur t\u00eb p\u00ebrdoret IvorySQL si nj\u00eb z\u00ebvend\u00ebsim transparent p\u00ebr versionin m\u00eb t\u00eb fundit t\u00eb PostgreSQL, dallimi i s\u00eb cil\u00ebs konsiston n\u00eb shfaqjen e cil\u00ebsimit \"compatible_db\", duke p\u00ebrfshir\u00eb","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-ivorysql-2-1-nadstrojki-nad-postgresql-dlya-obespecheniya-sovmestimosti-s-oracle","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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. \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","og:url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/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\/sq\/wp-json\/wp\/v2\/posts\/106140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=106140"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/106140\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=106140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=106140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=106140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}