---
title: "SystemCraftDev (@systemcraftdev) | Hashnode"
description: "Building practical Companion Guides for developers (Git, Python, JavaScript, SQL, VS Code, the command line) at systemcraftpress.com."
url: "https://hashnode.com/@systemcraftdev"
---

@systemcraftdev

# SystemCraftDev

@systemcraftdev · Joined August 2026

Building practical Companion Guides for developers (Git, Python, JavaScript, SQL, VS Code, the command line) at systemcraftpress.com.

[Website](https://systemcraftpress.com/)

### [INNER JOIN vs LEFT JOIN: Which Rows Survive?](https://systemcraftpress.hashnode.dev/inner-join-vs-left-join-which-rows-survive?utm_source=hashnode&utm_medium=feed)

Most JOIN confusion comes down to one question: what happens to rows with no match? Here's how INNER and LEFT JOIN answer it, and how to choose.

5 min read · [systemcraftpress.hashnode.dev](https://systemcraftpress.hashnode.dev/inner-join-vs-left-join-which-rows-survive?utm_source=hashnode&utm_medium=feed)

[6d ago](https://hashnode.com/posts/inner-join-vs-left-join-which-rows-survive/6af295b2a80a3f823560c3b9)

### ['.map is not a function' — You're Not Holding an Array](https://systemcraftpress.hashnode.dev/map-is-not-a-function-you-re-not-holding-an-array?utm_source=hashnode&utm_medium=feed)

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.

5 min read · [systemcraftpress.hashnode.dev](https://systemcraftpress.hashnode.dev/map-is-not-a-function-you-re-not-holding-an-array?utm_source=hashnode&utm_medium=feed)

[Nov 3](https://hashnode.com/posts/map-is-not-a-function-you-re-not-holding-an-array/6ae95abdd3eb99281f7f67d5)

### [Pipes and Redirection: How >, >>, 2> and | Really Work](https://systemcraftpress.hashnode.dev/pipes-and-redirection-how-2-and-really-work?utm_source=hashnode&utm_medium=feed)

Four small symbols move text between commands and files. Once you see the three streams behind them, shell one-liners stop looking like magic.

6 min read · [systemcraftpress.hashnode.dev](https://systemcraftpress.hashnode.dev/pipes-and-redirection-how-2-and-really-work?utm_source=hashnode&utm_medium=feed)

[Oct 29](https://hashnode.com/posts/pipes-and-redirection-how-2-and-really-work/6ae2b682158c63de7f7fa4b2)

### [Git's 'src refspec main does not match any', Explained](https://systemcraftpress.hashnode.dev/git-s-src-refspec-main-does-not-match-any-explained?utm_source=hashnode&utm_medium=feed)

Your push failed because the branch you named doesn't exist locally yet: no commits, a master/main mix-up, or a typo. Here's how to tell which.

5 min read · [systemcraftpress.hashnode.dev](https://systemcraftpress.hashnode.dev/git-s-src-refspec-main-does-not-match-any-explained?utm_source=hashnode&utm_medium=feed)

[Oct 22](https://hashnode.com/posts/git-s-src-refspec-main-does-not-match-any-explained/6ad9763ebbe134a1a29f5dbf)

### [The Only VS Code Shortcuts Worth Learning First](https://systemcraftpress.hashnode.dev/the-only-vs-code-shortcuts-worth-learning-first?utm_source=hashnode&utm_medium=feed)

Skip the 100-shortcut cheat sheets. These seven VS Code shortcuts, in the order to learn them, cover most of your day. Start with the Command Palette.

6 min read · [systemcraftpress.hashnode.dev](https://systemcraftpress.hashnode.dev/the-only-vs-code-shortcuts-worth-learning-first?utm_source=hashnode&utm_medium=feed)

[Oct 16](https://hashnode.com/posts/the-only-vs-code-shortcuts-worth-learning-first/6ad190a3f4f0823e828465a9)
