**Release Date: September 4, 2025** We're excited to announce the release of **SynchDB 1.2**! This update introduces a native Openlog Replicator connector for Oracle, comprehensive monitoring capabilities with JMX and Grafana integration, and streamlined deployment tools that make testing and setup significantly easier.
SynchDB continues to deliver seamless, native data synchronization from multiple database platforms directly to PostgreSQL without middleware, now with improved performance and enhanced operational visibility. **Major Enhancements** **Native Openlog Replicator Connector - BETA** * **Native Oracle streaming** - New connector type `olr` that communicates directly with Openlog Replicator services without Debezium dependency * Support for essential DMLs (insert, update, delete) and key DDLs including CREATE/DROP TABLE, ALTER TABLE operations, and TRUNCATE * Built on libprotobuf-c for efficient communication and IvorySQL's Oracle parser for DDL processing * Full snapshot mode support (initial, initial_only, no_data, always, never) with batching and offset management **Enhanced Monitoring & Observability** * JMX integration with `synchdb_add_jmx_conninfo` and `synchdb_del_jmx_conninfo` functions * Prometheus and Grafana support via JMX Exporter with dedicated connection management functions * Pre-built Grafana dashboard templates for MySQL, SQL Server, and Oracle connectors * Comprehensive metrics collection for production monitoring **Simplified Deployment & Testing** * **ezdeploy.sh tool** - One-command deployment script for rapid testing and development * Supports MySQL, SQL Server, Oracle (19c and 23ai), and Openlog Replicator 1.3.0 deployment * Automated Prometheus and Grafana setup with preloaded dashboards * Pre-compiled SynchDB v1.2 binaries for immediate testing **Performance & Reliability Improvements** * Selective snapshot table functionality - choose specific tables for initial snapshots in `always` mode * Enhanced event polling performance using direct buffers instead of frequent JNI calls * Improved connector isolation - each SynchDB extension now maintains separate connector data * Enhanced pytest framework with hammerdb-based TPC tests for Oracle **Changes from Previous Version** * New `snapshot table` parameter in `synchdb_add_conninfo` for granular snapshot control * Connector resume operations now default to `initial` snapshot mode for consistency * `synchdb_state_view` and `synchdb_stats_view` now show only current extension's connectors * Improved memory management and context handling **Fixed Issues** * Resolved crash in `spi_execute_select_one()` related to SPI memory context cleanup * Fixed compilation issues when PostgreSQL is built with cassert * Corrected shared memory conflicts between connectors with identical names across databases **Known Issues and Notes** * Native Openlog Replicator Connector currently streams all tables in the specified database * Table filtering must be configured in Openlog Replicator rather than SynchDB * JMX Exporter is required for Prometheus and Grafana monitoring functionality **Resources** * GitHub Repository: [GitHub](https://github.com/Hornetlabs/synchdb) * Documentation: [Document](https://docs.synchdb.com/) * Downloads: **[Release v1.2](https://github.com/Hornetlabs/synchdb/releases/tag/v1.2)** * Community Discussion: [Join us](https://discord.gg/ce4FGMfwrk) * Issue Reporting: **[GitHub Issues](https://github.com/Hornetlabs/synchdb/issues)** * Website: **[Hornetlabs Technology](https://hornetlabs.ca/)** **About SynchDB** SynchDB is an open-source PostgreSQL extension developed by Hornetlabs Technology. It enables direct data replication from heterogeneous databases (MySQL, MS SQL Server, Oracle, etc.) to PostgreSQL with high performance and reliability. The extension handles all synchronization needs without requiring middleware or third-party software. We appreciate your continued support and feedback as we work to make SynchDB the most powerful database synchronization tool available for PostgreSQL. Your testing, bug reports, and feature requests help drive our development priorities. Sincerely, The SynchDB Team at Hornetlabs Technology
