Join David Gassner for an in-depth discussion in this video Creating a new SQLite database, part of Android App Development: Local Data Storage (2013).
So far in this course, I focused on two major ways of saving data locally in an Android app.…I've described how to use shared preferences to store simple key value pairs and…how to create and read files in internal and external storage and how to use…particular formats such as JSON and XML that are really useful for storing…structured but not strongly-typed data.…You will find, however, that many Android apps need more power.…You might need the ability to store strongly-typed data or the ability to have…multiple tables that you can relate to each other at runtime.…
For these purposes, there's nothing like a relational database.…Fortunately, the Android SDK incorporates SQLite.…SQLite is a very powerful third- party open source database engine.…You can find out everything about the raw SQLite product at this website,…www.sqlite.org, but everything you really need is included in the Android SDK,…including all the libraries that make up the Android engine, all of the classes…and interfaces you need to program with it, and all of the documentation.…
- Exploring local data storage options
- Creating an Android virtual device
- Starting a new project
- Defining preferences with Java and activities
- Creating and reading JSON and XML data files
- Creating a new SQLite database
- Inserting and retrieving data in the database
Skill Level Intermediate
1. Getting Started
2. Using Application Preferences
3. Using Internal and External File Storage
4. Working with SQLite Databases
5. Managing and Displaying SQLite Data
Improving the data display9m 29s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.