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?
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?
If the app is not specifically designed to do this, then SQLite would not be an option.