DEV Community

Discussion on: Real time + Postgres = ?

Collapse
imthedeveloper profile image
ImTheDeveloper

Nice to see this!

I've been using the postgres notify method for a while now and setting up triggers all over my tables to output JSON to pub/sub messaging service. It worked really well and blew my mind a little bit to see live website updates without any screen refreshing once I had WS set up. However! as mentioned this was a painful and often manual process. I'll be giving Hasura a test as it would really help to make this painless from your explanation

Collapse
alex_barashkov profile image
Alex Barashkov Author

Yep. Did the same for a long time too, Postgres native notifications very reliable and work amazing, but I always wondered about the better solution, to prevent having extra dependencies and subscription logic in the microservices.

Collapse
imthedeveloper profile image
ImTheDeveloper

Another product I just came across:

debezium.io/

Streams into Kafka for db updates.

Collapse
mkhtradm01 profile image
Adamu Muktar • Edited on

Any tips on how you do that? or code snippets, please?

Fortunately, I found Hasura Package for flutter in pub.dev

Collapse
imthedeveloper profile image
ImTheDeveloper • Edited on

gist.github.com/colophonemes/9701b...

Good convo and examples here I followed.

Hasura as a product now comes with all of this too but you may have the case where you don't want to go that route, so these scripts help.

Thread Thread
mkhtradm01 profile image
Adamu Muktar

Thanks dear, I found Hasura Package for Flutter Developers