Flutter SQLite Database – I – Free Udemy Courses

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

We will be able to learn about Flutter state management using the Provider package which is popular among Flutter developers. We will cover basic to advance state management using the 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 dev tool
• 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 lets 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 built-in support for transactions, schema migrations, complex filters, expressions, batch updates, and joins. We even have a built-in IDE for SQL!
• Modular: Thanks to built-in support for days 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 links.
• 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 built-in 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 the production of Flutter apps.