I have written several "Use Sqlite!" posts that have made the rounds on hackernews... reading this watered down post, which is devoid of any new, surprising or usable info, it strikes me that repping SQLite has achieved meme status.
If you want tangible info you can actually use, read sqlites documentation. There's a wealth of information there.