3 ms·
That is a very bold claim. A message queue can have many different requirements: Some message queues tolerate lost messages, others don't. Some require a notifi
by aneutron 2y ago
That is a very bold claim. A message queue can have many different requirements: Some message queues tolerate lost messages, others don't. Some require a notification mechanism (i.e. a push model instead of a polling model). Other require precise management of dead letters.
All this to say that, yes, you theoretically CAN use SQLite as a message queue. But atomic operations are usually WAY lower on the "must have" list for a message queue than other parameters.
The easiest way you could verify this is by looking at the guarantees provided by some of the most known MsgQueues.
- andrewstuart 2y agoAtomic operations are the baseline requirement for implementing a queue. This is what ensures only one reader gets a message. SQLite has it, redis does not.