SystemCraft Press

SystemCraft Press

Archives
Log in
Subscribe
INNER JOIN vs LEFT JOIN: Which Rows Survive?
November 9, 2026
Joins click once you stop thinking in circles and ask one question: what happens to a row with no match? This week’s post uses a tiny example to show how INNER and LEFT JOIN answer it, plus the WHERE-clause trap that quietly undoes a LEFT JOIN.

'.map is not a function' — You're Not Holding an Array
November 2, 2026
The error isn't about map() at all. It means the value before the dot isn't an array: usually an object, a Set, or an unparsed string. Here's the fix.

Pipes and Redirection: How >, >>, 2> and | Really Work
October 28, 2026
Ever pasted a shell one-liner full of |, > and 2>&1 without knowing why it works? This week’s post breaks it into three simple ideas and shows the one ordering mistake that trips almost everyone.

Git's 'src refspec main does not match any', Explained
October 21, 2026
Copied GitHub’s push commands into a new repo and got “src refspec main does not match any”? Nothing is wrong with GitHub. The error is about your local branch, and this week’s post shows the three usual causes and how to fix each.

The Only VS Code Shortcuts Worth Learning First
October 15, 2026
Most VS Code shortcut lists are too long to learn from. This week’s post picks seven, in the order to learn them, and starts with the one that helps you find all the others: the Command Palette.

pip says installed. Python says missing. Both are right.
October 10, 2026
The package is installed and Python says it doesn't exist. Both are true: pip and python can belong to different installations. Here's how to see which one is which and how to make them agree.

"Bad interpreter" doesn't mean what you think
October 4, 2026
The file is right there, so why does the shell say it doesn't exist? The error is about the interpreter named on the first line, and usually a hidden carriage return is the culprit. Here's how to see it and fix it.

Why your VS Code breakpoint won't stop
September 29, 2026
A hollow breakpoint dot isn't VS Code ignoring you — it means the debugger couldn't connect that line to any code it's actually running. Here's the exact mechanism and how to fix it.

Your JOIN is quietly doubling your numbers
September 25, 2026
SQL doesn't warn you when a JOIN multiplies your rows — it just quietly hands back more of them than you expected, and every SUM() and COUNT() downstream...

Git isn't blocking your push. It's protecting one you haven't seen.
September 22, 2026
You finish up some work, run git push, and instead of the usual quiet success, you get this: $ git push To github.com:you/project.git ! [rejected] main ->...

console.log isn't lying to you. Your await is missing.
September 18, 2026
You write a function to fetch a user, call it, and log the result to check it worked: async function getUser(id) { return fetch(`/api/users/${id}`).then(r =>...

Your variable exists. Python still calls it undefined.
September 15, 2026
The variable has a value elsewhere in your program — just not in the scope Python already decided this line belongs to. Here's how Python actually assigns...

'Permission Denied'? Don't reach for sudo
September 12, 2026
The file is right there. It's not corrupted, and you're not missing a typo. Linux just hasn't been told this file is allowed to run — here's the one-line...

VS Code running the wrong Python (again)
September 9, 2026
If you've had a venv that's active everywhere except where you needed it, this one's for you. You created a virtual environment, activated it, installed your...

Welcome to SystemCraft Press
August 8, 2026
Hi, Thanks for subscribing. Here are your free cheat sheets: Git & GitHub cheat sheet Python cheat sheet JavaScript cheat sheet Command Line cheat sheet SQL...

systemcraftpress.com
Powered by Buttondown, the easiest way to start and grow your newsletter.