13.4. Storing Information in a Database

Databases can be an intimidating subject for a developer. Many people will think of enterprise database servers such as Microsoft SQL Server or Oracle. These applications can take time to set up and require constant management. For most developers, a database system like Oracle would be overkill. Apple has included a small compact database engine on the Mac and iPhone. SQLite will provide you with a lot of flexibility with storing information for your application. It stores the entire database in a single file. It is fast, reliable, and easy to implement in your application. The best thing about the SQLite database is that there is no need to perform any installation of software. Apple has taken care of that for you.

SQLite, however, does have some limitations that you should be aware of as a developer.