News for hackers. Stuff that matters.

A comment on Practical Guide to SQL Transaction Isolation. Parent comment

Re:Practical Guide to SQL Transaction Isolation by ivanhoe on Wednesday August 02, 2017 @11:39AM (#14911410)
Reading this article made it much clearer to me why both locks and transactions are needed: https://www.brightbox.com/blog/2013/10/31/on-mysql-locks/
[ Parent | on HN ]
Re:Practical Guide to SQL Transaction Isolation by IgorPartola on Wednesday August 02, 2017 @01:54PM (#14912955)
You absolutely need both. They serve different purposes because transactions provide ACID and advisory locks can be used to provide higher level ordering of application code.
[ Parent | on HN ]