@sherman: Sometimes, you gotta get your hands dirty
. (I'd trust @frostschutz on that one, he has much more experience playing with that than me, I was just throwing wild 3AM ideas around ^^).
And I definitely get the impulse about metadata, I had the same one when I started working on KFMon, until I started actually looking into it, and I realized that: wait, that's not how SQLite works
.
Hence the insane bit of db_update code that's still in there, disabled by default, but sitting pretty, waiting to trap unsuspecting users into trashing their db (... or hitting a write lock timeout, most likely
).
At least the switch to WAL got rid of the *read* locks, because *that* was fun...