It's live!
This is the first post to the "real" blog running on plausible.org. It will no doubt be removed soon, owing to the fact that it has no meaningful content. But it's real, and live.
The final trick, as I discovered, is that sqlite requires write access to the directory in which the database lives or else it will fail at the first update to the database with "cannot open database file" error. This is odd, given that the database file has already been opened. And especially odd, given that sqlite doesn't actually need write access to the directory to do its job: just the file.
posted by andy on Wednesday 25 October 2006 04:29pm
About the SQLite issue: playing around with strace shows that it does its journaling to an external file, instead of doing the writes within the database file itself. So of course it need directory write access in order to create and delete this thing. Seems silly, but at least it's explained now.