{"id":736,"date":"2019-12-14T09:08:27","date_gmt":"2019-12-14T09:08:27","guid":{"rendered":"https:\/\/citrusleaf.in\/blog\/?p=736"},"modified":"2022-12-10T10:32:29","modified_gmt":"2022-12-10T10:32:29","slug":"sqflite-flutter-tutorial-introduction","status":"publish","type":"post","link":"https:\/\/citrusleaf.in\/blog\/sqflite-flutter-tutorial-introduction\/","title":{"rendered":"SQFlite Flutter Tutorial – Introduction"},"content":{"rendered":"\n

The soaring technology trend in the mobile app industry is nothing but Flutter, a cross-platform SDK launched by Google. With its cross-platform features and easy to implement methods, Flutter has attracted the interest of many developers.<\/p>\n\n\n\n

Starting with the configuration and architecture of a Flutter app is a straightforward process. But, when you jump to the next step that is creating a Database, you might get stuck. To be precise, there is no such database method available for Flutter but one can integrate the SQLite database system to the Flutter app using SQFLite plugin.<\/p>\n\n\n\n

In this article, we are going to discuss how to set up a local SQLite database in a Flutter app. We are going to demonstrate it on a TODO list example.<\/p>\n\n\n\n

What is SQLite?<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

SQLite is an open-source relational database. SQLite does not have a separate server process which means that it essentially stores the data in a file (also known as an embedded mode). SQLite is the world\u2019s most used database and is used in almost every connected device. Both Android & iOS relies heavily on SQLite.<\/p>\n\n\n\n

SQFLite is a plugin for Flutter. It supports both the native platforms i.e Android & iOS.<\/p>\n\n\n\n

Why use the SQFlite plugin?<\/h2>\n\n\n\n

Flutter does not provide a built-in abstraction for accessing the SQLite Database. However, using the SQFlite plugin, one can access the SQLite database on both Android & iOS. The plugin is well-maintained and is recommended by the Flutter team as well.<\/p>\n\n\n\n

If you are new to SQLite and SQL statements, go ahead & learn the basics of SQLite from SQL Tutorial<\/a><\/p>\n\n\n\n

In this article, we will be demonstrating an example (TODO App) of using the SQFlite plugin in the Flutter application.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Depend on SQFlite<\/h2>\n\n\n\n

Add the following dependencies to pubspec.yml and run \u201cflutter packages get\u201d command in the terminal.<\/p>\n\n\n\n

Dependencies:<\/strong><\/p>\n\n\n\n

sqflite: ^1.1.0  #sqflite package\nflutter_simple_dependency_injection: ^1.0.1 #to perform dependency injection\npath_provider: ^0.5.0+1 #helper package used by database helper class to get the database file<\/code><\/pre>\n\n\n\n
Create a Database Helper Class<\/h2>\n\n\n\n
This class is going to be used throughout the app\u2019s lifecycle. Ideally, it should be used with some kind of Dependency Injection technique.<\/p>\n\n\n\n
import 'dart:io' as io;\n\nimport 'package:path\/path.dart';\nimport 'package:path_provider\/path_provider.dart';\nimport 'package:sqflite\/sqflite.dart';\n\nclass DatabaseHelper {\n static final DatabaseHelper _instance = new DatabaseHelper.internal();\n\n factory DatabaseHelper() => _instance;\n static Database _db;\n\n DatabaseHelper.internal();\n\n initDb() async {\n   io.Directory documentsDirectory = await getApplicationDocumentsDirectory();\n   String path = join(documentsDirectory.path, \"database_name.db\");\n   _db = await openDatabase(path, version: 1, onCreate: _onCreate);\n }\n\n Database get db {\n   return _db;\n }\n\n void _onCreate(Database db, int version) async {\n   \/\/ When creating the db, create the table\n   await db.execute(\n       'CREATE TABLE todos (id INTEGER PRIMARY KEY AUTOINCREMENT,'\n'item_name TEXT,'\n           'date_created TEXT')';\n }\n}<\/code><\/pre>\n\n\n\n
In the class above, the initDb() method initializes the and calls onCreate() when the database is created for the first time. The version parameter is the database version and is useful when migrating\/updating the DB structure when the app is updated.<\/p>\n\n\n\n
Create an Injection class<\/h2>\n\n\n\n
import 'dart:async';\n\nimport 'package:eknumber\/utils\/database_helper.dart';\nimport 'package:flutter_simple_dependency_injection\/injector.dart';\n\nclass Injection {\n static DatabaseHelper _databaseHelper = DatabaseHelper();\n static Injector injector;\n\n static Future initInjection() async {\n   await _databaseHelper.initDb();\n  \n   injector = Injector.getInjector();\n\n\n   injector.map<DatabaseHelper>((i) => _databaseHelper,\n       isSingleton: true);\n}\n}<\/code><\/pre>\n\n\n\n
The above class makes sure that there\u2019s only one instance of the database available throughout the app\u2019s lifecycle. In order to use the DB from any other class, you can get it easily by doing-<\/p>\n\n\n\n
DatabaseHelper _databaseHelper = Injection.injector.get();<\/code><\/pre>\n\n\n\n
Create a Model Class <\/h2>\n\n\n\n
In this example, we\u2019re going to create a simple data model with few properties and few methods which will be used when doing CRUD operations on the DB table.<\/p>\n\n\n\n
class Todo{\n int id;\n String itemName;\n String dateCreated;\n\n Todo(\n     {this.id,\n     this.itemName,\n     this.dateCreated})\n\n \/\/to be used when inserting a row in the table\n Map<String, dynamic> toMapWithoutId() {\n   final map = new Map<String, dynamic>();\n   map[\"item_name\"] = itemName;\n   map[\"date_created\"] = dateCreated;\n   return map;\n }\n\nMap<String, dynamic> toMap() {\n   final map = new Map<String, dynamic>();\n   map[\"id\"] = id;\n   map[\"item_name\"] = itemName;\n   map[\"date_created\"] = dateCreated;\n   return map;\n }\n\n \/\/to be used when converting the row into object\n factory Todo.fromMap(Map<String, dynamic> data) => new Todo(\n     id: data['id'],\n     itemName: data['item_name'],\n     dateCreated: data['date_created']\n );\n}<\/code><\/pre>\n\n\n\n
Performing basic CRUD operations<\/h2>\n\n\n\n
Now that we\u2019ve set up the basic structure along with dependency injection, we can easily perform CRUD operations on our model. Note that the below example methods are redacted and can be used in conjunction with other techniques like Repository pattern.  <\/p>\n\n\n\n