Re:Don't Use an RDBMS for Messaging
by lobster_johnson on Saturday September 27, 2014 @04:25PM
(#8378097)
Sounds like a pragmatic solution. If you're using Postgres you can use "listen" and "notify" to avoid polling, though.
The workflow system itself took a week or so to build along with a client library and our first actual workflow. Trying to add a messaging system on top for push notification would have been crazy. Polling every second for work in the db works just fine for us. I'm sure we could lower that polling interval arbitrarily lower if we needed (we might never get it as low as RabbitMQ but that is fine).
So if your tps and latency needs fit in an rdbms, I would recommend just operating one system instead of two.