Join David Gassner for an in-depth discussion in this video Accessing a database from the command line, part of Android App Development: Local Data Storage (2013).
The Android Emulator is packaged with a valuable application that you can use to…explore a database that's on the Emulator.…It's called SQLite3, and I'll show you how to use it here.…I'm running the application, and the Emulator is live.…That's the first thing you need to do before you try to explore the database.…Then go to a Command window. I'm working on a Mac, so I'll use Terminal.…If you're working on Windows, you can run the CMD Command.…
The first step is to go to the folder that contains your Android SDK.…I installed the ADT Bundle and the SDK on my desktop.…So, starting from my Home folder, I'll change first to the Desktop folder, and…from there to the ADT Bundle folder Mine is called adt-bundle-mac,…butt if you're working on Windows, it will have a different name.…And then from there, I'll switch to sdk subfolder.…I'll list the contents of the SDK. You want to change to the platform Tools folder.…
I'll type cd, then platform- and I'll press Tab, and Terminal auto-completes the name of the folder.…
- 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.