Flutter Database Example ( sqflite )

A Flutter application, To show the use of sqflite database in flutter with structure.

Adding User To DB	Deleting User from DB

Project is mainly contain two packages

1. Database :

Which contains all the model classes of tables and all other database Helper classes to create and initialiaze database.

2. UI :

Which contains required screens to provide user interface.

Important classes of DATABASE :

Helper classes

1. AppDatabaseInfo: It contains all the database related information.
2. DBInfo: An interface to provide all the required database information which is implemented by AppDatabaseInfo class.
3. DBHelper: Helper class, which help us to initialize/open database and create tables.
4. DBInformer: Interface class, which give us callback on database initialized/open.
5. Tables: Which contains all the table creation queries.

Data classes

• Model : Table class, contains all the table columns information.
• Provider : Data Provider class, which responsible to perform all CRUD operation on perticular Table.

Library reference resources

1. sqflite : https://pub.dev/packages/sqflite
2. shared_preferences : https://pub.dev/packages/shared_preferences

---

For more understanding, Please refer this project also you can use this project if you want to quick start.

---

Benefits

• Easy Database implementation
• Time saving
• Clean Structure

More?

If you have any suggestions or you can make this more better write me, create issue, or you can also write code and send pull request.

Questions?

Ping-Me on :

Donate

If you found this project helpful, consider buying me a cup of ☕

• Paypal https://paypal.me/UttamPanchasara