Summary  
This chapter explains how to define database tables as classes, perform type-safe CRUD operations using an ORM, and leverage reactive data streams to automatically react to data changes.

General domain of usage  
Local data persistence in mobile applications.

**SQLite** is a lightweight, embedded database engine that is widely used for managing structured data directly on a device.

Definition

This video walks you through integrating SQLite with the Drift ORM in your Flutter app. You will see how to define tables, perform basic CRUD operations, and leverage Drift's reactive streams to keep your UI in sync with local data changes.

In **Flutter**, using **SQLite** directly can be verbose and error-prone, especially when handling data models and queries. **Drift** is an Object-Relational Mapping (**ORM**) library for Dart that simplifies working with SQLite by providing type-safe APIs, automatic code generation, and support for reactive data streams. By using Drift, you can define your database tables as Dart classes, write queries in a more natural way, and react to changes in your data efficiently.

Ly8gbWFpbi5kYXJ0CmltcG9ydCAncGFja2FnZTpkcmlmdC9kcmlmdC5kYXJ0JzsKaW1wb3J0ICdwYWNrYWdlOmRyaWZ0L25hdGl2ZS5kYXJ0JzsKaW1wb3J0ICdkYXJ0OmlvJzsKaW1wb3J0ICdwYWNrYWdlOnBhdGgvcGF0aC5kYXJ0JyBhcyBwOwppbXBvcnQgJ3BhY2thZ2U6cGF0aF9wcm92aWRlci9wYXRoX3Byb3ZpZGVyLmRhcnQnOwoKLy8gRGVmaW5lIGEgdGFibGUKY2xhc3MgVG9kb3MgZXh0ZW5kcyBUYWJsZSB7CiAgSW50Q29sdW1uIGdldCBpZCA9PiBpbnRlZ2VyKCkuYXV0b0luY3JlbWVudCgpKCk7CiAgVGV4dENvbHVtbiBnZXQgdGl0bGUgPT4gdGV4dCgpKCk7CiAgQm9vbENvbHVtbiBnZXQgY29tcGxldGVkID0+IGJvb2xlYW4oKS53aXRoRGVmYXVsdChjb25zdCBDb25zdGFudChmYWxzZSkpKCk7Cn0KCi8vIENyZWF0ZSBhIGRhdGFiYXNlIGNsYXNzCkBEcmlmdERhdGFiYXNlKHRhYmxlczogW1RvZG9zXSkKY2xhc3MgQXBwRGF0YWJhc2UgZXh0ZW5kcyBfJEFwcERhdGFiYXNlIHsKICBBcHBEYXRhYmFzZSgpIDogc3VwZXIoX29wZW5Db25uZWN0aW9uKCkpOwoKICBAb3ZlcnJpZGUKICBpbnQgZ2V0IHNjaGVtYVZlcnNpb24gPT4gMTsKfQoKLy8gT3BlbiB0aGUgZGF0YWJhc2UgY29ubmVjdGlvbgpMYXp5RGF0YWJhc2UgX29wZW5Db25uZWN0aW9uKCkgewogIHJldHVybiBMYXp5RGF0YWJhc2UoKCkgYXN5bmMgewogICAgZmluYWwgZGJGb2xkZXIgPSBhd2FpdCBnZXRBcHBsaWNhdGlvbkRvY3VtZW50c0RpcmVjdG9yeSgpOwogICAgZmluYWwgZmlsZSA9IEZpbGUocC5qb2luKGRiRm9sZGVyLnBhdGgsICdkYi5zcWxpdGUnKSk7CiAgICByZXR1cm4gTmF0aXZlRGF0YWJhc2UoZmlsZSk7CiAgfSk7Cn0KCi8vIEV4YW1wbGUgdXNhZ2U6IGluc2VydCBhIHRvZG8KRnV0dXJlPHZvaWQ+IG1haW4oKSBhc3luYyB7CiAgZmluYWwgZGIgPSBBcHBEYXRhYmFzZSgpOwogIGZpbmFsIGlkID0gYXdhaXQgZGIuaW50byhkYi50b2RvcykuaW5zZXJ0KAogICAgVG9kb3NDb21wYW5pb24uaW5zZXJ0KHRpdGxlOiAnTGVhcm4gRHJpZnQgT1JNJyksCiAgKTsKICBwcmludCgnSW5zZXJ0ZWQgdG9kbyB3aXRoIGlkOiAkaWQnKTsKICBhd2FpdCBkYi5jbG9zZSgpOwp9

