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.94.2) (envelope-from ) id 1u6sBw-006nEU-Il for pgsql-announce@arkaria.postgresql.org; Mon, 21 Apr 2025 14:32:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u6sBu-0062zc-Gv for pgsql-announce@arkaria.postgresql.org; Mon, 21 Apr 2025 14:32:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6sBt-0062zC-BW for pgsql-announce@lists.postgresql.org; Mon, 21 Apr 2025 14:32:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u6sBq-001EzE-0Q for pgsql-announce@lists.postgresql.org; Mon, 21 Apr 2025 14:32:09 +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=uygWlSh2RHWebi2XAnyWYgR+9b/PrsE59uerFTm34jE=; b=QIVqetDAjk73eeCLajE+Oznyga S6idHaR5ObWKxrjTBf4KGmqMQCTbUdte17UIOA4qDhIx4hRlBAI11ghj+SOjomHZFRYbM0dRP3bjX 5h2+MYDwKyAHJUWZhgwKx1279/psfUsjGLgCF/q3iAFKX/YYYTdMVZgfmFTeP1n9H6481yShvY0cz yh1sTbg8W2Z/c8NPrkFr73UXse2yRZJuA63a8vfEnK7OQHHohqjGNM/JB0DNMfxH3MVK0K1Am+FM7 hgZst3hdX6Peqc+DSy+jA+sgfI/hA9gQAB7Ohuhyoa1nQbWa5Ab8qIFhAEaJm62M+01dZPL350kmj OCuUm3XA==; 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.94.2) (envelope-from ) id 1u6sBn-003PeY-MT for pgsql-announce@lists.postgresql.org; Mon, 21 Apr 2025 14:32:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u6sBm-008VXq-7F for pgsql-announce@lists.postgresql.org; Mon, 21 Apr 2025 14:32:02 +0000 Content-Type: multipart/mixed; boundary="===============7109949647275135896==" MIME-Version: 1.0 Subject: SynchDB 1.1 Released - Now with Oracle Support and Enhanced Data Transformation To: PostgreSQL Announce From: Hornetlabs Technology Inc via PostgreSQL Announce Reply-To: grantzhou@highgo.ca Date: Mon, 21 Apr 2025 14:31:04 +0000 Message-ID: <174524586412.676.14007450143031745998@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: c97866d49d38bb0a7ab9f58882866fdb91c0fdded749aa23fb7f9f37e107e15a List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7109949647275135896== Content-Type: multipart/alternative; boundary="===============5766978899879611254==" MIME-Version: 1.0 --===============5766978899879611254== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable **Release Date: April 17, 2025** We're excited to announce the release of SynchDB 1.1! This update expands o= ur heterogeneous database synchronization capabilities with Oracle connecto= r support, enhanced data transformation features, and significant performan= ce improvements to the core data processing engine. SynchDB continues to provide seamless, native data synchronization from mul= tiple database platforms directly to PostgreSQL without middleware, now wit= h expanded compatibility and flexibility. ## Major Enhancements ### New Connector Support * **Oracle connector support** - Synchronize data directly from Oracle data= bases * Extended compatibility with **PostgreSQL 16, 17, and IvorySQL 4.4** * Support for Oracle's variable size/scale `NUMBER` data type processing ### Advanced Object Mapping & Data Transformation * New object mapping system with dedicated tables and functions for flexibl= e data transformation * Simplified management of table names, column names, and data type mappings * Transform expressions for complex data conversions ### Improved Monitoring & Metadata * Side-by-side comparison views of data type and naming mappings * Enhanced statistics with timestamp tracking across source, Debezium, and = PostgreSQL ### Performance Optimizations * Intelligent caching for DML parsing and JNI calls * More efficient JSONB processing for faster data handling * Optimized batch processing for higher throughput * Modular data processing engine design for complex mappings ### Configuration & Control * New error handling strategies (skip, exit, or retry) * Debezium log level control * Additional snapshot mode options * Enhanced SSL connection parameter management ## Changes from Previous Version * Object mappings now replace rule files for more flexible configuration * More intelligent handling of ALTER TABLE operations * Enhanced data type processing based on category * Streamlined connector configuration ## Fixed Issues * Resolved SPI update/delete issues with primary key fields * Fixed ALTER TABLE errors with duplicate primary keys * Corrected column schema lookups from JSON change events * Fixed issues with error handling and column operations ## Resources * GitHub Repository: [SynchDB GitHub](https://github.com/Hornetlabs/synchdb) * Documentation: [SynchDB Docs](https://docs.synchdb.com/) * Downloads: [Release v1.1](https://github.com/Hornetlabs/synchdb/releases/= tag/v1.1) * Issue Reporting: [GitHub Issues](https://github.com/Hornetlabs/synchdb/is= sues) * Website: [Hornetlabs Technology](https://hornetlabs.ca) ## About SynchDB SynchDB is an open-source PostgreSQL extension developed by Hornetlabs Tech= nology. It enables direct data replication from heterogeneous databases (My= SQL, MS SQLServer, Oracle, etc.) to PostgreSQL with high performance and re= liability. The extension handles all synchronization needs without requirin= g middleware or third-party software. We appreciate your continued support and feedback as we work to make SynchD= B the most powerful database synchronization tool available for PostgreSQL. Sincerely, The SynchDB Team at Hornetlabs Technology --===============5766978899879611254== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable SynchDB 1.1 Released - Now with Oracle Support and Enhanced Data= Transformation
 

