~/tags $ grep -l '#sql' _posts/*
// #sql
3 posts tagged.
Reading Proxmox Backup Server Index Files to Find What Deleting a Snapshot Actually Frees
Proxmox Backup Server shows a snapshot's logical size, so ten backups of one guest each look full size. Deduplication means deleting one can free almost nothing. I parsed the chunk index files directly to get the real...
Turning Three Smart Plugs Into a Multi-Site Electricity Cost Dashboard
I connected three energy-monitoring plugs across two sites to one time-series database, then turned frequent power readings and public regional tariffs into selected-period electricity-cost estimates. The difficult pa...
SQL: An Idiot's Guide
SQL, or Structured Query Language, is a programming language designed for managing and manipulating relational databases. It is widely used in the field of database management and is considered a stan