SQLite in Flutter

rishabh sharma

1 May 2023

SQLite database is a standard SQL based database engine. It is small and time-tested database engine. However, you will often find that you need to save data locally in your app so one of the technique to save data locally is using SQLite database.

You may also check our flutter app development services

Flutter apps can make use of the SQLite databases with the help sqflite plugin available on pub.dev.

SQLite plugin for Flutter has some below features:

Supports transactions and batches.
Automatic version management during open.
Helpers for insert/query/update/delete queries.
DB operation executed in a background thread on iOS and Android.

Let’s get started with how we can install the plugin.

dependencies:
  ...
  sqflite: ^1.3.0

dependencies:

...

sqflite: ^1.3.0

Add the dependency in your pubspec.yaml file.

After that, import the class in the file you want to use the package.

import 'package:sqflite/sqflite.dart';

1	import 'package:sqflite/sqflite.dart';

Then, to initialize and open the database, do below part.

var db = await openDatabase('my_db.db');

1	var db = await openDatabase('my_db.db');

Furthermore, Below are few helper methods provided by the dependency.

Insert

Future<Model> insert(Model model) async { 
   model.id = await db.insert(table, model.toMap());
   return model;
}

Future<Model> insert(Model model) async {

model.id = await db.insert(table, model.toMap());

return model;

}

Delete

Future<int> delete(int id) async {
   return await db.delete(table, where: '$columnId = ?', whereArgs: [id]);
}

Future<int> delete(int id) async {

return await db.delete(table, where: '$columnId = ?', whereArgs: [id]);

}

Update

Future<int> update(Model model) async {
   return await db.update(table, model.toMap(), where: '$columnId = ?', whereArgs: [model.id]); 
}

Future<int> update(Model model) async {

return await db.update(table, model.toMap(), where: '$columnId = ?', whereArgs: [model.id]);

}

References: