3 ms·
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?
by edoceo 3mo 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?
- frollogaston 3mo agoRight, 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.
- jvidalv 3mo agoFor games is a must have.
- frollogaston 3mo agoIf there's a high frequency of changes from a single user all being stored, probably need more specific approaches like that