It has been quite a while since I mentioned SQLite databases on this blog.
FMDB is a high level Objective-C wrapper for SQLite, and I’ve come across an excellent tutorial demonstrating how to perform the basic CRUD (create, read, update, delete).
What I like about this tutorial is that it goes through every step from building the database from the command line, adding the database in your apps, and each of the CRUD functions while building a simple app.
The tutorial is from Azam Sharp and you can find it here.
FMDB now has a Github repository which you can find here.
If you are looking for an easy and free editor for editing SQLite databases rather than using the command line as shown in the tutorial I suggest checking out the Firefox plugin SQLite manager.