Tagged with

2 articles found

The Silent Data Wipe: Why Your PATCH API is a Time Bomb

Exploring the dangerous simplicity of nullable fields and comparing field-presence flags, JSON Patch, and wrapper types for safe state mutation.

#data-integrity

constraints

Database Constraints: The Features You’re Too Scared to Use (But Shouldn’t Be)

EXCLUDE and CHECK constraints sit in PostgreSQL like power tools gathering dust. Are they underused gems or overengineered footguns? The answer depends on how much you trust your data to outlive your code.

#constraints#data-integrity#database-design...