Why You Should Not Use an RDBMS for Messaging

Home Subscribe 27 September 2014 on PostgreSQL , RabbitMQ Relational databases are useful tools. They make it possible to represent almost any data model and to ask questions later about the data that were not anticipated when the schema was first designed. And they are getting better every day. PostgreSQL’s new JSON functionality enables the storage of dynamically structured data, which is something that was previously the specialty of NoSQL databases. It is sometimes tempting to use relational databases as message queue systems too. But, I do not recommend this and here is why. It is good engineering practice to clarify what we expect from a tool before evaluating its usefulness. Objective evaluation is only possible when comparing our requirements with the functionality the tool offers. These requirements vary from application to application, but this is a set o...

Linked on 2014-10-03 18:12:55 | Similar Links