Flutter Local Storage With Sqlite & Drift

Master Persistent Data, CRUD Operations, and Advanced Database Techniques for Your Flutter Projects

What you'll learn

MVVM

Flutter

Drfit

Riverpod

SQLite

Requirements

Basic of Dart and Flutter

Description

Unlock the power of local data storage in your Flutter applications with this comprehensive course on Flutter Local Storage with SQLite & Drift. Moving beyond basic state management, you'll learn to Master Persistent Data, CRUD Operations, and Advanced Database Techniques for Your Flutter Projects, building robust and efficient offline-first applications.This course is designed for Flutter developers looking to implement reliable and scalable local databases. We'll start by exploring the fundamentals of SQLite, then quickly dive into Drift (formerly Moor), a modern, type-safe persistence library that simplifies database interactions. You'll gain hands-on experience with:Setting up and configuring SQLite databases with Drift.Performing all CRUD (Create, Read, Update, Delete) operations with ease.Defining database schemas and handling complex table relationships.Implementing migrations to evolve your database structure seamlessly.Writing efficient queries, both in Dart and raw SQL, leveraging Drift's powerful features.Integrating your local database with your Flutter UI for dynamic data display.Working with the Stream for live data.By the end of this course, you'll have the skills to confidently manage local data, create responsive offline experiences, and build high-performance Flutter apps ready for real-world use cases. Elevate your Flutter development capabilities and add robust data persistence to your toolkit!

Overview

Section 1: Introduction

Lecture 1 MVVM Architecture

Lecture 2 IDE Setup

Section 2: Flutter Project

Lecture 3 Project Setup

Lecture 4 Database And Table Setup

Lecture 5 Setup DAO

Lecture 6 Setup Note Repository

Lecture 7 Setup Note Model

Lecture 8 Setup Note ViewModel

Lecture 9 Create Note View

Lecture 10 Note List View

Lecture 11 Edit Note View

Lecture 12 Implement Edit Note

Lecture 13 Delete and Clear Notes

Lecture 14 Stream

Lecture 15 Table Relation - Foreign Key

Lecture 16 Category DAO

Lecture 17 Category Model and Repository

Lecture 18 Category State and ViewModel

Lecture 19 Category View

Lecture 20 Bottom Navigation

Lecture 21 Database Migration

Lecture 22 Show Category In Task

Lecture 23 Add Category To Note

Beginner Flutter Developer,All Flutter Developer