Hi, this is a really nice article. The funny thing is, it comes at the right time. We use Postgres and are currently considering to add Redis behind our rust backend with websockets to enable push notifications for turtle (turtle.community), but are not quite sure if this is the right way.
Does anyone have some inspiration or experience on that topic?
I'm not sure if it fits your use case perfectly, but take a look at NOTIFY, introduced in PG 9.0 -- it's basically a push notification mechanism built into PostgreSQL.
thx for the info, will have a look!
Not Rust, but I wrote a post about using LISTEN/NOTIFY and a small Ruby app to push DB updates over a websocket:
thx a lot :)
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.