Insights
Technical articles on languages, databases, serverless platforms and the awkward realities of keeping systems moving.
Showing 1–4 of 4 Databases articles
A practical PostgreSQL guide to relational modelling, constraints, indexes, transactions, EXPLAIN and keeping persistence behaviour visible in application code.
Read articleA practical guide to functional dependencies, update anomalies, first through third normal form, join tables, historical facts and deliberate denormalisation in PostgreSQL applications.
Read articleThe endpoint gets blamed first. Often the useful evidence is in the query plan, connection pool or data model.
Read articleA flexible store changes the modelling trade-offs. It does not make those trade-offs disappear.
Read articleStart a conversation
A feature that needs shipping, an ageing service that needs attention, or a deployment that has become harder than the code. Talk to us about your problems.