4 ms·
You can’t do concurrent writes to SQLite, from what I understand. And as you mentioned, at the table level and not just row level. If you have multiple writes,
by ozzythecat 5y ago
You can’t do concurrent writes to SQLite, from what I understand. And as you mentioned, at the table level and not just row level. If you have multiple writes, presumably you’d have to move them to a queue, maybe with a dedicated writer thread. Ops post mentions serializing, which probably is saying this same thing.
I’ve only used SQLite for some hacking/toy applications, so not sure if others have more insight. Would love to learn.
I do see some advantages with SQLite. I imagine back up is super easy - just copy the whole file.