News for hackers. Stuff that matters.

A comment on The Slotted Counter Pattern. Parent comment

Re:The Slotted Counter Pattern by LesZedCB on Monday August 01, 2022 @12:56PM (#32308917)
wouldn't that break the atomic and isolated rule of ACID?
[ Parent | on HN ]
Re:The Slotted Counter Pattern by samatman on Monday August 01, 2022 @02:04PM (#32309880)
Not necessarily. If both updates are in a single transaction then it's valid for the query planner to batch them, although that seems unlikely in the use case this table layout is designed for.
[ Parent | on HN ]
Re:The Slotted Counter Pattern by MauranKilom on Monday August 01, 2022 @04:30PM (#32311646)
Not any more than the slotted counter pattern...
[ Parent | on HN ]
Re:The Slotted Counter Pattern by LesZedCB on Monday August 01, 2022 @07:24PM (#32313413)
how does the shape of data impact the storage applications safety contract?
[ Parent | on HN ]