3 ms·
If you are blindly doing multi-threaded connections without understanding the implications, you also risk corrupting the database entirely. This is false? SQLi
by RedShift1 4y ago
If you are blindly doing multi-threaded connections without understanding the implications, you also risk corrupting the database entirely.
This is false? SQLite has always been able to handle multiple processes and threads, reading and writing to the same database?
- napsterbr 4y ago> SQLite has always been able to handle multiple processes and threads This is true for the vast majority of cases, although there's at least one documented scenario where using modern SQLite coupled with an old threading implementation (the one that predates NPTL in Linux) may lead to database corruption. I guess that's why I said "blindly": as a way to incentivize OP to look this up. It's not that the SQLite database is fragile, but rather that it expects to be used in a certain way, and if you don't, you risk corrupting it.