I was ?bitten? by the fact that in SQLite primary keys can contain NULL values. As I understood it, I was certainly not the first person to who this happened. It would not surprise me if there are more deviations that could spell problems for users of SQLite. That is why I think it would be a good idea to add a caveat entry at: www.sqlite.org/about.html
Somewhere in the beginning of the menu and with a font and colour that will spring out, so it would be reasonably certain that people fall for differences between regular databases and SQLite. -- Cecil Westerhof