v0.2.0

pgcopy Release Notes

v0.2.0 - Enhanced User Experience & Interactive Mode 🎨

Released: August 2, 2025

I'm excited to announce pgcopy v0.2.0, an update that improves the user experience with an all-new interactive mode, simplified command-line interface, and enhanced logging capabilities. This release makes pgcopy more intuitive and powerful for PostgreSQL data copying operations.

🎯 What's New in v0.2.0

This release focuses on user experience improvements while maintaining the high-performance data copying capabilities that make pgcopy indispensable for PostgreSQL data synchronization tasks.

✨ Major Features

🖥️ Interactive Mode - Real-Time Data Copy Visualization

NEW: A completely new interactive terminal UI that provides real-time visualization of your data copy operations.

🎛️ Simplified Output Control - Single Parameter for All Display Modes

BREAKING CHANGE: Replaced confusing --interactive and --no-progress flags with a single, intuitive --output parameter.

📝 Enhanced Logging & File Output

NEW: Comprehensive logging system with both terminal and file output

🔧 Infrastructure Improvements

Foreign Key Management Enhancements

• Backup File System: Automatic FK constraint backup to .fk_backup.sql
• Safety Checks: Prevents running with unrestored FKs from previous operations
• Recovery Mechanism: Automatic attempt to restore FKs from backup files
• Error Resilience: Better handling of FK restoration failures

Code Quality & Reliability

• Linting Compliance: Resolved all golangci-lint warnings and errors
• Refactored Conditionals: Improved code organization with separate methods
• Thread Safety: Enhanced concurrent access protection for FK management

🐛 Bug Fixes

• Fixed: Interactive mode progress bar now properly tracks overall completion
• Fixed: Resolved linting issues with complex if-else chains
• Fixed: Improved error handling in FK restoration processes
• Fixed: Memory leaks in display update mechanisms
• Improved: Thread safety in concurrent FK operations