Read it.
Run it.
Git / Stash / Working tree
Git Stash Pop vs Apply: The Difference With Examples
Restore unfinished work with git stash apply or pop, compare the stash list, and learn what happens when changes conflict.
PostgreSQL / Release notes / SQL / Operations
PostgreSQL 19: less friction, more control
Run the new SQL, inspect the planner, and replicate between real PostgreSQL 19 servers.
Git / Gitignore / Working tree
How to Stop Tracking a File Without Deleting It
Keep a local file, remove it from Git tracking, and understand why .gitignore alone is not enough. Try the commands in a disposable browser VM.
SQL / PostgreSQL / NULL
COUNT(*) vs COUNT(column): Why Your Counts Differ
Count rows, missing values and distinct values, then fix a misleading LEFT JOIN total in a live PostgreSQL lab.
SQL / PostgreSQL / Transactions
DELETE vs TRUNCATE vs DROP in PostgreSQL: Try the Difference
Delete selected rows, empty a table or remove it entirely. Compare PostgreSQL DELETE, TRUNCATE and DROP in a disposable browser VM.
Git / Branches / Recovery
Committed to the Wrong Git Branch? Move Your Commits
Move commits from main to another Git branch. Practice unpushed recovery and a shared-history revert in real repositories inside a browser VM.
Git / Reflog / Recovery
Undo git reset --hard: Recover Commits with Reflog
Recover committed work after git reset --hard. Find the lost tip with git reflog and restore it on a rescue branch in a disposable browser VM.
PostgreSQL / Indexes / EXPLAIN
PostgreSQL Not Using an Index? Diagnose It with EXPLAIN
Diagnose PostgreSQL sequential scans with runnable EXPLAIN examples. Test selectivity, statistics and expression indexes in a disposable browser VM.
SQL / PostgreSQL / Joins
SQL LEFT JOIN with WHERE: Why Rows Disappear
See why a WHERE condition removes unmatched LEFT JOIN rows. Compare ON, WHERE and OR IS NULL in a live PostgreSQL browser VM.
SQL / PostgreSQL / NULL
SQL NOT IN and NULL: Why Your Query Returns No Rows
Reproduce the SQL NOT IN NULL trap, compare NOT EXISTS and filtered subqueries, and test the fix in a live PostgreSQL browser VM.
A new kind of technical article: a little context, a useful diagram, and something you can actually try.