"what happens with collisions? when two databases update the same record It's a race condition solution? solve it at the application layer " I suspect this is

"what happens with collisions? when two databases update the same record It's a race condition solution? solve it at the application layer " I suspect this is a deal breaker for many. It certainly is for me.