Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
SQLite is a full featured relational database. It's small, it's fast, it's lightweight, and it's perfectly suited for mobile applications. The SQLite Database Management System lives entirely in a driver. This means that there is no server and no client. You access the database directly. The database itself is fully contained in one file. This makes it very convenient to use in a mobile environment. To say that iOS supports SQLite natively is to say that the driver is built-in, the interface to the driver is written in C, so it's not Object Oriented, and it's not an Objective-C Interface.
To make it easier to use, we will build a Native Object Oriented Interface for SQLite in Objective-C. This kind of interface is sometimes called a Wrapper as it wraps one interface around another. It's designed to be convenient and easy for our development purposes. It's general purpose, so you can use it in your future projects. You have the source code, and you may modify it and expand it to suite your needs. To further support the iOS Model-View-Controller architecture, we will build a more specific interface on top of our general interface.
We will do this by subclassing our general interface and adding methods to specifically support this application. This makes it very easy for us to integrate the database into our application. Subclassing a normalized interface like this is a common and valuable technique in an object-oriented environment. As you follow along with the development process in this chapter, think about how you will use and expand on these techniques in your own projects.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 97479 Viewers
61 Video lessons · 84712 Viewers
71 Video lessons · 68907 Viewers
56 Video lessons · 101355 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.