**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 * 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/issues) * Website: [Hornetlabs Technology](https://hornetlabs.ca) ## 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
