Digression: what's your usecase for having multiple processes share the same database ? SQLite is not an equivalent to a standard networked database, as a deve

Digression: what's your usecase for having multiple processes share the same database ? SQLite is not an equivalent to a standard networked database, as a developer you're supposed to see it as an enhanced data structure, like an array++. You wouldn't share an array between multiple processes (unless you know exactly what you're doing) so you wouldn't do the same for SQLite. If you really need multiple processes writing the same kind of data, maybe it should be partitioned into multiple independent files ?