Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vOVsM-00AnAn-2R for pgsql-announce@arkaria.postgresql.org; Thu, 27 Nov 2025 06:53:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vOVsK-003zHi-2u for pgsql-announce@arkaria.postgresql.org; Thu, 27 Nov 2025 06:53:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vOVsJ-003zGo-2l for pgsql-announce@lists.postgresql.org; Thu, 27 Nov 2025 06:53:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vOVsG-001hVf-1Z for pgsql-announce@lists.postgresql.org; Thu, 27 Nov 2025 06:53:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=kFChKelQPlyQUoKNNR8MpWaxB4f95AyClAm9n2ECvQs=; b=Rt7gKPeLiFDswlM5UDOMldAATC RwWN66Zw8RJoxCC58sSuXSuyLa9MXZ1Se8yrSxMg2zoAULK7sTS5ajEennXXd+9he3WYnyoO/PTuT qahtOEu7tNpxIGLD+7Tew4C4Iw2B/TR6c50QEOT/9c8gbFmByyf+BFx+tgGnJRHAJqUIHMV3HNvy1 E2l4u03lIF1OOaGEByQ03hS2ruazgdVjoAoneItEaEJosRUdQPdT8YAi5iUovkJ9M2Y0bR2bNB88Z SWRtuetu4CdgVPrAfn1Uy9P85pQxfJXwIaX0t6/LGqGZUUw83rFpTjrqvEFqfrsYqEpLOeJkZCViW DlGu6ltg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vOVsG-001Oza-1o for pgsql-announce@lists.postgresql.org; Thu, 27 Nov 2025 06:53:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vOVsD-00DVHj-2N for pgsql-announce@lists.postgresql.org; Thu, 27 Nov 2025 06:53:02 +0000 Content-Type: multipart/mixed; boundary="===============3173286666501237225==" MIME-Version: 1.0 Subject: SynchDB 1.3 Released - FDW-based Snapshot Engine with PostgreSQL 18 and IvorySQL 5 Support To: PostgreSQL Announce From: Hornetlabs Technology Inc via PostgreSQL Announce Reply-To: grantzhou@hornetlabs.ca Date: Thu, 27 Nov 2025 06:52:07 +0000 Message-ID: <176422632774.2921404.5315318356821606154@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: 8a494e7e9a769db66f32ba0077d9444ec6fdce483d138f5785152584f2abd307 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3173286666501237225== Content-Type: multipart/alternative; boundary="===============1143109947594651133==" MIME-Version: 1.0 --===============1143109947594651133== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Dear Community Members, =20 We are excited to announce the release of SynchDB 1.3, delivering a major p= erformance enhancement with the new FDW-based snapshot engine and expanded = platform support for PostgreSQL 18 and IvorySQL 5. =20 **What's New in SynchDB 1.3:** =20 * **FDW-based Snapshot Engine:** A much faster alternative to Debezium's in= itial snapshot process, making OpenLog Replicator (OLR) connector a fully n= ative snapshot + CDC pipeline with significantly reduced latency and overhe= ad for large Oracle datasets. Applicable to OpenLog Replicator and Oracle c= onnector types via oracle_fdw. =20 * **Revamped Statistics Views:** New categorized views for better observabi= lity =E2=80=94 synchdb_genstats for batch event processing, synchdb_snapsta= ts for initial snapshot, and synchdb_cdcstats for CDC process monitoring. =20 * **PostgreSQL 18 and IvorySQL 5 Compatibility:** Full support for the late= st PostgreSQL and IvorySQL releases with proper handling of IvorySQL's Orac= le compatible mode during snapshot operations. =20 * **OpenLog Replicator Enhancements:** Enhanced Oracle parser supporting mo= re constraint operators, MODIFY clauses, and DEFAULT ON NULL. Improved proc= essing performance, optimized buffer handling, and configurable timeout par= ameters. =20 * **Bug Fixes:** Resolved issues with Oracle parser on PostgreSQL 16, negat= ive decimal processing, large decimal overflow values, and source table nam= es containing spaces. =20 For a detailed list of all changes, please visit our release notes at https= ://github.com/Hornetlabs/synchdb/releases/tag/v1.3 =20 **Acknowledgments and Contributions:** =20 Thank you to all our users who contributed patches, reported bugs, and prop= osed new features. =20 SynchDB thrives on community contributions. We warmly welcome your ideas, f= eature requests, or patches. Please share your contributions on our GitHub = page. =20 **Source Code:** =20 - [github.com/Hornetlabs/synchdb](https://github.com/Hornetlabs/synchdb) =20 **Useful Links:** =20 * Homepage: https://www.synchdb.com * Documentation: https://docs.synchdb.com * Support: Report issues on GitHub =20 We look forward to your feedback on SynchDB 1.3 and your continued support = in making SynchDB even better. =20 Best regards, SynchDB Dev Team =20 --- =20 **About SynchDB** =20 SynchDB is a PostgreSQL extension that enables real-time data synchronizati= on from heterogeneous databases including Oracle, MySQL, and SQL Server int= o PostgreSQL and IvorySQL. It provides both initial snapshot and CDC (Chang= e Data Capture) capabilities, making it an efficient solution for database = migration and real-time data integration. --===============1143109947594651133== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable SynchDB 1.3 Released - FDW-based Snapshot Engine with PostgreSQL= 18 and IvorySQL 5 Support
 

SynchDB 1.3 Released - FDW-based Snapshot Engine with PostgreSQL 18 a= nd IvorySQL 5 Support

Dear Community Members,

We are excited to announce the release of S= ynchDB 1.3, delivering a major performance enhancement with the new FDW-bas= ed snapshot engine and expanded platform support for PostgreSQL 18 and Ivor= ySQL 5.

What's New in SynchDB 1.3:=

  • FDW-based Snapshot Engine:= A much faster alternative to Debezium's initial snapshot process, making O= penLog Replicator (OLR) connector a fully native snapshot + CDC pipeline wi= th significantly reduced latency and overhead for large Oracle datasets. Ap= plicable to OpenLog Replicator and Oracle connector types via oracle_fdw.

  • Revamped Statistics Views:= New categorized views for better observability =E2=80=94 synchdb_genstats = for batch event processing, synchdb_snapstats for initial snapshot, and syn= chdb_cdcstats for CDC process monitoring.

  • PostgreSQL 18 and IvorySQL 5 Compat= ibility: Full support for the latest PostgreSQL and IvorySQL relea= ses with proper handling of IvorySQL's Oracle compatible mode during snapsh= ot operations.

  • OpenLog Replicator Enhancements: Enhanced Oracle parser supporting more constraint operators, MODIFY = clauses, and DEFAULT ON NULL. Improved processing performance, optimized bu= ffer handling, and configurable timeout parameters.

  • Bug Fixes: Resolved issues= with Oracle parser on PostgreSQL 16, negative decimal processing, large de= cimal 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/t= ag/v1.3

Acknowledgments and Contributions:<= /strong>

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 y= our contributions on our GitHub page.

Source Code:

Useful Links:

  • Homepage: https= ://www.synchdb.com
  • Documentation: = https://docs.synchdb.com
  • Support: Report= issues on GitHub

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 enab= les real-time data synchronization from heterogeneous databases including O= racle, 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.

This email was sent to you from Hornetlabs Technology Inc. It was delivered= on their behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to Hornetlabs Technology Inc.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============1143109947594651133==-- --===============3173286666501237225==--