scorpionxdev

JavaScript async and await

async / await is syntax sugar over Promises that lets asynchronous code read top to bottom like normal code. Under the hood it is still Promises. The basics …

SQL joins explained

A join combines rows from two tables based on a related column. The join type decides what happens to rows that have no match. Sample tables Say we have user…

TCP Handshake

Question How does it work --- Discussion scorpionxdev (OP) · Aug 8, 2026 asdasdhelfuhfeakdhine scorpionxdev (OP) · Aug 8, 2026 asfweoi;fjuwefaiohwkihaidhaha …

API pagination patterns

When a collection is too big to return at once, you paginate. There are two main patterns and choosing wrong causes real pain at scale. Offset pagination The…

Useful Linux filesystem commands

A compact cheat sheet of filesystem commands I keep coming back to on the terminal. Moving around bash pwd where am I ls -lah long list, human sizes, include…

How caching improves application performance

Caching is storing the result of expensive work so you can reuse it instead of redoing it. Done well it is the highest-leverage performance tool you have. Do…

Kotlin coroutines overview

Coroutines are Kotlin's answer to asynchronous programming. They let you write concurrent code that reads sequentially, without blocking threads. Suspend fun…

Database indexing basics

An index is a sorted lookup structure that lets the database find rows without scanning the whole table. It is the single biggest lever for query speed, and …

Git commands I use every day

A short reference of the Git commands I actually reach for daily. Not exhaustive, just the ones that earn their keep. Checking state bash git status what cha…

Markdown formatting reference

A quick reference for GitHub-Flavored Markdown. The rendered output is on the left in your head; the source is below. Headings markdown H1 H2 H3 Emphasis mar…

How environment variables work

Environment variables are named values that live in a process and get inherited by the processes it spawns. They are the standard way to pass configuration a…

SwiftUI state management

SwiftUI rebuilds views from state. The trick is choosing the right property wrapper so ownership and updates flow the way you expect. The core property wrapp…

React component design principles

A handful of principles that keep React components easy to change. None of them are rules, but ignoring all of them tends to produce components that are pain…