Re:Just use Postgres for everything
by vb-8448 on Sunday December 11, 2022 @12:19PM
(#33945125)
This is the usual debate on "hammers and nails".
You are absolutely right, but what if(just an example) you need transaction behavior between your queue system and your database? Good luck with 2pc or using saga and similar.
Or, as other people stated, how much will cost to maintain postgres + redis + rabbitmq vs only postgres?
In my opinion, the golden rule is: *use the most general purpose tool you know unless you hit a hard limit of the tool, in that case start moving to a specialized tool*.
You are absolutely right, but what if(just an example) you need transaction behavior between your queue system and your database? Good luck with 2pc or using saga and similar.
Or, as other people stated, how much will cost to maintain postgres + redis + rabbitmq vs only postgres?
In my opinion, the golden rule is: *use the most general purpose tool you know unless you hit a hard limit of the tool, in that case start moving to a specialized tool*.