Having worked with sqlite in an enterprise production environment for vehicles many years ago, it's gotten much better over the years. It's also gotten a perfor

Having worked with sqlite in an enterprise production environment for vehicles many years ago, it's gotten much better over the years. It's also gotten a performance boost as everyone now uses SSD's. See Faq for details where they still mention rotational speeds and inserts etc. With WAL mode Sqlite is much much better, in the past we had all kinds of problems with trying to read/write at the same time. At that point in time every table was a separate database as a workaround. https://stackoverflow.com/questions/1005206/does-sqlite-lock-the-database-file-on-reads https://stackoverflow.com/questions/1005206/does-sqlite-lock... https://www.sqlite.org/faq.html#q19 https://www.sqlite.org/faq.html#q19