News for hackers. Stuff that matters.
Re:Show HN: Transform Your PostgreSQL into a Powerful Job Queue by justinclift on Sunday August 18, 2024 @09:08PM (#41286936)
Sounds like it wouldn't have immediate notification of new submissions due to no listen/notify support in SQLite?
Re:Show HN: Transform Your PostgreSQL into a Powerful Job Queue by memset on Sunday August 18, 2024 @09:27PM (#41287015)
It does not implement immediate notification of new submissions because the SQS protocol doesn't have a "push" mechanism, only pull.

The software, however, could support this for a different queue protocol. This is because SQLite is just used as a disk store for queue items. The golang code itself still processes each message before writing to disk. Since that code is "aware" of incoming messages, it could implement an immediate notification mechanism if there was a protocol that supported it.

Re:Show HN: Transform Your PostgreSQL into a Powerful Job Queue by agrothberg on Sunday August 18, 2024 @10:40PM (#41287325)
SQS does offer long polling, which looks closer to "push" semantics.
Re:Show HN: Transform Your PostgreSQL into a Powerful Job Queue by memset on Sunday August 18, 2024 @11:18PM (#41287503)
Fair enough. I do implement long polling!