EF Core with SQLite: worth the effort? : r dotnet - Reddit Even the Sqlite folks call this out as a downside to using WAL mode: There is an additional quasi-persistent "-wal" file and "-shm" shared memory file associated with each database, which can make SQLite less appealing for use as an application file-format
Use cases for SQLite : r learnprogramming - Reddit SQLite is for when it is fine to store the data in a single file locally on the machine the program is running on but the data is structured and you want it to remain structured
SQLite: Code Of Ethics : r linux - Reddit The founder of SQLite and all current developers have pledged to follow spirit of The Rule to the best of their ability They view The Rule as their promise to all SQLite users of how the developers are expected to behave in community This is a one-way promise, or covenant