Postgres for App Developers
Not DBA theory — the 20% of Postgres that carries 80% of real apps: schema design, indexing, transactions, the query patterns that matter, and the gotchas that bite in production.
Read guideDatabases, auth, jobs and queues, and server-side foundations.
Not DBA theory — the 20% of Postgres that carries 80% of real apps: schema design, indexing, transactions, the query patterns that matter, and the gotchas that bite in production.
Read guideSessions, cookies, password hashing, and the subtle things people get wrong — a practical, build-along guide to authentication that's secure by default, without reaching for a SaaS.
Read guideThe part of every real app nobody teaches well: workers, queues, retries, idempotency, scheduling, and dead-letter handling — built up from first principles into a system you can trust.
Read guideDirectus has quietly become the first thing I reach for on almost every project — and not just as a headless CMS. Point it at a Postgres database and you get an instant REST and GraphQL API, a genuinely nice admin app your non-technical teammates can actually use, granular permissions, file handling, automation, and realtime — without writing a line of boilerplate. I rarely start an app these days without standing up Directus at some point. This is the guide I'd hand a competent developer who's never run Directus in anger: how to self-host it properly with Docker and Railway, how to model your data, how to lock it down, and how to ship real apps on top of it. _This is a living document and will be updated as Directus updates_
Read guide