Message DB: Event Store and Message Store for PostgreSQL
For anyone just looking for the pub/sub functionality, I have been developing something that provides the functionality for PostgreSQL: <a href="https://github.com/supabase/realtime" rel="nofollow">https://github.com/supabase/realtime</a><p>It's an Elixir server (Phoenix) that allows you to listen to changes in your database via websockets.<p>Basically the Phoenix server listens to PostgreSQL's replication functionality, converts the byte stream into JSON, and then broadcasts over websockets. The beauty of listening to the replication functionality is that you can make changes to your database from anywhere - your api, directly in the DB, via a console etc - and you will still receive the changes via websockets.<p>I'd have to dig into their implementation to verify, but the main benefit over OP is scalability - i believe their implementation is tightly coupled to postgres, but with this you could scale the Elixir servers without any additional load on your DB<p>It's still in <i>very</i> early stages, although I am using it in production at my company and will work on it full time starting Jan