Alones world

Mobile Orchard에서 11가지 괜찮은 SQLite 자료들을 모아놓은 것이 있어서 포스팅 한다.

Core Data가 3.0에서 등장하면서 SQLite를 대체하고 iPhone에 (특히 TableView에) 진정한 MVC를 이루는 것처럼 보인다 (머 사실이지만).

하지만 Core Data는 SQLite에 비해 (새로운 것이라서 더) 진입 장벽도 있고 Core Data 자신도 pre population data set (한글로 무엇이라고 할까? 초기 데이터 값들?)을 위해서 plist, xml와 함께 SQLite를 쓰고 있으니.. (Apple Dev Center의 주요 Core Data Sample들도 그러고 있으니..),  대체라기 보다는 Object DB형태의 Wrapper 정도로 보는 것이 좋을 수도 있을 것 같다.

Entropydb와 같은 괜찮은 objc lib도 소개되고 있다.

서론이 길었다. 아무튼 SQLite의 11개 자료는 아래와 같다.

Tutorials

iPhone SQLite Database Basics by Lee Falin is a comprehensive introduction to using SQLite in respect to iPhone application development. He covers SQLite database creation and iPhone specific database design considerations well. Lee’s tutorial has lots of screenshots and he takes a step-by-step approach that’s easy to follow. He walks through creating an SQLite database from scratch (on the desktop to start with) and then imports that into an XCode project. Bear in mind, however, that Lee’s tutorial is not about the actual coding necessary to use SQLite on the iPhone itself.

Reading data from a SQLite Database by Dean Collins is a wonderful “start to finish” tutorial that covers creating an SQLite database, creating an XCode project, and then all the code necessary to use that database within an iPhone app. There’s even a link to an archive of the code used in the tutorial so you can more quickly try it out for yourself.

SQLite Tutorial 1: Selecting Data by Jai Kirdatt is the first in five SQLite focused tutorials from the aforementioned author. This one covers creating an SQLite database and, like Dean’s tutorial above, using that database from Objective C. There’s more code and less screenshots than in the aforementioned tutorials, so this tutorial is worth coming to once you’re totally confident with the basics. Source code is available to download at the bottom of the post.

SQLite Tutorial 2: Deleting Data by Jai Kirdatt follows on nicely from the previous tutorial and quickly demonstrates how to delete rows of data from an SQLite database.

SQLite Tutorial 3: Adding Data by Jai Kirdatt demonstrates how to add data to an SQLite database from Objective C.

SQLite Tutorial 4: Loading Data As Required by Jai Kirdatt shows how to select rows in a database to then display in a detail view. Data is only loaded when it is required.

SQLite Tutorial 5: Updating Data by Jai Kirdatt shows you how to update the database when fields on a form are edited and the application is then terminated.

Libraries

EntropyDB is an embedded object database for OS X 10.5 and iPhone OS written in Objective C that’s built on top of SQLite. It provides a nicer API than that offered by SQLite directly. You don’t need to use SQL at all, but instead just work with Objective C objects!

SQLitePersistentObjects allows you to call “save” on your objects and trust that they will be saved properly and can be easily reloaded in future. No SQL required.

FMDB is a library that acts as a wrapper around SQLite – inspired by JDBC. fmdb-migration-manager (originally by last week’s podcast interviewee – Dr Nic Williams) allows you to easily roll out database migrations using fmdb.

iPhone SQLite Persistence for Objects is an open source project that lets you add “object persistence” to your applications. The object persistence uses SQLite, and the library works on both the iPhone and iPod Touch.

Ref: 12 SQLite Resources for iPhone Developers

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.