Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

But you can do that. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE (or REPEATABLE READ) in the sessions doing your financial transactions, and in the sessions doing your chat message set READ UNCOMMITTED (and AUTOCOMMIT ON if you fancy). Easy. This feature has been around at least since the 90s in Sybase and its descendants.


Sure, but you can't take advantage of that looseness to scale a collection across a crapton of cheap nodes, either.

(Which would be the main driving factor for abandoning ACID in the first place.)




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: