Flutter SQLite Database

Flutter SQLite Database, available at $49.99, has an average rating of 4.3, with 51 lectures, based on 17 reviews, and has 98 subscribers.

You will learn about Flutter SQLite Drift State Management Provider Database Migration Table Relation This course is ideal for individuals who are Anyone interested in Flutter It is particularly useful for Anyone interested in Flutter.

Enroll now: Flutter SQLite Database

Summary

Title: Flutter SQLite Database

Price: $49.99

Average Rating: 4.3

Number of Lectures: 51

Number of Published Lectures: 51

Number of Curriculum Items: 51

Number of Published Curriculum Objects: 51

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will Learn

Flutter

SQLite

Drift

State Management

Provider

Database Migration

Table Relation

Who Should Attend

Anyone interested in Flutter

Target Audiences

Anyone interested in Flutter

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Flutter Advance Course

Lecture 2: 1.Setup Flutter Project

Lecture 3: 2.Setup Material Route

Lecture 4: 3.App Navigation and TextFormField

Lecture 5: 4.Extract TextFormField Widget

Lecture 6: 5.Setup Date Picker

Lecture 7: 6.Custom Date Format.mp4

Lecture 8: 7.Refactor Date Picker Form Field

Lecture 9: 8.Create Database Table

Lecture 10: 9.Create Database

Lecture 11: 10.Write Database Query

Lecture 12: 11.Insert Employee To Database

Lecture 13: 12.Dispose Database and TextEditingController

Lecture 14: 13.Get Employee List

Lecture 15: 14.Card Design

Lecture 16: 15.Get Single Employee

Lecture 17: 16.Update Employee

Lecture 18: 17.Delete Employee

Lecture 19: Employee Stream Method

Lecture 20: 18.Form Validation

Lecture 21: 19.Bottom Navigation Bar

Chapter 2: Provider State Management

Lecture 1: 20.Singleton Using Provider Package

Lecture 2: 21.Create ChangeNotifier – I

Lecture 3: 22.Create ChangeNotifier – II

Lecture 4: 23.ChangeNotifierProxyProvider

Lecture 5: 24.Provider context.watch

Lecture 6: 25.Context.watch vs Context.select

Lecture 7: 26.Provider context.read

Lecture 8: 27.Provider addListener

Lecture 9: 28.More on Provider read – watch – select

Lecture 10: 30.Provider Consumer Widget

Lecture 11: 31.Provider Selector Widget

Chapter 3: Database Migration

Lecture 1: 32.Add New Column

Lecture 2: 33.Add Employee

Lecture 3: 34.Get Employee Detail

Lecture 4: 35.Fix Checkbox State

Lecture 5: 36.Update & Delete Employee

Lecture 6: 37.Fix Material Banner.mp4

Lecture 7: 38.Fix Delete Error Message

Chapter 4: Table Relation

Lecture 1: 39.Address Table And Migration

Lecture 2: 40.Create Address Screen

Lecture 3: Address Query

Lecture 4: Address ChangeNotifier

Lecture 5: Address ChangeNotifierProxyProvider

Lecture 6: Insert Address Method

Lecture 7: Provider Listener

Lecture 8: Fix No Table Found Exception

Lecture 9: Address Screen

Lecture 10: Address By Employee

Lecture 11: Delete Address and Employee

Chapter 5: Source Code

Lecture 1: Project Source Code

Instructors

Richard Dewan
Never Stop Learning

Rating Distribution

1 stars: 1 votes

2 stars: 4 votes

3 stars: 1 votes

4 stars: 4 votes

5 stars: 7 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!