{"id":121167,"date":"2024-12-29T15:46:00","date_gmt":"2024-12-29T13:46:01","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/dostupny-ivorysql-4-0-i-synchdb-1-0-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd"},"modified":"2024-12-29T15:46:00","modified_gmt":"2024-12-29T13:46:01","slug":"dostupny-ivorysql-4-0-i-synchdb-1-0-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd","status":"publish","type":"post","link":"https:\/\/prohoster.info\/ro\/blog\/news\/dostupny-ivorysql-4-0-i-synchdb-1-0-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd","title":{"rendered":"Sunt disponibile IvorySQL 4.0 \u0219i SynchDB 1.0, extensii pentru PostgreSQL pentru interac\u021biunea cu alte SGBD-uri.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>A fost publicat\u0103 versiunea 4.0 a proiectului IvorySQL, care dezvolt\u0103 o variant\u0103 a SGBD-ului PostgreSQL, asigur\u00e2nd compatibilitate cu aplica\u021biile destinate SGBD-ului Oracle. \u00cen IvorySQL, se declar\u0103 posibilitatea de a func\u021biona ca o \u00eenlocuire transparen\u021b\u0103 a celei mai recente versiuni PostgreSQL, diferen\u021ba const\u00e2nd \u00een apari\u021bia unei configura\u021bii numite &#171;compatible_db&#187;, care include un mod de compatibilitate cu Oracle. Codul este scris \u00een limbajul C \u0219i este distribuit sub licen\u021ba Apache 2.0.    <\/p>\n<p>IvorySQL implementeaz\u0103 limbajul procedural PL\/iSQL, care repet\u0103 sintaxa PL\/SQL din Oracle, suport\u0103 pachete \u00een stil Oracle \u0219i opera\u021biuni cu pachete, precum &#171;CREATE PACKAGE&#187;. Se ofer\u0103 un set de func\u021bii \u0219i tipuri compatibile cu Oracle, iar sintaxa specific\u0103 pentru Oracle, opera\u021biuni, expresii \u0219i operatori, cum ar fi ALTER TABLE, DELETE, UPDATE, CONNECT BY (interog\u0103ri ierarhice), GROUP BY, UNION \u0219i MINUS este, de asemenea, suportat\u0103.      <\/p>\n<p>\u00cen noua versiune:  <\/p>\n<ul>\n<li class=\"l\"> A fost realizat tranzi\u021bia la codul de baz\u0103 PostgreSQL 17.\n<li class=\"l\"> A fost ad\u0103ugat suport pentru coloanele invizibile, care permit ascunderea anumitor coloane pentru a simplifica migrarea c\u0103tre noi aplica\u021bii (coloanele invizibile sunt vizibile doar la specificarea explicit\u0103 a numelui lor \u0219i nu apar \u00een interog\u0103rile generale de tip &#171;SELECT * FROM&#187;).\n<li class=\"l\"> Au fost ad\u0103ugate func\u021bionalit\u0103\u021bi pentru gestionarea pachetelor PL\/SQL, care permit crearea de pachete, modificarea parametrilor acestora \u0219i ata\u0219area unor descrieri. \u00cen psql, pentru opera\u021biile cu pachete, a fost ad\u0103ugat\u0103 o nou\u0103 comand\u0103 &#171;&#092;dk&#187;.\n<li class=\"l\"> A fost \u00eembun\u0103t\u0103\u021bit\u0103 performan\u021ba manipul\u0103rii pachetelor PL\/SQL \u0219i a fost ad\u0103ugat\u0103 suport pentru memorizarea \u00een cache a pachetelor.\n<li class=\"l\"> Au fost propuse noi func\u021bii ACL pentru gestionarea privilegiilor legate de pachetele PL\/SQL.\n<li class=\"l\"> A fost ad\u0103ugat\u0103 suportul pentru extensia pg_get_functiondef cu implementarea func\u021biilor pg_get_functiondef(), pg_get_functiondef(OID, VARIADIC OID[]) \u0219i pg_get_functiondef(VARIADIC TEXT[]), care permit ob\u021binerea defini\u021biilor func\u021biilor pe baza unei liste specificate de nume de func\u021bii.\n<li class=\"l\"> Au fost ad\u0103ugate pachete de instalare pentru Ubuntu.  <\/ul>\n<p>De asemenea, merit\u0103 men\u021bionat lansarea extensiei SynchDB 1.0, destinat\u0103 replic\u0103rii datelor din PostgreSQL dintr-o sau mai multe baze de date externe, cum ar fi MySQL, MS SQLServer \u0219i Oracle. Aceste baze de date externe servesc ca surse de date, care sunt transferate direct \u00eentr-o singur\u0103 baz\u0103 de date \u021bint\u0103 bazat\u0103 pe PostgreSQL, f\u0103r\u0103 a utiliza straturi suplimentare pentru orchestrarea procesului de sincronizare a datelor (toate opera\u021biunile de sincronizare sunt gestionate de extensia SynchDB). Codul proiectului este scris \u00een limbajele C \u0219i Java \u0219i este distribuit sub licen\u021ba Apache 2.0. SynchDB 1.0 este marcat ca prima versiune stabil\u0103 a proiectului.    <\/p>\n<p>Sistemul include \u0219ase componente:  <\/p>\n<ul>\n<li class=\"l\"> Debezium Runner Engine &#8212; un motor Java care ofer\u0103 module pentru procesarea fluxurilor de modific\u0103ri ale datelor din diverse SGBD-uri (MySQL, MS SQLServer \u0219i Oracle) \u0219i transcrierea datelor ob\u021binute \u00eentr-un format universal JSON.\n<li class=\"l\"> SynchDB Worker &#8212; lanseaz\u0103 instan\u021be ale Debezium Runner Engine pentru replicarea datelor din SGBD-uri specifice, prime\u0219te modific\u0103rile de la acestea \u00een format JSON \u0219i le transmite modulului Format Converter.\n<li class=\"l\"> SynchDB Launcher &#8212; creeaz\u0103 \u0219i finalizeaz\u0103 procesarea handler-elor SynchDB, utiliz\u00e2nd API-ul PostgreSQL pentru a lansa procese de fundal.\n<li class=\"l\"> Format Converter &#8212; analizeaz\u0103 fluxul de modific\u0103ri \u00een format JSON, transform\u00e2nd tipurile de date externe \u0219i interog\u0103rile DDL \u00een tipuri \u0219i interog\u0103ri compatibile cu PostgreSQL.\n<li class=\"l\"> Replication Agent &#8212; gestioneaz\u0103 ie\u0219irea \u00een format HeapTupleData din Format Converter \u0219i lanseaz\u0103 metodele pentru introducerea datelor \u00een PostgreSQL.\n<li class=\"l\"> Table Synch Agent (\u00een dezvoltare) &#8212; ofer\u0103 o metod\u0103 eficient\u0103 pentru sincronizarea ini\u021bial\u0103 a tablelor.  <\/ul>\n<p>      <center><img decoding=\"async\" alt=\"Sunt disponibile IvorySQL 4.0 \u0219i SynchDB 1.0, extensii pentru PostgreSQL pentru interac\u021biunea cu alte SGBD-uri.\" src=\"\/wp-content\/uploads\/2024\/12\/c8e38abad675ca21ad7d0ca36aa2ceea.png\" style=\"display:block;margin: 0 auto;\" \/><\/center><br \/>\n<br \/>Sursa: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=62483\">opennet.ro<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\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 4.0, \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, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044e\u0449\u0443\u044e \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c \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. \u0412 IvorySQL \u0437\u0430\u044f\u0432\u043b\u0435\u043d\u0430 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u044b \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 &#171;compatible_db&#187;, \u0432\u043a\u043b\u044e\u0447\u0430\u044e\u0449\u0435\u0439 \u0440\u0435\u0436\u0438\u043c \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u0438 \u0441 Oracle. \u041a\u043e\u0434 \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 \u0421\u0438 \u0438 \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u0434 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 Apache 2.0. [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":121168,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-121167","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\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 4.0, \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, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044e\u0449\u0443\u044e \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c \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.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/ro\/blog\/news\/dostupny-ivorysql-4-0-i-synchdb-1-0-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ro_RO\" \/>\n\t\t<meta property=\"og:site_name\" content=\"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\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u044b IvorySQL 4.0 \u0438 SynchDB 1.0, \u043d\u0430\u0434\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u043a PostgreSQL \u0434\u043b\u044f \u0432\u0437\u0430\u0438\u043c\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0441 \u0434\u0440\u0443\u0433\u0438\u043c\u0438 \u0421\u0423\u0411\u0414 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\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 4.0, \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, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044e\u0449\u0443\u044e \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c \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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/ro\/blog\/news\/dostupny-ivorysql-4-0-i-synchdb-1-0-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-12-29T13:46:01+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-12-29T13:46:01+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47 IvorySQL 4.0 \u0219i SynchDB 1.0 sunt disponibile, extensii pentru PostgreSQL pentru interac\u021biunea cu alte SGBD-uri | ProHoster","description":"A fost publicat\u0103 lansarea proiectului IvorySQL 4.0, care dezvolt\u0103 o edi\u021bie a SGBD-ului PostgreSQL, asigur\u00e2nd compatibilitatea cu aplica\u021biile destinate utiliz\u0103rii cu SGBD-ul Oracle.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/news\/dostupny-ivorysql-4-0-i-synchdb-1-0-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","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\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u044b IvorySQL 4.0 \u0438 SynchDB 1.0, \u043d\u0430\u0434\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u043a PostgreSQL \u0434\u043b\u044f \u0432\u0437\u0430\u0438\u043c\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0441 \u0434\u0440\u0443\u0433\u0438\u043c\u0438 \u0421\u0423\u0411\u0414 | 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 4.0, \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, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044e\u0449\u0443\u044e \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c \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\/ro\/blog\/news\/dostupny-ivorysql-4-0-i-synchdb-1-0-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd","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":"2024-12-29T13:46:01+00:00","article:modified_time":"2024-12-29T13:46:01+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"121167","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-23 09:15:22","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 09:15:22","updated":"2026-01-23 09:15:22","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/121167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=121167"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/121167\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media\/121168"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=121167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=121167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=121167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}