News for hackers. Stuff that matters.
Re:Why SQLite is so great for the edge by mbreese on Tuesday June 06, 2023 @09:16AM (#36212190)
I’m going to take a guess that the rationale is file locking. If you have three separate processes using three separate database files, you can write all the data you want, as fast as you can, without worrying about file locking. SQLite can handle three processes writing at the same time, but it can be faster to do it split into separate files and then merge after the fact.

There are no comments on this comment yet.