{"id":149793,"date":"2025-11-27T17:11:54","date_gmt":"2025-11-27T15:11:55","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/dostupny-ivorysql-5-0-i-synchdb-1-3-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd"},"modified":"2025-11-27T17:11:54","modified_gmt":"2025-11-27T15:11:55","slug":"dostupny-ivorysql-5-0-i-synchdb-1-3-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd","status":"publish","type":"post","link":"https:\/\/prohoster.info\/en\/blog\/news\/dostupny-ivorysql-5-0-i-synchdb-1-3-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd","title":{"rendered":"IvorySQL 5.0 and SynchDB 1.3, extensions to PostgreSQL for interacting with other DBMSs, are now available","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
The release of IvorySQL 5.0 has been published, which develops a PostgreSQL database management system edition that ensures compatibility with applications designed to work with Oracle databases. IvorySQL claims the ability to function as a transparent replacement for the latest version of PostgreSQL, differing primarily by the introduction of the 'compatible_db' setting, which includes a mode for Oracle compatibility. The code is written in C and is distributed under the Apache 2.0 license. <\/p>\n
IvorySQL implements the procedural language PL\/iSQL, mirroring the syntax of PL\/SQL in Oracle, supports Oracle-style packages and operations with packages such as 'CREATE PACKAGE'. It offers an Oracle-compatible set of functions and types, as well as supports Oracle-specific syntax for operations, expressions, and operators like ALTER TABLE, DELETE, UPDATE, CONNECT BY (hierarchical queries), GROUP BY, UNION, and MINUS. <\/p>\n
In the new version: <\/p>\n
\n
Migration to the PostgreSQL 18 codebase has been completed.\n
Compatibility with Oracle databases has been improved: support for nested subprograms, ROWID, NLS and OUT parameters, translation of empty strings to NULL, session-bound parser changes, GB18030 encoding, and functions SYS_GUID, SYS_CONTEXT, and USERENV has been implemented.\n
Oracle-compatible operators INSTR, FORCE VIEW, and LIKE have been added.\n
PL\/iSQL capabilities have been expanded: support for CALL syntax, %ROWTYPE, and %TYPE has been added.\n
Full support for Docker Compose, Docker Swarm, and Kubernetes has been implemented, along with a package manager Helm. IvorySQL Operator 5.0 and IvorySQL Cloud 5.0 include tools for visual lifecycle management.\n
Support for ten extensions to PostgreSQL has been provided: pg_cron, pgAudit, PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, system_stats, plpgsql_check, and pgvector.\n
Installation packages have been formed for X86_64, ARM64, MIPS, and LoongArch architectures.\n
An online environment has been prepared for working with IvorySQL from a browser, allowing users to operate without installing IvorySQL on their systems. <\/ul>\n
Additionally, the release of the SynchDB 1.3 extension can be noted, designed for replicating data from one or more external databases, such as MySQL, MS SQL Server, and Oracle, into PostgreSQL. Such external databases serve as data sources that are directly transferred into a single target database based on PostgreSQL, without the use of additional layers for orchestrating the data synchronization process (all synchronization operations are handled by the SynchDB extension). The project code is written in C and Java and is distributed under the Apache 2.0 license. <\/p>\n
The system includes the following components: <\/p>\n
\n
Debezium Runner Engine \u2014 a Java-based engine that provides modules for processing change data streams from various database management systems (MySQL, MS SQLServer, and Oracle) and translating the obtained data into a universal JSON format. <\/li>\n
SynchDB Worker \u2014 launches instances of Debezium Runner Engine for replicating data from specific database systems, receives changes from them in JSON format, and forwards them to the Format Converter module. <\/li>\n
SynchDB Launcher \u2014 creates and terminates SynchDB handlers using the PostgreSQL API to initiate background processes. <\/li>\n
Format Converter \u2014 parses the change stream in JSON format, converts external data types and DDL statements into types and statements compatible with PostgreSQL. <\/li>\n
Replication Agent \u2014 processes the output in HeapTupleData format from Format Converter and invokes methods to insert data into PostgreSQL. <\/li>\n<\/ul>\n
<\/center> <\/p>\n
In SynchDB 1.3, a new snapshot generation engine based on FDW (Foreign Data Wrapper) has been implemented, supporting operation with OpenLog Replicator. Compared to the old engine based on Debezium, the new engine significantly increases performance and reduces latency when replicating data from large Oracle databases. Additionally, the new version offers extra views with statistics (synchdb_genstats, synchdb_snapstats, and synchdb_cdcstat), supports MODIFY and DEFAULT ON NULL expressions in OpenLog Replicator, and includes compatibility with PostgreSQL 18 and IvorySQL 5. \n Source: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"
![\"IvorySQL](\"\/wp-content\/uploads\/2025\/11\/a85fea82eb0aef9d31fc1468de846f8c.jpg\")
<\/center> <\/p>\n