Achievement unlocked: original SQLite developer emailed me to update my blog post about Unix file locking, to say there's yet another gotcha he just ran into.

http://apenwarr.ca/log/?m=201012#13

Funnily enough, I wrote that post based on reading how sqlite does locking.  So the world has come full circle apparently.