Wanting a simple overview on how to connect to a SQLite database in Cocoa/Objective-C
Check out the supremely awesome FMDB. It's an Objective-C wrapper around the C SQLite API and makes it really really easy to deal with SQLite databases in Cocoa.
Oh, and it comes with some documentation and the sample code is pretty easy to understand and is decently commented. Chances are that 99% of anything you'd want to do with a SQLite database are demonstrated in the example.
In my opinion, if you use anything else to access a SQLite database (that's not a CoreData store), you're doing it wrong.
Apple has several Core Data tutorials like this: http://developer.apple.com/cocoa/coredatatutorial/index.html
If you want to use sqlite, just use the sqlite C API:http://www2.sqlite.org/cintro.html
For easy connection to sqlite you must use the next guide!Little class for connection and consulte BD Sqlite
I do a few modify to add NSNull if the select no give items and fix a bug:enter link description here with 4 lines and this class in objetive c you can do all consult easy.