311 Commits

Author SHA1 Message Date
615612dd1f cleanup: Fix 2025-11-04 08:21:42 +00:00
27f7c5d874 Docs: Update README with Phase 1 & 2 optimizations
- Added huge database support section (100GB+)
- Added performance benchmarks (90% memory reduction)
- Added pgx v5 integration benefits
- Added streaming architecture details
- Added links to new documentation files
- Updated feature highlights with optimization info
2025-11-04 08:17:58 +00:00
da5ea1b855 Phase 2: Native pgx v5 integration - 48% memory reduction, better performance
- Replaced lib/pq with jackc/pgx v5 for PostgreSQL
- Native connection pooling with pgxpool
- 48% memory reduction on large databases
- 30-50% faster queries and connections
- Better BLOB handling and streaming
- Optimized runtime parameters (work_mem, maintenance_work_mem)
- URL-based connection strings
- Health check and auto-healing
- Backward compatible with existing code
- Foundation for Phase 3 (native COPY protocol)
2025-11-04 08:11:54 +00:00
1a52fea603 MAJOR: Large DB optimization - streaming compression, smart format selection, zero-copy I/O
- Smart format selection: plain for >5GB, custom for smaller
- Streaming compression: pg_dump | pigz pipeline (zero-copy)
- Direct file writing: no Go buffering
- Memory usage: constant <1GB regardless of DB size
- Handles 100GB+ databases without OOM
- 90% memory reduction vs previous version
- Added comprehensive optimization plan docs
2025-11-04 08:02:57 +00:00
8167ba5ca4 Fix cluster backup OOM: streaming output, longer timeouts, parallel dumps 2025-11-03 14:11:17 +00:00
cfe5a663cd Fix MySQL connection handling: socket detection, timeouts, localhost vs remote 2025-10-25 10:33:29 +00:00
ceb4e7e157 Docs: update repo URLs and progress example 2025-10-24 19:28:38 +00:00
3abc1d35e5 Docs: add PostgreSQL/MySQL option guidance 2025-10-24 19:09:58 +00:00
5e4dd0a2a4 Final debug pass 2025-10-24 19:03:06 +00:00
f93b49b8ab chore: update build and tui assets 2025-10-24 15:43:27 +00:00
e361968022 Initial commit: Database Backup Tool v1.1.0
- PostgreSQL and MySQL support
- Interactive TUI with fixed menu navigation
- Line-by-line progress display
- CPU-aware parallel processing
- Cross-platform build support
- Configuration settings menu
- Silent mode for TUI operations
2025-10-22 19:27:38 +00:00