Flutter SQLite Database

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.