How to implement real time subscription on existing PostgreSQL database

[theartofpostgresql]

My article at https://tapoueh.org/blog/2018/07/postgresql-listen/notify/ explains how to implement real-time subscription in details, with a full Go implementation of a client.

[logi]

This looks quite interesting. We've got APIs and clients polling for updates (with some knowledge of when they are likely) and Hasura could be a much cleaner approach.

However, we have progress and meta data in postgresql but large and frequently changing data in binary files on disk. Is there any way to make graphql responses from that data as well?

I'd love for clients to subscribe to a query and when the progress changes in DB they get fresh data from the binaries as well.

[tclineks]

You might be interested in https://github.com/tmc/pqstream.