PostgreSQL anti-patterns: read-modify-write cycles (2014)
I'm glad to see optimistic concurrency control mentioned. In my experience even seasoned developers are unaware of this pattern, which should be really the default in many database-handling code.I'm not aware of ORMs handling it either (except for my in-house code generator). Is there anything out there that handles it well?