We'll do the same for the setCompleteForItem function. import 'package:sqflite/sqflite.dart' const String DB_NAME = 'todo_database.sqlite' class DatabaseService Inside create a class called DatabaseService which will contain an field called _database and an initialisation function to open a connection to that database. Under lib/services create a new filed called database_service.dart. If you want to learn more about stacked check out this architecture series on YouTube. Both Dart and Flutter are created by Google and getting more popular. Flutter is a cross-platform mobile SDK for building Android and iOS apps with Dart. SQLite Database CRUD with Dart and Flutter. NOTE: You can use the SQLite implementation outside of the stacked architecture, but this project uses the stacked architecture but you can still use the service we'll be building in any other state management solution you'd like to use. In this tutorial, well learn how to run example CRUD operations against a SQLite database in a flutter mobile application using the sqflite plugin. (It's added in the project but if you don't have it, add it). Go to the pubspec.yaml file and add the sqflite package.

Open up the project and lets get started. DatabaseReference root () Example: DatabaseReference has some methods that can be used to perform various operations as shown below. You can go to the root by using the root method. to follow along with the tutorial I'd recommend you to download it here. The example below returns a DatabaseReference for the node whose location is /users. For this tutorial I created a little Todo starting application with some basic stacked architecture setup and some UI bits. Migration management (Falls into 1, but better demonstrated after 3)īefore we can move onto the 3 topics above we have to setup SQLite in the codebase.We will be focussing on 3 main things in this tutorial. That is what we'll be using today through the sqflite package. The most common run-time for SQL that works on nearly every device, including mobile, is SQLite. The most common approach is a SQL database. This allows you to give a better experience to users in cases where the initial requests to get information might take some time. Local storage or the 'Offline first' data approach is common in the modern mobile applications.

Flutter database example