Tag: notes
3 posts tagged “notes”.
SQL Window Functions: The Query Feature You're Not Using
ROW_NUMBER, RANK, LAG, LEAD, running totals, moving averages, top-N-per-group — a deep dive into window functions and the queries they make embarrassingly simple.
The Science of Pour-Over Coffee
Extraction chemistry, grind size, water hardness, the bloom, and why the 4:6 method works — the variables behind a great cup, ranked by how much they actually matter.
Tiny CMS, Big Ideas: A Food Cart Ledger
How a Jakarta street cart keeps perfect books without a database — just a notebook, a stamp, and a ruthless closing routine.