"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.