Skip to article

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.

Nov 20, 2026 · 5 minLive terminal ↗

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.

Nov 20, 2026 · 65 minLive terminal ↗

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.

Nov 13, 2026 · 4 minLive terminal ↗

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.

Nov 5, 2026 · 6 minLive terminal ↗

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.

Oct 30, 2026 · 8 minLive terminal ↗

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.

Oct 16, 2026 · 5 minLive terminal ↗

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.

Oct 15, 2026 · 5 minLive terminal ↗

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.

Oct 14, 2026 · 5 minLive terminal ↗

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.

Oct 13, 2026 · 5 minLive terminal ↗

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.

Oct 12, 2026 · 5 minLive terminal ↗

A new kind of technical article: a little context, a useful diagram, and something you can actually try.