Flutter SQFLite Database Tutorial: Implement SQLite database with example: Section Overview #4.1
Why Stack Overflow recommends it
Stack Overflow users link it when they need a step-by-step walkthrough for storing local Flutter data with the sqflite package.
Recommended by 2 people across 2 different months, 2018 to 2020.
What it is
A short section-overview video from Smartherd's Flutter tutorial series introducing how to build a SQLite-backed app with the sqflite plugin. It previews designing the UI, async programming with await, async, Future and then, and the database implementation, presented by Sriyank Siddhartha.
What people said
Recommends Jason Lloyd · 2020-02 · Stack Overflow · on “How to save cache in device Flutter”
Yeah i'd recommend the sqflite package for flutter, i've just figured out how to use it to solve this same issue! I learnt it using this YouTube video: [this video] .
Recommends CoderUni · 2020-04 · Stack Overflow · on “Edit Listview Item on Edit Click Using Dialog”
Store the listview items in local storage using the sqflite package. You can edit them by editing the item in local storage directly and calling setState() to update the stateful widget. Here is a great tutorial showing you how: [this video]
Cites Zain SMJ · 2018-12 · Stack Overflow · on “Flutter - Modify Sqlite table without deleting database”
I am using Sqlite database in Flutter by using sqflite plugin. Following the below mentioned links I am able to successfully create database and perform CRUD operations in it. Sqflite Plugin [LINK] Sqflite Tutorial - Youtube Playlist [this video] The problem is, Once the database is created I cannot modify old tables. In order to get a new column in "tabEmployee" table, I must delete the database and recreate it. void _onCreate(Database db, int newVersion) async { await db.execute( "CREATE TABLE tabEmployee($idPk INTEGER PRIMARY KEY, employeeName TEXT)"); } What should I do in order to modify previously created table in sqflite without deleting database ?