D
D
Delakey Blackhole2016-11-23 17:00:35
Computer networks
Delakey Blackhole, 2016-11-23 17:00:35

Which database is best suited for implementing a queue?

Which database is best suited for implementing a queue?
approximately what I need is the creation of queues, the ability to simply get an element by index or select by time, get a new element, I think to use my sql, but maybe there are databases focused on this?
the essence is something like this, there is a rest api that accepts commands, puts them in a queue, another server monitors the queues and when a command arrives, it executes it, no notification of the success of the execution is required

Answer the question

In order to leave comments, you need to log in

3 answer(s)
R
Roman Mirilaczvili, 2016-11-23
@2ord

And you can not fence the garden, but use ZeroMQ / RabbitMQ / Beanstalkd / ...
or, perhaps, do without queues .

M
mcleod095, 2016-11-23
@mcleod095

I know that in oracle there is a queue_table
that just represents a queue.

A
Alexander Kuznetsov, 2016-11-24
@DarkRaven

In our solution, written in .NET, at the moment when it was necessary to introduce a queue, we simply put the Microsoft Message Queue. Now, if I had a choice and a similar task, I would rather stop at RabbitMQ, or maybe not. Everything depends on the tasks.
In answer to the question, use ZeroMQ/RabbitMQ/MSMQ and don't reinvent the wheel. They do not need a database, and it is much easier to implement it than to fence interaction with the database.
And yet, you can try, for example, Hangfire, but it's not really a queue, but more of a task scheduler.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question