3. An Introduction to SQLite

Previous chapters discussed the basics of general SQL and relational databases. The Android SDK contains a relational database system called SQLite that can be used to store and retrieve an app’s internal data. SQLite is a lightweight database system, making it ideal for use in resource-constrained environments like mobile devices. This chapter discusses some of the features that make SQLite unique when compared to other database systems, and it discusses some of its limitations.

SQLite Characteristics

Unlike larger database systems (MySQL, PostgreSQL, etc.), SQLite does not require a server/client architecture. Instead, it is completely server-less and self-contained. It runs in a single process, making it ideal ...

Get Android™ Database Best Practices 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.