Hacker News new | ask | show | jobs
by augusto-moura 1480 days ago
Going simpler as possible:

Redis has a simple (but extremely powerful) Pub/Sub implementation[1] that should get you going for a long time.

Postgres also have a simple notify API[2] you can mix it with your own tables and just "notify" that some changes were made (when people say you can do anything with postgres nowadays they are not joking).

You probably can also roll your own implementation in any ACID database. Just keep adding records to an event table and consume them in scheduled batches. Should be more than enough for non real-time applications.

[1]: https://redis.io/docs/manual/pubsub/ [2]: https://www.postgresql.org/docs/current/sql-notify.html

2 comments

Redis also has a Stream data type since version 5, which is designed exactly for this. No need to build something on top of lists anymore.
>Redis has a simple (but extremely powerful) Pub/Sub

Interesting - I had just assumed everyone is doing MQTT or cloud pub/sub