So maybe you’ve been thinking it’d be a good idea to get a leg up on SQLite, since it’s the data management technology of choice on the iPhone and all. Here’s a roundup of resources for you!
For starters, here is an excellent introductory tutorial to SQLite in general:
This article explores the power and simplicity of sqlite3, starting with common commands and triggers. It then covers the attach statement with the union operation, introduced in a way that allows multiple tables, in separate databases, to be combined as one virtual table, without the overhead of copying or moving data. Next, I demonstrate the simple sign function and the amazingly powerful trick of using this function in SQL select statements to solve complex queries with a single pass through the data…
Then, we have a walkthrough tutorial demonstrtating its use with the iPhone SDK:
I see many people asking for SQLite tutorials around, and since I am using SQLite for the next part in the Advanced RSS Reader Tutorial, I thought I would write up a quick tutorial on using SQLite with the iPhone SDK…
And when you want an embeddable library for your desktop and iPhone work, from those Plausible guys we keep mentioning, here’s pldatabase at Google Code:
A SQL database access library for Objective-C, initially focused on SQLite as an application database. The library supports both Mac OS X and iPhone development.
Plausible Database is provided free of charge under the BSD license, and may be freely integrated with any application.
… and if you’re looking for more, more, MORE, here’s a list put together by the guys over at MobileOrchard!
12 SQLite Resources for iPhone Developers
Continue Reading →FEB