In searching for something else I came across this: <http://beets.radbox.org/blog/sqlite-nightmare.html>
I don't like the fact that it's undated. For all I know this is about a three year old bug which has long since been patched. I understand the description, but not what SQLite does internally, and I don't know whether it was ever reported to the SQLite dev team. Would someone like to take a look ? Simon.