Ho lokolloa ha morero oa IvorySQL 5.0 ho hatisitsoe, ho hlahisa khatiso ea PostgreSQL DBMS e fanang ka ho lumellana le likopo tse etselitsoeng ho sebetsa le Oracle DBMS. IvorySQL e bolela hore e khona ho sebetsa e le phetisetso e hlakileng bakeng sa phetolelo ea morao-rao ea PostgreSQL, phapang ho tloha ho ea ho ponahalo ea "compatible_db" setting, e kenyeletsang mokhoa oa ho lumellana le Oracle. Khoutu e ngotsoe ka C mme e ajoa tlasa laesense ea Apache 2.0.
IvorySQL e sebelisa puo ea ts'ebetso ea PL/iSQL, e phetang syntax ea Oracle's PL/SQL, mme e ts'ehetsa liphutheloana tsa mofuta oa Oracle le ts'ebetso ea liphutheloana joalo ka "CREATE PACKAGE". E fana ka mesebetsi le mefuta e lumellanang le Oracle, 'me e tšehetsa syntax e khethehileng ea Oracle bakeng sa ts'ebetso, lipolelo, le lipolelo tse kang ALTER TABLE, DELETE, UPDATE, CONNECT BY (lipotso tsa hierarchical), GROUP BY, UNION, le MINUS.
Khatisong e ncha:
- Phetoho ea PostgreSQL 18 codebase e phethiloe.
- Tšebelisano e ntlafalitsoeng le Oracle DBMS: ts'ehetso bakeng sa mekhoa e hlophisitsoeng, ROWID, NLS le OUT parameters, phetolelo ea likhoele tse se nang letho ho NULL, ho fetola li-parser nakong e tlamang, GB18030 encoding, SYS_GUID, SYS_CONTEXT le mesebetsi ea USERENV.
- E kentse li-Oracle tse tsamaisanang le INSTR, FORCE VIEW, le li-operators tsa LIKE.
- Bokhoni ba PL/iSQL bo ekelitsoe: tšehetso bakeng sa syntax ea CALL, %ROWTYPE, le %TYPE e kentsoe.
- Ts'ehetso e felletseng bakeng sa Docker Compose, Docker Swarm, le Kubernetes e nang le molaoli oa sephutheloana sa Helm e kentsoe tšebetsong. Lisebelisoa tsa taolo ea bophelo bo botle li kenyellelitsoe ho IvorySQL Operator 5.0 le IvorySQL Cloud 5.0.
- Ts'ehetso bakeng sa likeketso tse leshome tsa PostgreSQL e fanoa: pg_cron, pgAudit, PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, system_stats, plpgsql_check le pgvector.
- Liphutheloana tsa ho kenya li entsoe bakeng sa meralo ea X86_64, ARM64, MIPS, le LoongArch.
- Tikoloho ea inthaneteng ea ho sebetsa le IvorySQL ho tsoa ho sebatli e lokisitsoe, e u lumellang ho etsa ntle le ho kenya IvorySQL ho sistimi ea hau.
Ho hlokomelehang hape ke ho lokolloa ha SynchDB 1.3, plugin e etselitsoeng ho pheta-pheta data ho tsoa ho DBMS e le 'ngoe kapa ho feta ea motho oa boraro, joalo ka MySQL, MS SQL Server, le Oracle, ho PostgreSQL. Li-DBMS tsena tsa kantle li sebetsa joalo ka mehloli ea data, e fetisetsoang ka kotloloho ho database e le 'ngoe ea PostgreSQL, ntle le tlhokahalo ea likarolo tse eketsehileng ho hlophisa ts'ebetso ea khokahano ea data (ts'ebetso eohle ea ho hokahanya e sebetsoa ke plugin ea SynchDB). Khoutu ea morero e ngotsoe ka C le Java mme e ajoa tlasa laesense ea Apache 2.0.
Sistimi e kenyelletsa likarolo tse latelang:
- Debezium Runner Engine ke enjene ea Java e fanang ka li-modules bakeng sa ho sebetsana le melapo ea liphetoho tsa data ho tsoa ho li-DBMS tse fapaneng (MySQL, MS SQLServer le Oracle) le ho fetolela data e amohetsoeng ka sebopeho sa JSON sa bokahohleng.
- SynchDB Worker - e qala maemo a Debezium Runner Engine ho pheta lintlha ho tsoa ho li-DBMS tse itseng, e amohela liphetoho ho tsona ka sebopeho sa JSON ebe e li fetisetsa mojuleng oa Format Converter.
- SynchDB Launcher - E theha le ho emisa libatli tsa SynchDB e sebelisa PostgreSQL API ho qala lits'ebetso tsa morao-rao.
- Format Converter - Parses e fetola molapo ka sebopeho sa JSON, e fetolela mefuta ea data ea motho oa boraro le lipotso tsa DDL hore e be mefuta le lipotso tse tsamaellanang tsa PostgreSQL.
- Replication Agent - E sebetsana le tlhahiso ea HeapTupleData ho tsoa ho Format Converter mme e sebelisa mekhoa ea ho kenya data sebakeng sa PostgreSQL.
SynchDB 1.3 e hlahisa enjine e ncha ea snapshot e thehiloeng ho FDW (Foreign Data Wrapper) mme e ts'ehetsa OpenLog Replicator. Ha e bapisoa le enjene e fetileng e thehiloeng ho Debezium, enjene e ncha e ntlafatsa haholo ts'ebetso mme e fokotsa latency ha e pheta lintlha ho tsoa ho database tse kholo tsa Oracle. Ho feta moo, mofuta o mocha o fana ka maikutlo a eketsehileng a lipalo-palo (synchdb_genstats, synchdb_snapstats, le synchdb_cdcstat), OpenLog Replicator e se e ts'ehetsa lipolelo tsa MODIFY le DEFAULT ON NULL, 'me e tšehetsa PostgreSQL 18 le IvorySQL 5.
Source: opennet.ru
