Friday, July 29, 2011

SQLite 101 for iPhone Developers: Creating and Scripting

In this series, we're going to show how to make an app that displays a list of failed US banks from a SQLite database.

In this first part of the series, we will cover what SQLite is and why we'd want to use it, how to use the sqlite3 command-line utility, and how to import data programatically via Python.

In the second part of the series, we will cover how to make an iPhone app that reads data from the SQLite database we created, and display data in a table view and a drill down detail view.

This tutorial does not assume any prior knowledge with Python or SQLite, however it assumes a basic knowledge of SQL.

Original Source...