SynchDB 1.1 Released - Now with Oracle Support and Enhanced Data Tran= sformation

Release Date: April 17, 2025

We're excited to announce the release of Sy= nchDB 1.1! This update expands our heterogeneous database synchronization c= apabilities with Oracle connector support, enhanced data transformation fea= tures, and significant performance improvements to the core data processing= engine.

SynchDB continues to provide seamless, nati= ve data synchronization from multiple database platforms directly to Postgr= eSQL without middleware, now with expanded compatibility and flexibility.

Major Enhancements

New Connector Support

  • Oracle = connector support - Synchronize data directly from Oracle database= s
  • Extended compat= ibility with PostgreSQL 16, 17, and IvorySQL 4.4
  • Support for Ora= cle's variable size/scale NUMBER data type processing

Advanced Object Mapping & D= ata Transformation

  • New object mapp= ing system with dedicated tables and functions for flexible data transforma= tion
  • Simplified mana= gement of table names, column names, and data type mappings
  • Transform expre= ssions for complex data conversions

Improved Monitoring & Metad= ata

  • Side-by-side co= mparison views of data type and naming mappings
  • Enhanced statis= tics with timestamp tracking across source, Debezium, and PostgreSQL

Performance Optimizations

  • Intelligent cac= hing for DML parsing and JNI calls
  • More efficient = JSONB processing for faster data handling
  • Optimized batch= processing for higher throughput
  • Modular data pr= ocessing engine design for complex mappings

Configuration & Control

  • New error handl= ing strategies (skip, exit, or retry)
  • Debezium log le= vel control
  • Additional snap= shot mode options
  • Enhanced SSL co= nnection parameter management

Changes from Previous Version
  • Object mappings= now replace rule files for more flexible configuration
  • More intelligen= t handling of ALTER TABLE operations
  • Enhanced data t= ype processing based on category
  • Streamlined con= nector configuration

Fixed Issues

  • Resolved SPI up= date/delete issues with primary key fields
  • Fixed ALTER TAB= LE errors with duplicate primary keys
  • Corrected colum= n schema lookups from JSON change events
  • Fixed issues wi= th error handling and column operations

Resources

About SynchDB

SynchDB is an open-source PostgreSQL extens= ion developed by Hornetlabs Technology. It enables direct data replication = from heterogeneous databases (MySQL, MS SQLServer, Oracle, etc.) to Postgre= SQL with high performance and reliability. The extension handles all synchr= onization needs without requiring middleware or third-party software.

We appreciate your continued support and fe= edback as we work to make SynchDB the most powerful database synchronizatio= n tool available for PostgreSQL.

Sincerely,

The SynchDB Team at Hornetlabs Technology

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/.
 
--===============5766978899879611254==-- --===============7109949647275135896==--