Dear Community Members,
We are excited to announce the release of SynchDB 1.3, delivering a major performance enhancement with the new FDW-based snapshot engine and expanded platform support for PostgreSQL 18 and IvorySQL 5.
What's New in SynchDB 1.3:
FDW-based Snapshot Engine: A much faster alternative to Debezium's initial snapshot process, making OpenLog Replicator (OLR) connector a fully native snapshot + CDC pipeline with significantly reduced latency and overhead for large Oracle datasets. Applicable to OpenLog Replicator and Oracle connector types via oracle_fdw.
Revamped Statistics Views: New categorized views for better observability — synchdb_genstats for batch event processing, synchdb_snapstats for initial snapshot, and synchdb_cdcstats for CDC process monitoring.
PostgreSQL 18 and IvorySQL 5 Compatibility: Full support for the latest PostgreSQL and IvorySQL releases with proper handling of IvorySQL's Oracle compatible mode during snapshot operations.
OpenLog Replicator Enhancements: Enhanced Oracle parser supporting more constraint operators, MODIFY clauses, and DEFAULT ON NULL. Improved processing performance, optimized buffer handling, and configurable timeout parameters.
Bug Fixes: Resolved issues with Oracle parser on PostgreSQL 16, negative decimal processing, large decimal overflow values, and source table names containing spaces.
For a detailed list of all changes, please visit our release notes at https://github.com/Hornetlabs/synchdb/releases/tag/v1.3
Acknowledgments and Contributions:
Thank you to all our users who contributed patches, reported bugs, and proposed new features.
SynchDB thrives on community contributions. We warmly welcome your ideas, feature requests, or patches. Please share your contributions on our GitHub page.
Source Code:
Useful Links:
We look forward to your feedback on SynchDB 1.3 and your continued support in making SynchDB even better.
Best regards,
SynchDB Dev Team
About SynchDB
SynchDB is a PostgreSQL extension that enables real-time data synchronization from heterogeneous databases including Oracle, MySQL, and SQL Server into PostgreSQL and IvorySQL. It provides both initial snapshot and CDC (Change Data Capture) capabilities, making it an efficient solution for database migration and real-time data integration.