Cupboard lets you get started using a SQLite database in just a few simple steps. Learn what those steps are in this video.
- [Instructor] We're going to add…a database to our sample application, Topsy Turvey.…Previously, we used vanilla SQLite.…This time, we're going to use cupboard,…as our abstraction layer.…The first thing we need to do,…is add the dependency trial build grader file.…Let's go ahead and open that one…up over here in the left panel.…And we'll scroll to the bottom underneath,…where we have our db inspector dependency…and we'll go ahead and add the dependency for cupboard.…
So I'll type compile, single quotes…and then it's nl.qbusict:cupboard…and the version is 2.2.0…Let's go ahead and sync our project.…Now we have access to the cupboard classes.…The next thing we need to do is update our model objects…to adhere to the structure required by cupboard.…
Let's open them up now.…Recipe in recipe step.…First recipe, and then RecipeStep.…We'll start with the recipe class.…We need to change the ID field to the boxed version of long.…Here on line seven, we'll just change that…lowercase l to a capital L and then the name…needs to be changed to _id.…
To begin, Annyce Davis reviews using the de facto data persistence solution available on Android: SQLite. She takes you through basic SQLite concepts—such as how to create a database wrapper and insert data into a table—as well as a few more advanced topics. Next, she covers working with Cupboard, an open-source project dedicated to simplifying your SQLite interactions. To wrap up, she dives into working with Realm, an object database solution designed with mobile devices in mind. Throughout the course, Annyce discusses establishing relationships between database tables, creating and running queries, as well as performing data migrations.
- Overview of SQLite
- Defining a database table's schema
- Exploring SQLite create table syntax
- Executing create table statements
- Inserting data with a foreign key relation
- Inspecting the database using a terminal
- Updating and deleting records
- Working with Cupboard
- Working with Realm
Skill Level Intermediate
Android App Development: Unit Testingwith James P White2h 59m Intermediate
1. SQLite Basics
2. SQLite Beyond the Basics
3. Working with Cupboard
4. Realm Basics
5. Realm Beyond the Basics
- 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.