Skip to Content
Head First Android Development
book

Head First Android Development

by Dawn Griffiths, David Griffiths
June 2015
Beginner to intermediate
732 pages
17h 32m
English
O'Reilly Media, Inc.
Content preview from Head First Android Development

Chapter 11. SQLite Databases: Fire Up the Database

image with no caption

If you’re recording high scores or saving tweets, your app will need to store data. And on Android you usually keep your data safe inside a SQLite database. In this chapter, we’ll show you how to create a database, add tables to it, and prepopulate it with data, all with the help of the friendly SQLite helper. You’ll then see how you can cleanly roll out upgrades to your database structure, and how to downgrade it if you need to pull any changes.

Back to Starbuzz

Back in Chapter 6, we created an app for Starbuzz. The app allows users to navigate through a series of screens so that they can see the drinks available at Starbuzz.

image with no caption

The Starbuzz database gets its drink data from a Drink class containing a selection of drinks available at Starbuzz. While this made building the first version of the app easier, there’s a better way of storing and persisting data.

Over the next two chapters, we’re going to change the Starbuzz app so that it gets its data from a SQLite database. In this chapter, we’ll see how to create the database, and in the next chapter, we’ll show you how to connect activities to it.

Android uses SQLite databases to persist data

All apps need to store data, and the main way you do that in Androidville is with a SQLite database

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Head First Android Development, 3rd Edition

Head First Android Development, 3rd Edition

Dawn Griffiths, David Griffiths
Head First Android Development, 2nd Edition

Head First Android Development, 2nd Edition

Dawn Griffiths, David Griffiths

Publisher Resources

ISBN: 9781449362171Errata Page