Comment by edoceo
9 hours ago
What's wrong with select for update? I've found it useful in a few places. It is that fixed when there is an append only source of truth?
9 hours ago
What's wrong with select for update? I've found it useful in a few places. It is that fixed when there is an append only source of truth?
Right, that whole class of problems mostly goes away when you're not mutating your sot. I've actually never needed to use SELECT FOR UPDATE that I can think of.
It does have its legitimate uses, but there are footguns that general SWEs not super familiar with DBs won't know about, like how it still doesn't prevent all types of race conditions unless you're in SERIALIZABLE mode.
For games is a must have.
If there's a high frequency of changes from a single user all being stored, probably need more specific approaches like that