Skip to Content
Tutorials

Programming

Programming tutorials for people who want code that actually runs, not code that only looks right. Pick a language, start at the beginning, and don't skip the basics. They are where most problems come from.

Any category Programming3 SQL 3 DevOps11 Docker 11
Any topics APIs and Integrations 7 Automation and Scripting 3 Data Structures and Algorithms 2 Databases 11 Deployment and Containers 3 Object-Oriented Programming 3 Packaging and Dependencies 5 Performance Optimization 21 Programming Patterns 10 Testing and Debugging 9 Type Systems 14 Web Development 15
Any level Beginner 1 Advanced 3
Programming Deployment and Containers Advanced Clear filters 3 results
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