How to create queue in db (postgres)?

N

Nikolai Markov2014-09-04 16:34:49

PostgreSQL

Nikolai Markov, 2014-09-04 16:34:49

It is necessary to store the tasks for sending messages in the database. How to implement an efficient asynchronous queue so that processes that send messages cannot send the same message at the same time.
UPD: persistence is needed so that in the event of a storage crash, tasks are not lost.
UPD: I don't really need a queue, but rather just a storage for jobs
UPD: you can say that I need sidekiq ( sidekiq.org/), but its disadvantage is that if redis crashes, then all jobs will be lost

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

anyd3v, 2014-09-04
@anyd3v

Use ready-made solutions, it will be much more efficient.
google towards RabbitMQ, ActiveMQ, ZeroMq etc

M

Michael, 2014-09-04
@mtyurin

pgq. well, or just do it on the table