Re:Citus 6.1 Released – Horizontally scale your Postgres dat...
by agentgt on Thursday February 16, 2017 @04:19PM
(#13663657)
Yes Postgres has disadvantages (I accidentally posted my comment too soon so that might have caused some confusion) but like I said it is: 1. Mature, 2. SQL is damn powerful, 3. Memory friendly (aka cost).
RethinkDB is cool. I just never got into it to know how well it actually works. As for bottledwater we use Postgres + AMQP aka Rabbit + Listen/Notify. I'm not really a big fan of kafka even though it does have amazing scaling ability.
I haven't implemented anything for that before personally; would a tool like Bottled Water [0] be helpful for this usecase?
[0] https://github.com/confluentinc/bottledwater-pg