News for hackers. Stuff that matters.
Re:Consider SQLite by chasil on Wednesday December 29, 2021 @03:39PM (#29729710)
If the app is designed correctly, then the thousand employees would write to their own temporary databases, and a background job would pull their changes into the main database sequentially.

If the app is not specifically designed to do this, then SQLite would not be an option.

Re:Consider SQLite by pc86 on Wednesday December 29, 2021 @03:43PM (#29729766)
Serious question, is this just a "how do I get SQLite to work in this scenario?" thing, or is there actually some other benefit to having this sort of data architecture?
Re:Consider SQLite by chasil on Wednesday December 29, 2021 @04:02PM (#29729982)
This can actually relate to SMTP servers using mbox or maildir formats. Maildir is more resistant to corruption, and doesn't rely (as much) on file locks.

https://serverfault.com/questions/564456/what-are-the-practi...

Re:Consider SQLite by rguillebert on Wednesday December 29, 2021 @05:25PM (#29730879)
What's the benefit over just using the main database?