In this video learn how to delete records from SQLite. Annyce covers how to provide the selection criteria for the records you want deleted, as well as ensuring no records are left orphaned when associated records are removed.
- [Instructor] Deleting records in SQLite…is very similar to modifying them.…Let's say we want to delete all records…in our users table that are active.…We would start by setting up our selection criteria.…Recall that this is just a string that contains…there where portion of our SQL statement.…Next, we would execute the delete method.…Passing in the table name, the selection string,…and, in this case, null, as we don't have any placeholders…in our selection string that we will want to replace.…
Let's say this is our state before we execute the deletion.…Once the previous code is run, this will leave us with only…one record, Joe, as he's the only user in the table…who is not active.…One thing to keep in mind is that if you have…multiple tables associated with each other,…you will need to handle removing all of the records…in each table by yourself.…Otherwise, you will end up with orphaned records…and that's just sad.…
You can, however, configure SQLite to notify you…when you make changes that violate…your foreign key relationships.…
Author
Released
5/4/2017To 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
Duration
Views
Related Courses
-
Android App Development: Unit Testing
with James P White2h 58m Intermediate -
Learning Firebase Cloud Messaging for Android
with Joe Marini52m 49s Intermediate
-
Introduction
-
Welcome1m 50s
-
What you should know1m 12s
-
Review the starting app3m 3s
-
-
1. SQLite Basics
-
Overview of SQLite4m 17s
-
Create a database wrapper8m 49s
-
-
2. SQLite Beyond the Basics
-
Explore SQLite queries3m 11s
-
Query data using a raw query7m 19s
-
Delete records from a table7m 21s
-
3. Working with Cupboard
-
Overview of Cupboard4m 25s
-
Define a database schema9m 9s
-
Insert data into a table3m 24s
-
Update records in a table6m 20s
-
Create a schema migration7m 25s
-
-
4. Realm Basics
-
Introduction to Realm2m 57s
-
Configure a Realm instance5m 10s
-
Create a Realm object class5m 35s
-
Insert data into Realm5m 59s
-
-
5. Realm Beyond the Basics
-
Explore Realm queries5m 6s
-
Query Realm objects7m 58s
-
Explore Realm updates2m 26s
-
Update Realm objects5m 19s
-
Delete Realm objects5m 52s
-
Explore Realm migrations3m 36s
-
Create a schema migration7m 19s
-
Conclusion
-
Next steps43s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Delete records from a table