{"repo":"Hornetlabs/synchdb","free":true,"listed":false,"github":"https://github.com/Hornetlabs/synchdb","clone":"git clone https://github.com/Hornetlabs/synchdb.git","description":"SynchDB is a PostgreSQL extension designed to replicate data from one or more heterogeneous databases (such as MySQL) directly to PostgreSQL in a fast and reliable way.","language":"C","stars":110,"topics":["databaes","postgresql","postgresql-extension","synchronization"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Introduction SynchDB is a PostgreSQL extension designed for fast and reliable data replication from multiple heterogeneous databases into PostgreSQL. It eliminates the need for middleware or third-party software, enabling direct synchronization without additional orchestration. SynchDB is a dual-language module, combining Java (for utilizing Debezium Embedded connectors) and C (for interacting with PostgreSQL core) components, and requires the Java Virtual Machine (JVM) and Java Native Interface (JNI) to operate together. Supported PostgreSQL Versions PostgreSQL: 16, 17, 18 IvorySQL: 3, 4, 5 Supported Source Databases MySQL: 8.0.x, 8.2 SQL Server: 2017, 2019, 2022 Oracle: 12c, 19c, 21c, 23ai Openlog Replicator: 1.3.0 1.8.5 Visit SynchDB documentation site here for more design details. Architecture SynchDB extension consists of these major components: Debezium Runner (Java) - Responsible for connecting to source databases and get change events. SynchDB Worker - Responsible for polling change events from Debezium Runner via JNI. Event Processor - Responsible for processing raw events into internal structures. Data Converter - Responsible for transforming data values. Replication Agent - Responsible for applying changes to PostgreSQL. Build Requirement The following software is required to build and run SynchDB. The versions listed are the versions tested during development. Older versions may still work. Unix based operating system like Ubuntu 22.04 or MacOS Java Development Ki","default_branch":null,"files":null,"tree":[],"storefront":"/r/Hornetlabs","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Hornetlabs/synchdb/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}