Flutter SQLite Database

Name: Flutter SQLite Database
Rating: 3.7 (20 reviews)

Build a Flutter Database App with Drift Package and StateManagement with Provider Package

Created byRichard Dewan

Last updated 9/2022

English

What you'll learn

Flutter
SQLite
Drift
State Management
Provider
Database Migration
Table Relation

Course content

5 sections • 51 lectures • 7h 12m total length

Flutter Advance Course2:03
Flutter Advance Course: https://rdewan.dev/flutter-advance-course
1.Setup Flutter Project12:09
2.Setup Material Route12:44
Learn to set up material route navigation in flutter by creating a home screen and an employee screen, wired with a route generator that maps routes and a no-route screen.
3.App Navigation and TextFormField12:50
Learn Flutter app navigation by building an add-employee form with a text form field, controller, and validation, plus decorative outline borders and padding.
4.Extract TextFormField Widget10:23
5.Setup Date Picker11:59
Implement a date of birth picker in a Flutter app by opening a date picker on tap, setting min and max dates around the current date, and formatting the result.
6.Custom Date Format.mp45:26
Fix calendar navigation to return to the selected date and apply readable date formats with the Intel package in Flutter, including adding the dependency and applying the format.
7.Refactor Date Picker Form Field7:16
refactor the date picker form field by creating a custom widget with a text editing controller, label, and a callback for input handling.
8.Create Database Table4:10
Create an employee table in Flutter using Drift for SQLite by defining an employee entity with id auto-increment key and columns for username, first name, last name, date of birth.
9.Create Database8:15
Create and initialize a Flutter SQLite database by establishing a private open connection, locating the app document directory on Android and iOS, and defining an employee table.
10.Write Database Query11:05
Write queries to get, update, and delete records in a Flutter SQLite database. Retrieve all employees or an employee by ID, and perform insert, update, and delete operations using companions.
11.Insert Employee To Database12:47
12.Dispose Database and TextEditingController3:42
Learn to properly dispose a Flutter SQLite database and its TextEditingController instances, closing the database and releasing resources to prevent memory leaks and boost app performance.
13.Get Employee List12:13
Fetch employees from an SQLite database in Flutter using a FutureBuilder, show loading or errors, and display each employee in a card with id, name, and birth date.
14.Card Design5:49
Reformat the card design in Flutter by adjusting elevated borders, border side, width, and radius, set text color and padding, and align content to start while testing color variations.
15.Get Single Employee12:32
learn to open an edit screen from an employee list in a flutter app using sqlite, pass the employee id through routes, and load the employee data for editing.
16.Update Employee4:17
Update the employee record by calling the update entity with the employee id and a wrapped drift value, then validate the form and plan to add delete support next.
17.Delete Employee4:20
Add a delete button on the edit page and wire it to a delete function that removes an employee from the Flutter SQLite database using the employee ID.
Employee Stream Method1:31
Implement a get employees stream to return the list of employee data from the employee table as a stream, using a watch mechanism and avoiding async.
18.Form Validation8:28
Learn how to validate a form in Flutter using a form key and a global key, show error messages for empty fields, and only save when validation passes.
19.Bottom Navigation Bar12:43
Create a two-tab bottom navigation bar on the home screen, defining bottom navigation bar items with icons and labels, and wiring on tap to update index and switch screens.

20.Singleton Using Provider Package13:20
Create a single app database instance with the provider package to enforce a global singleton. Wire disposal and manage add, edit, delete, and stream versus future operations.
21.Create ChangeNotifier - I9:09
Create a change notifier to update the UI on data changes, wiring an RSA employee notifier to the database, exposing an employee list via a stream and listening for updates.
22.Create ChangeNotifier - II12:28
Create, update, and delete employees using a ChangeNotifier-driven workflow in Flutter SQLite, adding and retrieving a single employee, handling errors, and notifying listeners.
23.ChangeNotifierProxyProvider6:50
Explore building a Flutter SQLite database app using ChangeNotifierProxyProvider within a multi provider setup to manage employee data, initialize the database, and dynamically update employee details.
24.Provider context.watch8:40
25.Context.watch vs Context.select16:21
Explain how context.watch and context.select differ in Flutter provider: watch rebuilds on any change, while select rebuilds only when a targeted value changes, boosting performance; add loading indicators.
26.Provider context.read12:27
Learn to use provider's context.read to access a change notifier, listen for updates, and trigger widget rebuilds as employee data changes in a flutter app.
27.Provider addListener9:24
Set up a provider listener using ChangeNotifier to track employee changes (added, updated, deleted) and update the UI when values change, using context.read and provider.of.
28.More on Provider read - watch - select9:30
Learn to choose between watch, select, and read in provider to control widget rebuilds, watch specific fields, and run callbacks without rebuilding the user interface.
30.Provider Consumer Widget5:28
Explore the provider package's consumer widget to access provided data via a builder and rebuild only a portion of the UI, avoiding full widget-tree rebuilds for better efficiency.
31.Provider Selector Widget9:58
Explore the provider selector widget as an efficient alternative to consumer, filtering updates to a selected value and rebuilding only when that value changes, with practical employee data examples.

