Skip to Content
PROGRAMMING

SQL

Practical tutorials for the work we actually do. Pick one, read it in order, and apply it.

Any category Programming4 SQL 4 DevOps32 Docker 32
Any topics Data Structures and Algorithms 1 Databases 32 Deployment and Containers 4 Performance Optimization 8 Testing and Debugging 5
Any level Beginner 1 Advanced 3
SQL Deployment and Containers Clear filters 4 results
0 likes
Verify a PostgreSQL Practice Database and Its Persistence

Identify an isolated practice database, record its cluster and marker, and verify persistence through restart and container replacement before exact cleanup.

7 min read
0 likes
Create an Index Without Blocking Writes

Build an index with CREATE INDEX CONCURRENTLY while a writer is active, and handle the transaction-block error and the invalid index that a failed build leaves. After this, you can add an index to a busy table without stopping its writers.

4 min read
0 likes
Add a NOT NULL Column to a Big Table Without Downtime

Add a NOT NULL column to a big table with a constant default, or with a nullable column, a batch backfill, NOT VALID and VALIDATE. After this, you can tell a quick change from a table rewrite and avoid long locks.

5 min read
0 likes
Back Up With pg_dump and Prove the Restore Works

Take a pg_dump backup in Docker, restore it into a scratch database, compare the tables and see what a damaged backup looks like. After this, you have a short routine that proves your backup works.

5 min read