Flutter – Database Concepts (SQLite)

SQLite database is the de-facto and standard SQL based embedded database engine. It is small and time-tested database engine. sqflite package provides a lot of functionality to work efficiently with SQLite database. It provides standard methods to manipulate SQLite database engine. The core functionality provided by sqflite package is as follows −

• Create / Open (openDatabase method) a SQLite database.
• Execute SQL statement (execute method) against SQLite database.
• Advanced query methods (query method) to reduce to code required to query and get information from SQLite database.

Let us create a product application to store and fetch product information from a standard SQLite database engine using sqflite package and understand the concept behind the SQLite database and sqflite package.

• Create a new Flutter application in Android studio, product_sqlite_app.
• Replace the default startup code (main.dart) with our product_rest_app code.
• Copy the assets folder from product_nav_app to product_rest_app and add assets inside the *pubspec.yaml` file.

flutter: 
   assets: 
      - assets/appimages/floppy.png 
      - assets/appimages/iphone.png 
      - assets/appimages/laptop.png 
      - assets/appimages/pendrive.png 
      - assets/appimages/pixel.png 
      - assets/appimages/tablet.png

• Configure sqflite package in the pubspec.yaml file as shown below −

dependencies: sqflite: any