Community
Guides, notes, and the writers behind them — everything worth exploring.
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…
scorpionxdevWhen something breaks and I have no idea why, I run through this list before touching any code. It turns panic into a process. 1. Reproduce it reliably A bug…
scorpionxdevA 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…
scorpionxdevWhen 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…
scorpionxdevGlobal Manual Bug Bounty Checklist Purpose: A target-agnostic, manual-first checklist for authorized web, API, SaaS, identity, business-logic, integration, a…
Scorpion X DevCoroutines are Kotlin's answer to asynchronous programming. They let you write concurrent code that reads sequentially, without blocking threads. Suspend fun…
scorpionxdevAn 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 …
scorpionxdevWhat REST really means — resources, HTTP methods, status codes, headers, auth, versioning, pagination, and designing an API people enjoy using.
Curated guide · updated 2026-07-14
Debugging as a repeatable method, not luck — reproduce, isolate, form hypotheses, read the error, bisect, and the tools that make it faster.
Curated guide · updated 2026-07-13
Git from first principles — the mental model, the everyday commands, branching, merging, undoing mistakes, and a sane workflow.
Curated guide · updated 2026-07-12
How to write docs people actually read — knowing your reader, the four documentation types, structure, examples, and keeping docs alive.
Curated guide · updated 2026-07-11
A repeatable system for learning technical skills that actually stick — spaced repetition, projects, notes, and avoiding tutorial hell.
Curated guide · updated 2026-07-10
