> but when you have multiple applications writing to the same relations

... then you're doing it wrong.