News for hackers. Stuff that matters.
Re:Listen to your to PostgreSQL database in realtime via Web... by cookguyruffles on Friday April 30, 2021 @12:14PM (#26995371)
As far as getting cheap framing and bidirectional communication over an HTTP port goes, there's nothing to stop you using websocket server->server. For example users, many crypto exchanges publish their feed this way
Re:Listen to your to PostgreSQL database in realtime via Web... by codeflo on Friday April 30, 2021 @12:27PM (#26995592)
But why, except to claim “web-scale”? Especially for publishing events, isn’t something like MQTT a lot saner?
Re:Listen to your to PostgreSQL database in realtime via Web... by cookguyruffles on Friday April 30, 2021 @12:29PM (#26995623)
I already listed two, because you need

- cheap framing

- bidirectional comms

- are already exposing an HTTP port

- can make no assumptions about the client's networking than port 443 available, even if only via a HTTPS proxy

- can make no assumptions about the client's software except they can speak an extremely common protocol

- want security to work the same way it does for the rest of your services

"web-scale" doesn't come into it. Websockets are inherently difficult to scale because they're stateful, but in return you get the lowest latency in both directions the underlying network can provide with extremely reasonable (2-4 bytes) overhead compared to raw TCP or SSL

Re:Listen to your to PostgreSQL database in realtime via Web... by megous on Friday April 30, 2021 @01:17PM (#26996324)
No broker.