Flutter, local SQLite database and Role based access control

user_10106872 0
Viewed 345

I am new in Flutter and still learn basics and my next step is to create user role-based authorization Flutter desktop app using local database (SQLite). In the web I can't find any resources about this approach. Most of them is about Firebase auth.

For example I would like to display widgets based on user role or have admin panel to manage and assign roles to the users.

I suppose that i need at least 3 tables (Users, Roles, User-Roles) with many-to-many relationship.

Can someone lead me to the appropriate resoures or give a hint where should I start?

Any idea, hint or link to the source will be valuable to me.

role-base-authorization flutter-desktop flutter roles sqlite
1 Answers

SQLite is one of the simplest forms of SQL that you can find hence it's one of the default choices not only for front-end Sdks such as Flutter but also for backend such as Django.

I have created this very detailed video that explains how you can integrate with SQLite using the SQFlite plugin in Flutter for creating a CRUD application.

SQLite doesn't have built-in user management so you need to start creating user tables and manage those relationships manually.

user_38257250
Related