Node.js, SQL, MongoDB and API design, with an emphasis on the failure modes you only meet in production.
The real trade-offs between session cookies, JWTs, API keys and OAuth — including why stateless JWTs make logout hard and what to do about it.
The TweakPad Team
Resource naming, status codes, pagination, versioning and error shapes — with attention to the choices that become breaking changes if you get them wrong.
The TweakPad Team
Why streams exist, the four types, and how pipeline() fixes the error handling and back-pressure bugs that pipe() leaves you with.
The TweakPad Team
Compound index ordering, the ESR rule, covered queries, and how to read explain() output to confirm an index is actually being used.
The TweakPad Team
The embed-versus-reference decision, the 16 MB document limit, and five schema patterns that solve the problems normalisation would have solved in SQL.
The TweakPad Team
How to diagnose a slow query with EXPLAIN ANALYZE, the index rules that matter, and the eight query patterns that defeat indexes.
The TweakPad Team
What each join type returns, why LEFT JOIN with a WHERE clause silently becomes an INNER JOIN, and how row multiplication inflates your aggregates.
The TweakPad Team