How to Store data in Sqlite in Flutter

Updated 25 April 2023


In this blog, we are going to learn how we can Store data in Sqlite in flutter.

If you are creating an app that needs to store data in a database instead of a local file or key-value then use Sqlite.
In general, databases provide faster inserts, updates, and queries compared to other local persistence solutions.

Flutter apps can make use of SQLite databases via the sqflite plugin available on 

Looking for the best Flutter app development?

Add Dependency

First, you need to add the sqflite package to your pubspec.yaml file and run flutter pub get to install it.

Import the SQLite package in your Dart file:

Create a class for your database and define the tables and columns you want to use:

In this example, we have created a table named “Person” with columns: “name”, and “age”.

Use the DbManager instance to perform operations on the database, such as inserting data, querying, updating, and deleting data.

Model class.

Check the below code to insert data in Sqlite Database by the user interface.

Output :

How to Store data in Sqlite in Flutter
How to Store data in Sqlite in Flutter

Conclusion :

Hope, this post gives you an idea about storing data in Sqlite in Flutter.

To know more please click here.

Thank you !!

. . .

Leave a Comment

Your email address will not be published. Required fields are marked*

Be the first to comment.

Start a Project

    Message Sent!

    If you have more details or questions, you can reply to the received confirmation email.

    Back to Home