Databases
How to Check Database Size and Table Sizes From the Shell
Check database size from the shell in PostgreSQL, MySQL, SQLite and Redis: database and table sizes, indexes, the largest objects and a script for trends.
7 min read
Tag
databases
9 posts
Databases
How to Use DuckDB From the Command Line for Big Files
Query large CSV, JSON and Parquet files with the DuckDB command line: no import step, glob many files, summarize, export and set memory limits.
6 min read
Databases
How to Use csvsql and q to Run SQL on CSV Files the Safe Way
Run SQL on CSV files from the terminal with csvsql and q, or plain sqlite3: queries, type inference traps, joins across files and output formats.
6 min read
Databases
What Is Point in Time Recovery and When You Need It
Point in time recovery restores a database to a chosen moment: base backups plus archived logs, a PostgreSQL setup, and when you need it.
6 min read
Databases
How to Test Backup and Restore Drills for a Small Database
Run a restore drill for a small database: schedule, steps, a clean machine, timing the recovery, checking data and writing down what to fix.
6 min read
Databases
How to Use jq to Prepare JSON for Database Import Safely
Prepare JSON for a database import with jq: flatten to CSV or JSON Lines, handle nulls and types, escape safely, and load with COPY, mongoimport or SQLite.
6 min read
Cron and Scheduling
How to Schedule Database Maintenance Jobs the Safe Way
Schedule database maintenance jobs safely: backups, vacuum and analyze, optimize, index checks, off-peak timing, locks, runtime limits and monitoring results.
6 min read
Databases
How to Create Users and Grants From the Shell Safely
Create database users and grants from the shell for PostgreSQL and MySQL: least privilege, passwords kept off the command line, idempotent scripts and checks.
7 min read
Databases
mysqldump vs mydumper vs XtraBackup and When to Use Each
Compare mysqldump, mydumper and Percona XtraBackup: logical versus physical backup, speed, consistency, locking, restore time and when to use each.
6 min read