On: Migrating 1200 databases from MySQL to Postgres

[cntlzw]

How concurrent is that? Can't imagine how writing to the file is even achieved.

[zimpenfish → cntlzw]

"Badly". At least once a week someone managed to overwrite a change another client had just made. When I left, they were running a cron to copy it every minute as a "quick restore" when it happened.

[shoo → cntlzw]

maybe there is an email thread shared between all clients for acquiring / releasing the write lock on the xml file

[K-Wall → shoo]

Semaphore as a service Slack Chat bot.

[noir_lord → K-Wall]

Seen that.

Shared drive with excel files, people would shout at each other to 'release the lock'

[zimpenfish → noir_lord]

Yeah, first real job had the customer database as a VB frontend onto an Access file shared over {whatever Win95 was using in 1996-97}. After a few snafus, the CS / Sales people learned that they had to single-task with the database.