{"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\/sv\/blog\/news\/dostupny-ivorysql-4-0-i-synchdb-1-0-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd","title":{"rendered":"IvorySQL 4.0 och SynchDB 1.0 \u00e4r tillg\u00e4ngliga, till\u00e4gg till PostgreSQL f\u00f6r interaktion med andra databashanterare","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Utgivningen av IvorySQL 4.0 har publicerats, vilket \u00e4r en utveckling av databashanteraren PostgreSQL, som erbjuder kompatibilitet med applikationer designade f\u00f6r att fungera med databashanteraren Oracle. IvorySQL erbjuder m\u00f6jligheten att fungera som en transparent ers\u00e4ttning f\u00f6r den senaste versionen av PostgreSQL, d\u00e4r skillnaden ligger i inst\u00e4llningen &#171;compatible_db&#187;, som inkluderar kompatibilitetsl\u00e4ge med Oracle. Koden \u00e4r skriven i C och distribueras under Apache 2.0-licensen.    <\/p>\n<p>IvorySQL implementerar procedurspr\u00e5ket PL\/iSQL, som efterliknar syntaksen f\u00f6r PL\/SQL i Oracle, st\u00f6der paket i Oracle-stil och operationer med paket, s\u00e5dana som \"CREATE PACKAGE\". Ett kompatibelt upps\u00e4ttning funktioner och typer tillhandah\u00e5lls, och dessutom st\u00f6ds den Oracle-specifika syntaksen f\u00f6r operationer, uttryck och operatorer s\u00e5som ALTER TABLE, DELETE, UPDATE, CONNECT BY (hierarkiska fr\u00e5gor), GROUP BY, UNION och MINUS.      <\/p>\n<p>I den nya versionen:  <\/p>\n<ul>\n<li class=\"l\"> \u00d6verg\u00e5ng till kodbasen PostgreSQL 17 har genomf\u00f6rts.\n<li class=\"l\"> St\u00f6det f\u00f6r osynliga kolumner har lagts till, vilket g\u00f6r det m\u00f6jligt att d\u00f6lja specifika kolumner f\u00f6r att f\u00f6renkla migreringen till nya applikationer (osynliga kolumner visas endast n\u00e4r deras namn anges uttryckligen och visas inte i allm\u00e4nna fr\u00e5gor av typen &#171;SELECT * FROM&#187;).\n<li class=\"l\"> M\u00f6jligheterna f\u00f6r hantering av PL\/SQL-paket har lagts till, vilket g\u00f6r det m\u00f6jligt att skapa paket, \u00e4ndra deras parametrar och bifoga beskrivningar. I psql har en ny kommando &#171;&#092;dk&#187; lagts till f\u00f6r operationer med paket.\n<li class=\"l\"> Prestandan vid arbete med PL\/SQL-paket har \u00f6kat och st\u00f6d f\u00f6r paketcaching har lagts till.\n<li class=\"l\"> Nya ACL-funktioner har f\u00f6reslagits f\u00f6r att hantera privilegier kopplade till PL\/SQL-paket.\n<li class=\"l\"> St\u00f6d f\u00f6r till\u00e4gget pg_get_functiondef har lagts till, med implementation av funktionerna pg_get_functiondef(), pg_get_functiondef(OID, VARIADIC OID[]) och pg_get_functiondef(VARIADIC TEXT[]), vilket m\u00f6jligg\u00f6r h\u00e4mtning av funktionsdefinitioner baserat p\u00e5 en angiven lista med funktionsnamn.\n<li class=\"l\"> Installationspaket f\u00f6r Ubuntu har lagts till.  <\/ul>\n<p>Det b\u00f6r ocks\u00e5 noteras att versionen av till\u00e4gget SynchDB 1.0 har sl\u00e4ppts, som \u00e4r avsett f\u00f6r replikering av data fr\u00e5n en eller flera externa databashanterare, som MySQL, MS SQLServer och Oracle, till PostgreSQL. Dessa externa databashanterare fungerar som datak\u00e4llor som direkt \u00f6verf\u00f6rs till en m\u00e5ldatabas baserad p\u00e5 PostgreSQL, utan att anv\u00e4nda ytterligare lager f\u00f6r orkestrering av datasykroniseringsprocessen (alla synkroniseringsoperationer hanteras av till\u00e4gget SynchDB). Projektets kod \u00e4r skriven i C och Java och distribueras under Apache 2.0-licensen. SynchDB 1.0 markerades som den f\u00f6rsta stabila versionen av projektet.    <\/p>\n<p>Systemet inkluderar sex komponenter:  <\/p>\n<ul>\n<li class=\"l\"> Debezium Runner Engine \u2013 en Java-motor som tillhandah\u00e5ller moduler f\u00f6r behandling av \u00e4ndringsdatafl\u00f6den fr\u00e5n olika databashanteringssystem (MySQL, MS SQLServer och Oracle) och \u00f6vers\u00e4tter de erh\u00e5llna data till ett universellt JSON-format.\n<li class=\"l\"> SynchDB Worker \u2013 startar instanser av Debezium Runner Engine f\u00f6r att replikera data fr\u00e5n specifika databashanteringssystem, tar emot \u00e4ndringar fr\u00e5n dem i JSON-format och vidarebefordrar dem till modul Format Converter.\n<li class=\"l\"> SynchDB Launcher \u2013 skapar och avslutar arbetsfl\u00f6den f\u00f6r SynchDB genom att anv\u00e4nda PostgreSQL API f\u00f6r att starta bakgrundsprocesser.\n<li class=\"l\"> Format Converter \u2013 analyserar fl\u00f6det av \u00e4ndringar i JSON-format, konverterar externa datatyper och DDL-fr\u00e5gor till typer och fr\u00e5gor som \u00e4r kompatibla med PostgreSQL.\n<li class=\"l\"> Replication Agent \u2013 hanterar utdata i HeapTupleData-format fr\u00e5n Format Converter och initierar metoder f\u00f6r att s\u00e4tta in data i PostgreSQL.\n<li class=\"l\"> Table Synch Agent (under utveckling) &#8212; tillhandah\u00e5ller en effektiv metod f\u00f6r initial synkronisering av tabeller.  <\/ul>\n<p>      <center><img decoding=\"async\" alt=\"IvorySQL 4.0 och SynchDB 1.0 \u00e4r tillg\u00e4ngliga, till\u00e4gg till PostgreSQL f\u00f6r interaktion med andra databashanterare\" src=\"\/wp-content\/uploads\/2024\/12\/c8e38abad675ca21ad7d0ca36aa2ceea.png\" style=\"display:block;margin: 0 auto;\" \/><\/center><br \/>\n<br \/>K\u00e4lla: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=62483\">opennet.ru<\/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.4 - 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\/sv\/blog\/news\/dostupny-ivorysql-4-0-i-synchdb-1-0-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sv_SE\" \/>\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\/sv\/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\udd47IvorySQL 4.0 och SynchDB 1.0 \u00e4r tillg\u00e4ngliga, till\u00e4gg till PostgreSQL f\u00f6r interaktion med andra databashanteringssystem | ProHoster","description":"Utgivningen av projektet IvorySQL 4.0 har publicerats, som utvecklar en version av databashanteraren PostgreSQL och s\u00e4kerst\u00e4ller kompatibilitet med applikationer avsedda f\u00f6r databashanteraren Oracle.","canonical_url":"https:\/\/prohoster.info\/sv\/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":"sv_SE","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\/sv\/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\/sv\/wp-json\/wp\/v2\/posts\/121167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/comments?post=121167"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/121167\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media\/121168"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media?parent=121167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/categories?post=121167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/tags?post=121167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}