Version 0.5.0 Released

[cbrianpace]

🎉 Major Features

1. Snowflake Support

• NEW: Full support for Snowflake as both source and target database
• Added SnowflakeHelper class for Snowflake-specific operations
• Implemented Snowflake SQL constants and query patterns
• Platform-specific metadata handling for Snowflake

2. SQL Fix Generation (Preview, limited ability)

• NEW: Automatic generation of SQL statements to fix data discrepancies
• Generate INSERT, UPDATE, and DELETE statements for out-of-sync rows
• Support for complex primary key scenarios with proper escaping
• Corrective SQL generation is new, limited in abiliies, and experimental.
• SQL generated should be considered examples and reviewed closely.

3. Web UI (Preview)

• NEW: Modern web-based user interface built with Next.js and React
• Real-time comparison monitoring and status updates
• Project and table management through intuitive UI
• Visual representation of comparison results
• Dark/Light theme support
• RESTful API backend for UI integration

---

🚀 Performance Improvements

Multi-Threading Enhancements

• Optimized thread synchronization with ThreadSync improvements
• Better queue management for data loading threads
• Enhanced observer thread coordination
• Reduced thread contention and improved throughput

Database Operations

• Improved batch processing with configurable batch sizes
• Optimized fetch sizes for large result sets
• Better connection pooling and resource management
• Reduced database round-trips through batching

Memory Management

• More efficient CachedRowSet usage
• Improved cleanup of database resources
• Better handling of large data sets

---

🐛 Bug Fixes

Data Comparison

• Fixed: Equal count calculation bug in comparison results
• Fixed: Primary key escaping for special characters and quotes
• Fixed: Handling of NULL values in comparisons
• Fixed: Case sensitivity issues in identifier handling

Threading

• Fixed: Race conditions in thread synchronization
• Fixed: Proper cleanup of thread resources
• Fixed: Observer thread coordination issues

Database Operations

• Fixed: Connection leaks in error scenarios
• Fixed: Transaction management in batch operations
• Fixed: Proper handling of platform-specific SQL syntax