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.

Dominik

use pub.dev/packages/moor, it says: "Reactive: Turn any sql query into an auto-updating stream! This includes complex queries across many tables" – Hedgehop

Thanks @pskink, can you please show me how to do it. I could not get it from their docs. – Dominik

see SimpleSelectStatement official documentation – Hedgehop

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).

Amazed

Answer 2

You can achieve similar function of listening to sqflite changes by implementing Streams, adapting BloC pattern. You can check this blog post for a sample. One way of achieving this is by updating the Stream paired to sqflite. With this approach, you can use StreamBuilders that can automatically rebuild child widgets when there's change on Stream.

Hemi

Answer 3

You can add stream to your data fetching function.

You can learn more about flutter streams from this link .

Ribald

Answer 4

Consider this sqlbrite package, it will allow you to listen to sqlite changes as a stream.

Absolutely