SynchDB 1.3 Released - FDW-based Snapshot Engine with PostgreSQL 18 and IvorySQL 5 Support

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

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. ...

Get the full details here: PostgreSQL: SynchDB 1.3 Released - FDW-based Snapshot Engine with PostgreSQL 18 and IvorySQL 5 Support