Topics
Check out the topics that interest you.
PostgreSQL
The database that keeps saying yes: JSONB, window functions, extensions, and the tricks that make it run like it has more cores than it does.
MySQL
The workhorse behind half the web. Queries, quirks and storage-engine lore for keeping it quick, correct and out of the pager.
SQLite
An entire database in one file. Hacks for scripts, tests, mobile and the surprising number of production apps that never need more.
MongoDB
Documents, aggregation pipelines and schema choices, plus an honest word on when a table would have served you better.
Redis
Microsecond memory next to your database: caches, queues, counters and leaderboards, and how not to lose them on a restart.
SQL Server
T-SQL craft for Microsoft's database: execution plans, tempdb, deadlocks and the maintenance jobs that earn their keep.
MariaDB
The MySQL fork that grew its own personality. What carries over, what quietly changed, and the features only it has.
Oracle
PL/SQL, optimizer hints and enterprise oddities, translated into plain English for developers who inherit one.
Supabase
Postgres with a backend bolted on: row level security, auth, realtime and edge functions, seen from the SQL side.
DuckDB
Analytics with no server in sight. Point SQL at CSV, Parquet and JSON files and get answers in seconds.
ClickHouse
Column-store speed for billions of rows: table engines, ingestion and queries that scan a year of events before your coffee cools.
Snowflake
Warehouse tactics for the cloud data platform: costs under control, clustering, semi-structured data and time travel.
BigQuery
Serverless analytics at petabyte scale. Partitioning, slot costs and SQL patterns that keep the bill as small as the result.
DynamoDB
Single-table design, partition keys and capacity maths for AWS's key-value store, where the access pattern comes first.
Performance
Why the query is slow, and what to change about it. Execution plans, statistics, caching and rewrites, with the numbers to prove it.
Indexing
The right index turns minutes into milliseconds; the wrong one taxes every write. Learn which is which, and when to drop them.
Data Modeling
Schemas that age well: keys, normalization, constraints and the shortcuts you will regret in a year.
Transactions
Isolation levels, locks and deadlocks, explained by what goes wrong when two writers meet in the same row.
Security
Stop injection, trim privileges, encrypt what matters, and keep the data out of places it should not be.
Administration
Backups you have actually restored, replicas that keep up, upgrades without drama, and a database that stays healthy.
Migrations
Change the schema while the site is live: expand-and-contract, backfills, and moving data between engines.
Data Analysis
Answers from raw rows: aggregates, cohorts, funnels, time series, plus the string and text wrangling that precedes every report.
Data Wrangling
Take messy CSV, JSON and spreadsheets and land them in tables without losing a row or a character on the way.
Debugging
Decode the error message, find the real culprit, and prove the fix. Detective work for the wrong result.
Scripting
Shell one-liners and small scripts that turn your repeated database chores into a single command.
Tooling
Clients, formatters, linters and CLIs worth installing. Small tools that save hours.
CSV
The format everyone exports and nobody specifies. Delimiters, quoting, encodings and loading it into a database intact.
JSON
Nested, loosely typed and everywhere. Query it, flatten it, validate it and store it without losing what the nesting meant.
XML
Older than half the tools that still emit it. Namespaces, XPath and getting rows out of feeds and exports.
YAML
Config files that look friendly until the indentation bites. Parsing it, linting it and avoiding its type surprises.
Excel
Where the business keeps its data. Reading workbooks, taming dates and formulas, and moving sheets to and from a database.