Database Storage in Flutter using SQFlite

Persistent data storage is an important topic in mobile development. Both Android and iOS can take advantage of SQLite, a lightweight SQL database. Sqflite is flutter library to tap into that power on both platforms. This tutorial will walk you through the basic CRUD data operations (Creating, Reading, Updating, and Deleting) using the Sqflite library.

00:00 - Intro
00:36 - Reviewing initial code without Sqflite
04:52 - Creating and opening the database using the Singleton pattern
14:00 - Mapping your database column names to your model fields and vice-versa
17:57 - Writing a function to retrieve all rows from a database table and mapping the results to the model
21:47 - Writing a function to insert a row into the database
23:38 - Retrieving all rows of the table when the list widget initializes and setting the bloc data
26:30 - Inserting a new row and updating the bloc data
29:13 - Test inserting foods and debugging
31:22 - Writing a function to delete a row(s) in the database
33:15 - Writing a function to update a row(s) in the database
34:57 - Deleting a food from the database and updating the bloc
37:39 - Updating an existing food in the database and updating the bloc

💻Get the Code: https://github.com/theflutterfactory/...

⚡Connect on Facebook:   / flutterfactory  

⚡Connect on Twitter:   / flutterfactory  

Music: www.bensound.com