Answer the question
In order to leave comments, you need to log in
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
And you can not fence the garden, but use ZeroMQ / RabbitMQ / Beanstalkd / ...
or, perhaps, do without queues .
I know that in oracle there is a queue_table
that just represents a queue.
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 questionAsk a Question
731 491 924 answers to any question