32.Add New Column6:43
Add a new active column to the Flutter SQLite database and migrate from version 1 to 2, implementing an integer active flag and updating the data model.
33.Add Employee14:38
Add an employee form in the Flutter SQLite database course using a checkbox for active status, default false, converting boolean to 1 or 0 when saving.
34.Get Employee Detail10:17
Add an in-place checkbox to edit an employee's active status, binding a boolean value to the checkbox. Fetch the single employee and use a selector to rebuild the UI.
35.Fix Checkbox State9:08
Fix the checkbox state by using a notifier and selector to rebuild the checkbox when the active value changes, updating context and the employee change notifier.
36.Update & Delete Employee8:09
Explore updating and deleting employees in a Flutter SQLite database, using change notifiers, listeners, and proper disposal to ensure reliable, bug-free data operations.
37.Fix Material Banner.mp46:06
Fix material banner behavior in a Flutter SQLite database app by wiring employee updates and deletions to a change notifier and triggering banners through a listener.
38.Fix Delete Error Message7:08
Learn to fix delete errors in a Flutter SQLite workflow by validating delete results, notifying when no record is deleted, and propagating clear error messages via a change notifier.

39.Address Table And Migration11:28
Create a new employee address entity with auto-increment id, street and country, and cascade delete; perform a two-to-three migration using before open to enable foreign keys.
40.Create Address Screen6:55
Create a new add-address screen in a Flutter SQLite app, wire up form fields and controllers, navigate from the edit employee screen, and save the address linked to an employee.
Address Query5:41
Learn to add and fetch addresses for employees using flutter sqlite database; support multiple addresses per employee, with an employee address table and id-based queries returning a stream.
Address ChangeNotifier12:16
Learn to implement a change notifier for employee address updates using Flutter and SQLite, including inserting addresses, retrieving all addresses via a stream, and notifying listeners.
Address ChangeNotifierProxyProvider4:39
Learn how to add a ChangeNotifierProxyProvider to a Flutter app, wire it into a multi provider, initialize the database, and fetch or add employee address entries.
Insert Address Method3:51
Validate the address form, build an employee address companion, and insert the employee and address fields (street and country) using drift and provider, then call create with error handling.
Provider Listener10:05
Learn how to set up a provider listener for address changes, initialize change notifiers, add listeners, handle errors, and test migrations in a Flutter SQLite app.
Fix No Table Found Exception1:36
Resolve no table found errors in flutter sqlite by increasing the schema version, rerunning migrations, and creating the required table to enable data entry.
Address Screen8:26
This lecture guides building a flutter sqlite database app with an employee address screen, displaying a list of addresses via ListView.builder, and integrating bottom navigation and add address workflow.
Address By Employee10:18
Learn how to display an employee's multiple addresses in a Flutter SQLite database app by wiring a selector, fetching by id, and managing listeners and layout fixes.
Delete Address and Employee4:19
Demonstrates deleting an employee in a Flutter SQLite app and cascading delete of related addresses via a foreign key, with testing, rebuilding, and troubleshooting an address listener error.

Requirements

Basic of Flutter & Dart

Description

In this Flutter course we are going to learn about local data storage using drift package which help us to create and write SQL query more easily, it internally make use of SQLite 3 and work well both with Android and iOS.

We will able learn about Flutter state management using Provider package which is really popular among Flutter developers. We will cover basic to advance state management using Provider package.

By using provider instead of manually writing InheritedWidget, you get:

simplified allocation/disposal of resources
lazy-loading
a vastly reduced boilerplate over making a new class every time
devtool friendly – using Provider, the state of your application will be visible in the Flutter devtool
a common way to consume these InheritedWidgets (See Provider.of/Consumer/Selector)
increased scalability for classes with a listening mechanism that grows exponentially in complexity (such as ChangeNotifier, which is O(N) for dispatching notifications).

Drift is a reactive persistence library for Flutter and Dart, built on top of sqlite. Drift is

Flexible: Drift let's you write queries in both SQL and Dart, providing fluent apis for both languages. You can filter and order results or use joins to run queries on multiple tables. You can even use complex sql features like WITH and WINDOW clauses.
Feature rich: Drift has builtin support for transactions, schema migrations, complex filters and expressions, batched updates and joins. We even have a builtin IDE for SQL!
Modular: Thanks to builtin support for daos and imports in sql files, drift helps you keep your database code simple.
Safe: Drift generates typesafe code based on your tables and queries. If you make a mistake in your queries, drift will find it at compile time and provide helpful and descriptive lints.
Fast: Even though drift lets you write powerful queries, it can keep up with the performance of key-value stores. Drift is the only major persistence library with builtin threading support, allowing you to run database code across isolates with zero additional effort.
Reactive: Turn any sql query into an auto-updating stream! This includes complex queries across many tables
Cross-Platform support: Drift works on Android, iOS, macOS, Windows, Linux and the web. This template is a Flutter todo app that works on all platforms
Battle tested and production ready: Drift is stable and well tested with a wide range of unit and integration tests. It powers production Flutter apps.

Who this course is for:

Anyone interested in Flutter

Flutter SQLite Database

What you'll learn

Explore related topics

Course content

Introduction21 lectures • 2hr 57min

Provider State Management11 lectures • 1hr 54min

Database Migration7 lectures • 1hr 2min

Table Relation11 lectures • 1hr 20min

Source Code1 lecture0

Requirements

Description

Who this course is for: