> The example with follower_count shows how to use the +1 technique to do without locking..
Without explicit pessimistic locking. There are always locks. More guarantees, more locks.
That issue example can be tackled with optimistic concurrency controls depending on the constraints. The issue can be checked out with an UPDATE .. WHERE .. RETURNING ..
Without explicit pessimistic locking. There are always locks. More guarantees, more locks.
That issue example can be tackled with optimistic concurrency controls depending on the constraints. The issue can be checked out with an UPDATE .. WHERE .. RETURNING ..