SynchDB 1.1 Released - Now with Oracle Support and Enhanced Data Transformation
Posted on 2025-04-21 by Hornetlabs Technology Inc
Related Open Source
Release Date: April 17, 2025
We're excited to announce the release of SynchDB 1.1! This update expands our heterogeneous database synchronization capabilities with Oracle connector support, enhanced data transformation features, and significant performance improvements to the core data processing engine.
SynchDB continues to provide seamless, native data synchronization from multiple database platforms directly to PostgreSQL without middleware, now with expanded compatibility and flexibility.
Major Enhancements
New Connector Support
- Oracle connector support - Synchronize data directly from Oracle databases
- 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 flexible 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
About SynchDB
SynchDB is an open-source PostgreSQL extension developed by Hornetlabs Technology. It enables direct data replication from heterogeneous databases (MySQL, MS SQLServer, 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.
Sincerely,
The SynchDB Team at Hornetlabs Technology