Search code examples
iphonesqlitefmdb

Is there a tutorial about how to use FMDB, the sqlite3 wrapper class?

The FMDB page just offers the cvs checkout. Maybe someone out there wrote a good tutorial on how to use FMDB with sqlite3 on the iphone?

Solution

  • The source is the documentation, apparently.

    The question, though, is why aren't you using Core Data?

    Gus effectively compiled FMDB for the iPhone because Core Data wasn't available. Now that it is (as of 3.0), the need for FMDB is diminished.

    Obviously -- if you need code portability, then the direct sqlite APIs are likely the way to go.

    If you need data portability, then a wrapper like FMDB is probably the right answer.

    If your portability is achieved through fully native apps with a client/server data flow architecture (which will offer the best per-device user experience, though at a potentially greater development cost), then Core Data is typically the best answer on iOS.