Data posts

You write SQL declaratively, but the database engine decides how to execute it. We open up Postgres EXPLAIN to show how query planners actually choose strategies.

Your server already compresses responses with gzip or Brotli — but do you know what those algorithms actually do? Understanding compression helps you optimize assets and set correct headers.

Markdown is how developers write README files, documentation, and issue comments. Learning the full spec — including the extensions that different platforms add — takes under an hour and pays dividends forever.

INI files pre-date the internet as we know it — yet Python's configparser, Git's config, and countless system tools still use them. Here is what you need to know about this enduring format.

JSONL puts one JSON object per line, making it streamable, appendable, and easy to process without loading the entire file into memory. Here is why that trade-off matters.

Normalization rules sound abstract until you see what a denormalized table looks like after six months of updates. This guide explains the normal forms using simple, concrete examples.

An index can turn a ten-second query into a millisecond query — or slow down your writes significantly if misused. Understanding the data structure behind indexes makes both outcomes predictable.

The choice between SQL and NoSQL is not about which is better — it is about matching the data model to your access patterns. Here is a framework for making that decision with confidence.

SQL is one of the most valuable skills a developer can have — and the fundamentals are surprisingly approachable. Start here to write your first real queries confidently.

TOML was designed to be obvious at a glance — a config format with explicit types and no whitespace sensitivity. Cargo.toml made it famous, but it is now used across the ecosystem.

YAML is everywhere in DevOps — Docker Compose, Kubernetes, GitHub Actions, Ansible. Its indentation-sensitive syntax looks clean but has sharp edges. This guide covers the rules you need to know.

CSV files look trivial until you encounter a value with a comma inside it, a newline in a cell, or a file saved in the wrong encoding. This post covers everything you need to handle CSV correctly.

JSON took over the web API world, but XML still powers enterprise integrations, configuration files, and document formats. Here is a clear-eyed comparison to help you choose the right one.