SQLite Forum

What does, if many threads and/or processes need to write the database at the same instant, mean?
Login
Di you read the rest of the statement?

> SQLite only supports one writer at a time per database file. But in most cases, a write transaction only takes milliseconds and so multiple writers can simply take turns. SQLite will handle more write concurrency that many people suspect.

And it continues on.

> but I don't quite understand if the above will cause a problem in my case.

Have you considered simulating what your application would do with 500k visits with reads/writes? This will give you an idea if you can use SQLite.