How-to guides

Practical articles for developers — workflows, tooling, and techniques you can use today. Each guide is organized with clear headings, context for why steps matter, and copy-paste commands where it helps.

Redis for app developers: strings, hashes, TTL, eviction

Databases & SQL Intermediate 6 min read

Practical notes for shipping software.

Redis for app developers: strings, hashes, TTL, eviction — Redis for app developers: strings, hashes, TTL, eviction — a practical guide for developers, scoped to Databases & SQL at a Intermediate level. You wil…

Shell scripting essentials for developers

Productivity & workflows Intermediate 6 min read

Practical notes for shipping software.

Shell scripting essentials for developers — Shell scripting essentials for developers — a practical guide for developers, scoped to Productivity & workflows at a Intermediate level. You will get vocabulary, a c…

Go: install toolchain, modules, and a small CLI

Languages & runtimes Beginner 6 min read

Practical notes for shipping software.

Go: install toolchain, modules, and a small CLI — Go: install toolchain, modules, and a small CLI — a practical guide for developers, scoped to Languages & runtimes at a Beginner level. You will get vocabulary,…

TypeScript from zero: tsconfig, tsc, and your first project

Languages & runtimes Beginner 6 min read

Practical notes for shipping software.

TypeScript from zero: tsconfig, tsc, and your first project — TypeScript from zero: tsconfig, tsc, and your first project — a practical guide for developers, scoped to Languages & runtimes at a Beginner level. …

Install and use PostgreSQL locally for development

Databases & SQL Beginner 6 min read

Practical notes for shipping software.

Install and use PostgreSQL locally for development — Install and use PostgreSQL locally for development — a practical guide for developers, scoped to Databases & SQL at a Beginner level. You will get vocabulary…

How to Take a Screenshot on Mac

Productivity & workflows Beginner 4 min read

Use built-in keyboard shortcuts and Screenshot.app to capture the full screen, a window, or any region.

Step-by-step guide to screenshots on Mac: Command+Shift+3/4/5, selection and window capture, copy to clipboard with Control, and default save location.

Developer Productivity: Shell Aliases, Functions, and Tiny Scripts

Productivity & workflows Beginner 5 min read

Automate boring terminal work: safe aliases, parameterized functions, and one-file scripts you can commit to dotfiles.

Speed up the terminal: aliases vs functions, Git/Docker one-liners, dotfile organization, and when to reach for Make or a real task runner.

Prompt Engineering for Developers: Structure, Examples, and Guardrails

AI & LLMs Intermediate 6 min read

Write prompts that behave: roles, constraints, output formats, few-shot examples, and failure modes to test.

Improve LLM prompts: clear instructions, examples, output schemas, iteration with eval cases, and safety checks for production features.

JavaScript Debugging with Chrome DevTools (and Friends)

Frontend & debugging Intermediate 6 min read

Breakpoints, async stacks, network replay, and console tricks—fix front-end bugs faster without guesswork.

Master JS debugging: breakpoints, step-through, async stacks, fetch inspection, memory leaks basics, and pairing with Node inspect for full stack.

GitHub Actions CI for Developers: Workflows, Secrets, and Caching

DevOps & infrastructure Intermediate 6 min read

Run tests on every push: YAML structure, matrix builds, encrypted secrets, and faster pipelines with cache.

Set up GitHub Actions: build and test on push, use secrets safely, cache dependencies, and mirror patterns from Git best practices.

Python Pandas for Data Analysis: A Practical Intro

Data & machine learning Beginner 7 min read

Load CSVs, explore DataFrames, filter and group data, and export results—ideal after you have Python installed.

Learn pandas: load tabular data, filter rows, aggregate with groupby, join tables, handle NaNs, and move toward reproducible notebooks.

SQL Query Optimization for Large Tables: Indexes, Plans, and Batching

Databases & SQL Intermediate 7 min read

Speed up heavy queries: choose the right indexes, read execution plans, avoid N+1 patterns, and batch work sensibly.

Optimize SQL on big tables: indexes, EXPLAIN, join order hints, avoiding full scans, keyset pagination, and safe batch operations.