How to Use Sqflite Package in Flutter for SQLite Database Operations

When developing an application using Flutter, there may be situations where we need to store large amounts of data. One way to do this is by using an embedded database like SQLite (Sqflite). In this tutorial, we will learn how to use the Sqflite package in Flutter to create, insert, delete, and update data in a SQLite embedded database.

Firstly, let's ensure that the path is correctly set for any platform. This can be done by using the `getDatabasesPath()` method from the `path` package. We then join this path with the name of our database, which in this case is 'hero_database'.

Next, we need to create a class that will hold our superhero data. In this example, I have defined a class called SuperHero. This class can be extended or modified as per your requirements.

To use the Sqflite package, you must add the following package name to your pubspec.yaml file:

```yaml

dependencies:

sqflite: ^2.0.0+1

```

Now let's move on to the main.dart file where we will write our code for inserting data into the database. We can use the `openDatabase()` method from the Sqflite package to open our database and then use the `insert()` method to insert our superhero data.

Here is an example of how you can do this:

```dart

import 'package:sqflite/sqflite.dart';

import 'package:path/path.dart' as path;

Future main() async {

final heroDatabase = await openDatabase(

join(await getDatabasesPath(), 'hero_database'),

version: 1,

onOpen: (db) {},

onCreate: (Database db, int version) async {

await db.execute('''

CREATE TABLE superheros (

id INTEGER PRIMARY KEY,

name TEXT

)

''');

);

// Insert data into the database

final batman = SuperHero(name: 'Batman');

await heroDatabase.insert('superheros', batman.toMap());

// Delete data from the database

await heroDatabase.delete('superheros', where: 'name = ?', whereArgs: ''Batman'');

}

```

In this example, we are creating a table called `superheros` with two columns - `id` and `name`. We then insert Batman's data into the table using the `insert()` method. Finally, we delete Batman's data from the table using the `delete()` method.

To summarize, Sqflite is a powerful package that allows us to create, insert, delete, and update data in a SQLite embedded database in Flutter. By following this tutorial, you should be able to use Sqflite to store your superhero data in a database.

Sqflite flutter