Listen to real-time changes in Flutter SQFLite Database

Question

I have a fully functional app created in Flutter. It uses sqflite plugin for storing data. I want to have a data change listener, which will update or refresh the data when new data is added or updated. How can I achieve this. I came across a sqflite helper plugin sqlcool but could not figure out a way to use it with my existing database in sqflite. Please help me.
Thanks.

Answer 1

I also faced the same problem as yours, and ended up using Drift (Moor).

You can learn about it from its documentation -> https://drift.simonbinder.eu/docs/getting-started/

It's has similar features as Jetpack Room in Native Android Development. It also notifies when database changes using Flutter Stream API which you can easily observe (subscribe).