ztorkelson

8 ms·

1. 31.▲
   by ztorkelson 9y ago

   Right. The idea is that by having your database, message queue, and application all share the same transactional context, "reprocessing" the message twice doesn't matter, because the effects are only ever committed exactly on
2. 32.▲
   by ztorkelson 10y ago

   Well, first: to properly implement OCC, you need to validate not just your write set (as implemented in some ORMs) but also your read set. Otherwise you're only addressing write-after-write anomalies, leaving write-after-read unaddress
3. 33.▲
   by ztorkelson 10y ago

   Which features of postgres which aren't present in MySQL would you not want to live without? Here's a few: 1. Check constraints. 2. INTERSECT and EXCEPT operators. 3. Common table expressions. 4. Sort-merge join. 5. Serializable