Stop Putting State in Your Database Tables
AI features
- Views
- 3.2M
- Likes
- 6.8K
- Reposts
- 1.1K
- Comments
- 42
- Bookmarks
- 7.9K
TL;DR
This article explains the pitfalls of storing state in database columns, arguing that state is derived information rather than a fact. It proposes recording events or splitting tables by state to preserve history and simplify queries.
Reading the ENGLISH translation