With **Drift**, querying the database becomes type-safe and concise. You can easily fetch records using generated APIs, and **Drift** supports reactive streams, so your UI can automatically update when the underlying data changes. For example, you can watch a table or a specific query and rebuild widgets in response to updates, making state management with local databases straightforward and robust.

aW1wb3J0ICdwYWNrYWdlOmRyaWZ0L2RyaWZ0LmRhcnQnOwppbXBvcnQgJ3BhY2thZ2U6ZHJpZnQvbmF0aXZlLmRhcnQnOwppbXBvcnQgJ2RhcnQ6aW8nOwppbXBvcnQgJ3BhY2thZ2U6cGF0aC9wYXRoLmRhcnQnIGFzIHA7CmltcG9ydCAncGFja2FnZTpwYXRoX3Byb3ZpZGVyL3BhdGhfcHJvdmlkZXIuZGFydCc7CgpjbGFzcyBUb2RvcyBleHRlbmRzIFRhYmxlIHsKICBJbnRDb2x1bW4gZ2V0IGlkID0+IGludGVnZXIoKS5hdXRvSW5jcmVtZW50KCkoKTsKICBUZXh0Q29sdW1uIGdldCB0aXRsZSA9PiB0ZXh0KCkoKTsKICBCb29sQ29sdW1uIGdldCBjb21wbGV0ZWQgPT4gYm9vbGVhbigpLndpdGhEZWZhdWx0KGNvbnN0IENvbnN0YW50KGZhbHNlKSkoKTsKfQoKQERyaWZ0RGF0YWJhc2UodGFibGVzOiBbVG9kb3NdKQpjbGFzcyBBcHBEYXRhYmFzZSBleHRlbmRzIF8kQXBwRGF0YWJhc2UgewogIEFwcERhdGFiYXNlKCkgOiBzdXBlcihfb3BlbkNvbm5lY3Rpb24oKSk7CgogIEBvdmVycmlkZQogIGludCBnZXQgc2NoZW1hVmVyc2lvbiA9PiAxOwp9CgpMYXp5RGF0YWJhc2UgX29wZW5Db25uZWN0aW9uKCkgewogIHJldHVybiBMYXp5RGF0YWJhc2UoKCkgYXN5bmMgewogICAgZmluYWwgZGJGb2xkZXIgPSBhd2FpdCBnZXRBcHBsaWNhdGlvbkRvY3VtZW50c0RpcmVjdG9yeSgpOwogICAgZmluYWwgZmlsZSA9IEZpbGUocC5qb2luKGRiRm9sZGVyLnBhdGgsICdkYi5zcWxpdGUnKSk7CiAgICByZXR1cm4gTmF0aXZlRGF0YWJhc2UoZmlsZSk7CiAgfSk7Cn0KCi8vIEV4YW1wbGUgdXNhZ2U6IHVwZGF0ZSBhIHRvZG8KRnV0dXJlPHZvaWQ+IG1haW4oKSBhc3luYyB7CiAgZmluYWwgZGIgPSBBcHBEYXRhYmFzZSgpOwogIC8vIEluc2VydCBhIHRvZG8gZmlyc3QKICBmaW5hbCBpZCA9IGF3YWl0IGRiLmludG8oZGIudG9kb3MpLmluc2VydCgKICAgIFRvZG9zQ29tcGFuaW9uLmluc2VydCh0aXRsZTogJ1VwZGF0ZSBEcmlmdCByZWNvcmQnKSwKICApOwogIC8vIFVwZGF0ZSB0aGUgdG9kbydzIGNvbXBsZXRlZCBzdGF0dXMKICBhd2FpdCAoZGIudXBkYXRlKGRiLnRvZG9zKS4ud2hlcmUoKHQpID0+IHQuaWQuZXF1YWxzKGlkKSkpLndyaXRlKAogICAgVG9kb3NDb21wYW5pb24oY29tcGxldGVkOiBWYWx1ZSh0cnVlKSksCiAgKTsKICBwcmludCgnVXBkYXRlZCB0b2RvIHdpdGggaWQ6ICRpZCcpOwogIGF3YWl0IGRiLmNsb3NlKCk7Cn0=

Which of the following is an advantage of using Drift for local databases in Flutter?

Master state management and data handling in Flutter to build robust, data-driven applications that work seamlessly both online and offline. Explore essential state management techniques, remote data fetching, error handling, and local storage solutions to create resilient Flutter apps.

Explore the core concepts of state management in Flutter, from basic setState to advanced patterns like Provider and Riverpod.

Learn to fetch, parse, and manage remote data in Flutter using REST APIs and JSON serialization.

Persist data locally in Flutter using SharedPreferences, secure storage, and SQLite with Drift.