The Schemaless Fiction Architecture 🗃 Latency 45/100 Pain 85/100 Maintain 20/100 Resume MODERATE > "Relational databases are legacy. We need flexibility and scale. A document store lets us iterate without being held back by a schema." ★ The Phantom Transaction A payment write succeeds but the balance update in a separate collection does not. The customer's money is now in quantum superposition.
Analysis The CAP Theorem is a real thing, but reading it once on a blog post does not qualify as database architecture. The decision to use a document store in a domain full of entities, relationships, and transactions is usually made with the best intentions and regretted at the first audit — by someone who assumed ACID was optional. The “flexibility” of a schema-free database is, in a transactional domain, indistinguishable from chaos. After 18 months of “iterating fast,” the orders collection contains 14 different document shapes, 3 of which are undocumented, and one that nobody dares touch because the developer who created it has since left. The Reality: Your business truth escaped the database and is now loosely maintained by application code, nightly repair jobs, and the collective memory of whoever is still on the team. Every cross-entity query is now a cascade of individual lookups stitched together by hand — what used to be a single JOIN is now six roundtrips, two caches and a prayer. Referential integrity is a “team convention” enforced by a comment in a Confluence page last updated in 2023. The regulatory auditor asking for a consistent point-in-time snapshot of all account balances is still waiting for their answer.
🚨 New pattern at worstofbreed.net: The Schemaless Fiction.
Swapping ACID compliance for the "freedom" to break your data model in 14 different ways. If referential integrity is managed by wiki pages, you don't have a database; you have a crime scene.
worstofbreed.net/patterns/sch...
#worstofbreed