26. SQLite

Once upon a time, SQL was created to access data in relational databases. While powerful, SQL required a database infrastructure. One day, Richard Hipp decided to create a library that would store data in tables and store those tables in a file instead of a relational database. With this library, you could use SQL commands to fetch data from the tables without requiring a database server process. You could also use SQL commands to insert, update, and delete rows of data. Dr. Hipp released the code for this library into the public domain and called it SQLite. The SQLite libraries are part of the iPhone OS.

SQLite is a nifty C library. It has great performance and reliability. Both the source for the library and the data files it creates ...

Get iPhone Programming: The Big Nerd Ranch Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.