This article by Anton Zhiyanov makes a lot of the points about SQLite that I'd like to make to people who haven't seriously considered it. There are other things too, but it's a good overview.