Introducing SQLite for Mobile Developers

CHAPTER 3

Using SQLite Basics: Storing and Retrieving Data

SQLite is a lightweight library containing a database engine that lets you use a very large subset of SQL to store and retrieve data. As a user, you are most likely to be familiar with an application interface or the interface of a database management system (DBMS) that provides an interface to the database itself. Behind the scenes, your commands (whether text or graphical) are translated into SQLite syntax.

This chapter shows you the basics of creating a table, adding data to it, and retrieving that data. It’s a high-level overview to give you a taste of SQLite. The next chapter will ...