Practical sqflite patterns — schema setup, queries and CRUD.
- Database creation and table definition shown step by step.
- Full CRUD operations against a local SQLite database.
- Provider state keeps screens in sync with the database.
- Live badge counts demonstrate querying and reacting to results.
| Concern | Choice |
|---|---|
| UI | Flutter, Material |
| Database | sqflite, path_provider |
| State management | provider |
| Utilities | shared_preferences, badges |
lib/
- `database`
- `screen`
- `main.dart`
- Flutter
>= 3.16(Dart>= 3.2)
git clone https://github.com/developer-rahim/SQLFlite-Databasese.git
cd SQLFlite-Databasese
flutter pub get
flutter runflutter test
flutter analyzeA reference repository — the database folder holds the schema and query examples worth copying.
Released under the MIT License.