Top iPhone SQLite Resources

Yesterday I talked about iPhone Sqlite vs. Core Data.  I forgot to mention one other benefit of using SQLite which is being able to use the SQL language to execute database queries.  As I’m not a SQL specialist this wasn’t something that I thought of.

Now, I got a couple of e-mails about using SQLite so I’m going to tell you about my top 3 iPhone SQLite resources.

1. FMDB – This is an excellent library for using SQLite on the iPhone.  I highly recommend using this library if you really want to use SQLite instead of core data.

2. SQLite’s Quick Start Guide – This is a very straightforward guide on using SQLite, written in C, and I highly recommend it if you’re not going to use FMDB.

3. SDK Article’s SQLite Series – Some great tutorials that I originally used to learn how to use SQLite on the iPhone.  Very good stuff.

These resources should be enough for you to use iPhone SQLite, I hope that this was a help to those of you needing more.  If not post a question below in the comments if you need more specific help.

DeliciousTwitterTechnoratiFacebookLinkedInEmail

Submit A Resource

Have you created a useful tutorial, library or tool for iOS development that you would like to get in front of our 300,000+ monthly page views from iOS developers?

You can send a Tweet to @maniacdev on Twitter or submit the url here.

The resources we feel will appeal to our readers the most will be posted on the front page.

  • nfs3250

    Hey thanks for info. I used FMDB but somehow i can’t run my application. My application doesn’t hv any errors. Can u take a look at my code? If yes then i will give u link

  • John

    What is the error?

  • Matthew

    I have started using another SQLite library in my projects, which allows me to build SQL queries quickly and has a nice DAO to manage the sqlite C functions. The link is https://github.com/ziminji/objective-c-sql-query-builder

  • https://github.com/mirek/CoreSQLite3 Mirek

    Also check out https://github.com/mirek/CoreSQLite3 – it’s sane sqlite3 framework for iOS