Best SQLite practices on the iPhone

cocoa-touch, iphone, objective-c, sqlite

Solution

I can recommend using FMDB as a nice Cocoa SQLite wrapper.

Problem

What are some best practices to keep in mind when working extensively with SQLite on the iPhone? Tips/tricks/convenience factors all appreciated.

Original source

Related problems