0

I would like to know what, why or when it is better to choose a queuing tool and what, why or when it is better to choose database task table? I don't understand the difference of sending my tasks in a queuing tool or in a database table that will be read and act as a queue. Is there some properties that queuing tools has that database cannot do?

Read my question as "what are the benefit or what are the arguments to choose a queuing tool solution". My question is not about what language, technology, or project one should take up next.

Thank you,

Improve this question
3
  • Hello B413, it really helps us to answer your question if you would follow the advice from programmers.stackexchange.com/help/how-to-ask and tell us which kind of research you have done so far, what you have found and why it didn’t meet your needs. AFAIK you have already asked a similar question here (which was closed), where I gave you some tutorial links to some queuing tools. Did you read them?
    – Doc Brown
    Commented Jun 19, 2014 at 8:43
  • Yes I read them. I really don't understand what a queuing tools do better than a database. Sorry but for me every thing listed in queuing tool pros : Transactional, Durable, Reliable, Distributed, Scalable are the same properties than a database. And a queuing tool seems to require a database. So why using a queuing tool? If someone can give me a real example where a database is not enough.
    – Bastien Vandamme
    Commented Jun 19, 2014 at 9:22
  • Well, for one, the DB will not warn your logic when a new message is available. And will not distribute the messages between several consumers.
    – SJuan76
    Commented Jun 19, 2014 at 10:29

1 Answer 1

Reset to default
2

The short answer is queues are optimized for what they do while databases are not. Some actually consider the use of a database as a queue an anti-pattern. Much has been said that I won't repeat here. A common thought is that while it seems trivial to turn a database into a queue, you eventually end up having to solve all of the problems the queue designers have already solved for you.

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.