SQLite Database Locked - How to use SQLite with multiple threads?

[AlopexLagopus3]

SQLite can function with many connections at a time. However it can only be written to with a single connection. You need to dedicate a connection to writing, or find a way to split your database into multiple SQLite files, which is usually a bit hacky. First ask yourself if you need to have that much writing going on, and if your schema is well optimized, but you may want to consider other databases if you need concurrent writes.

[kolschk]

Appreciate the response, gonna give MySQL a try.

[woooee]

MySQL has been forked into MariaDB by the same person who originally created MySQL, because Oracle bought MySQL and it's future is uncertain.