Anyone that does work with SQLite should read this article. Independent of language / framework you are using.

I had to figure most of this stuff out on my own years ago. Thank you for writing this!