v0.5.0
pgcopy Release Notes
v0.5.0 β Exact Row Counts + Web UI Polish β
Released: August 8, 2025
A focused quality release that improves accuracy for planning, polishes the Web UI, and tightens reliability.
Highlights
-
Exact row counts (new)
--exact-rowscomputes precise counts withCOUNT(*)during discovery- Per-table timeout with automatic fallback to fast estimates
- Fixes misleading progress/speed when tables were recently TRUNCATEd
-
Web UI improvements
- Sortable headers: status, table, records, speed, duration
- ETA removed; new Duration column with live ticking while copying
- Zero-row tables show
00:00:00; clear sort indicators
-
Stability & quality
- Graceful shutdown across copy flow and web server; improved connection handling
- Context timeouts for foreign key operations and parallel table copying
- Debounced WebSocket/state updates for smoother UI and lower overhead
- Sentinel errors + contextual messages for clearer classification and summaries
- Sequence reset after table data load to keep nextval aligned
- Linter/security cleanups (zero golangci-lint issues)
Changelog
Others
- fc555ca: Add --exact-rows flag for precise row counting
- 307bd90: Add context timeouts for foreign key operations and parallel table copying
- 035eff8: Add graceful shutdown and context support for copy operations
- eaff51e: Debouncing for WebSocket updates and enhance progress calculation
- 0ffd0da: Documentation clean up
- 8763ad3: Enhance error handling with contextual messages and introduce sentinel errors for better classification
- bb07823: Implement graceful shutdown for web server and enhance connection handling
- e12994c: Implement sequence reset after table data load
- 7814e98: Implement sortable table headers and update duration display for copying tables
- 6091774: Quoting identifiers and tables
- 522a0c9: Refactor database driver to use pgx and improve foreign key detection with parameterized queries
- 3487dc6: Refactor foreign key manager to use locked deduplication for dropped keys
- 6d0548b: Refactor interactive display handling to rely on global state management
- 4e226dc: Refactor table filtering logic and add pattern matching functions for schema.table
- c28f439: Revise README and add Quick Start guide