How to use SQLite3?

[Shadowraix]

I want to use it to store data i'll be frequently accessing. I've tried looking at documentation, code, and the wiki. They all either give different or confusing examples. I've never actually had to code in any database format so sqlite is new to me. If anybody could help me out in understanding how to use it, or give very simplistic examples I would appreciate it.