Development

38 posts

Beginner-to-advanced guides across many programming languages — Python, JavaScript, TypeScript, Java, Go, Rust, C/C++, and more — plus SQL databases, Linux server ops, and practical, example-driven fixes and tips.

Development

Eleven Seconds to Eighty Milliseconds: Reading MySQL EXPLAIN Like a Pro

It's 2 a.m. and your phone is buzzing. The order dashboard, which loaded in 80 milliseconds last spring, now takes eleven seconds. Nothing in the code changed. What changed is the table: it went from...

2026.10.23 · 17 min read · views 466
Eleven Seconds to Eighty Milliseconds: Reading MySQL EXPLAIN Like a Pro
Development

The Cron Job That Failed for Six Days and Told Nobody

It is 9:15 on a Monday morning. A teammate asks why the weekly report is still showing last Tuesday's numbers. You open the server, and there it is: the cron job that builds the report has not worked...

2026.10.21 · 16 min read · views 315
The Cron Job That Failed for Six Days and Told Nobody
Development

One Line After OVER() Replaces Your Messy Self-Join

Your manager sends a one-line request on a Thursday afternoon: "Can you pull the top three orders for every customer, plus how each one compares to the previous order?" You open your SQL editor, stare...

2026.10.08 · 6 min read · views 753
One Line After OVER() Replaces Your Messy Self-Join
Development

Your Script Crashed on a String That Should Have Been a Number

It's Tuesday afternoon and your Python script just crashed in production. The traceback is short and unfriendly: `TypeError: unsupported operand type(s) for : 'str' and 'int'`. Somewhere upstream, a J...

2026.10.06 · 14 min read · views 842
Your Script Crashed on a String That Should Have Been a Number
Development

Your Dashboard Took Eleven Seconds to Load. An Index Could Fix That.

It's a Tuesday afternoon, and the dashboard that loaded instantly during your first month of launch now takes eleven seconds. Nothing in the code changed. The table just grew from 5,000 rows to 4 mill...

2026.10.04 · 8 min read · views 853
Your Dashboard Took Eleven Seconds to Load. An Index Could Fix That.
Development

Your Bash Script Failed Last Night. It Just Didn't Tell You.

It's 2 a.m. and your nightly backup script reports "success." Three weeks later you need the backup, and the folder is empty. The script never failed. It just kept going after `cd` quietly didn't work...

2026.10.02 · 11 min read · views 1,193
Your Bash Script Failed Last Night. It Just Didn't Tell You.
AD
Development

You Didn't Lose Your Commits. Git Just Stopped Pointing at Them.

It is 6:40 p.m. and you just ran `git reset --hard HEAD~3` to clean up a messy branch. Then your stomach drops. Two of those three commits were the afternoon's real work, and the third was a fix you h...

2026.10.01 · 16 min read · views 936
You Didn't Lose Your Commits. Git Just Stopped Pointing at Them.
Development

A Folder, a PATH Change, and the End of Dependency Drama

You clone a teammate's Python project, run `pip install -r requirements.txt`, and get a wall of red text. Two hours later you discover the project wanted Python 3.11, your machine has 3.9, and a packa...

2026.09.29 · 14 min read · views 546
A Folder, a PATH Change, and the End of Dependency Drama
Development

The Site Is Down. Stop Restarting and Read the Logs.

It's 2:14 on a Tuesday afternoon and the site is down. Someone from support has already pasted a screenshot into chat. Your first instinct is to refresh the page, then restart the service, then refres...

2026.09.19 · 20 min read · views 612
The Site Is Down. Stop Restarting and Read the Logs.
Development

The Query That Made Me Stop Writing Self-Joins

The query was four hundred lines long. It had three nested subqueries, two of which selected from the same table with slightly different date filters, and a self-join that existed purely so one row co...

2026.09.16 · 13 min read · views 748
The Query That Made Me Stop Writing Self-Joins
AD