> although ensuring that only a single client is writing to a database at any time is (mostly) left to the application

Sounds like trouble.