Archiving PostgreSQL data with Coldctl v1
A ten-million-row Boolescale demo with Coldctl 0.1.1: retention policies, 4.77 million archived and verified rows, partial restore results, and Cloud metadata sync.
Database archives, explained.
Practical notes on retaining historical data, verifying archives and operating databases.
- MySQL
- MongoDB
- Data Archiving
- Parquet
- DuckDB
- Database Operations
- ColdCTL
How to Archive Old Data from MySQL Without Downtime
Design an online MySQL archival workflow with indexed keyset reads, bounded batches, durable checkpoints, verification and a separate deletion gate.
How to Archive Old MongoDB Documents
Select historical MongoDB documents with stable timestamp and _id cursors, preserve BSON meaning in exports, verify batches and separate archival from deletion.
Database Archiving vs Backup
Separate operational recovery from historical-data retention: what backups recover, what archives retain, and how to test both workflows.
Why Parquet Works Well for Database Archives
Understand Parquet’s columnar layout, compression, schema mapping and selective reads, with the trade-offs that matter for long-lived database archives.
How to Query Parquet Files with DuckDB
A reproducible DuckDB tutorial covering local Parquet reads, projections, filters, multiple files, Hive partitions, S3 credentials and query-plan inspection.