5 ms·
Since the article mentioned Postgres by name, isn't this a case for using its asynchronous notification features? Servers can LISTEN to a channel and PG can TRI
by imglorp 2y ago
Since the article mentioned Postgres by name, isn't this a case for using its asynchronous notification features? Servers can LISTEN to a channel and PG can TRIGGER and NOTIFY them when the data changes.
No polling needed, regardless of the frontend channel.
- lunarcave 2y agoYes, but the problems of detecting that changeset and delivering it to the right connection remains to be solved in the app layer.
- cluckindan 2y agoIt would be easier to run Hypermode’s Dgraph as the database and use GraphQL subscriptions from the frontend. But nobody ever got fired for choosing postgres.
- j45 2y agoI have relatively recently taken steps towards Postgres from it's abiality to be at the center of so much until a project outgrows it. In terms of not getting fired - Postgres is a lot more innovative than most databases, and the insinuation of IBM. By innovative I mean uniquely putting in performance related items for the last 10-20 years.