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 Programming161 Python 32 JavaScript 33 TypeScript 32 SQL 32 HTML and CSS 32 DevOps32 Docker 32
Any topics APIs and Integrations 12 Automation and Scripting 6 Data Structures and Algorithms 8 Databases 32 Deployment and Containers 4 Object-Oriented Programming 7 Packaging and Dependencies 16 Performance Optimization 24 Programming Basics 18 Programming Patterns 12 Security 1 Testing and Debugging 32 Type Systems 35 Web Development 38
Any level Beginner 50 Intermediate 55 Advanced 56
Programming Clear filters 161 results
0 likes
Find and Fix a Deadlock

Reproduce a deadlock between two money transfers, read the message, and fix it by locking rows in the same order. After this, you can turn a deadlock detected error into a plain wait.

5 min read
0 likes
Process a Job Queue With SKIP LOCKED

Let two workers take different jobs from one table with FOR UPDATE SKIP LOCKED, and see what happens to a job when a worker fails. After this, you can use a plain table as a safe queue.

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
Walk a Tree With a Recursive CTE

Walk down an employee tree, walk up to the top, count each manager's team and guard the query against a loop with CYCLE. After this, you can query a parent-child table of any depth.

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