News for hackers. Stuff that matters.
Re:Don't Use an RDBMS for Messaging by lobster_johnson on Saturday September 27, 2014 @07:52PM (#8378510)
Not at all, just wondering about your thinking. Note that I think using a database for IPC is a bad idea if you're actually using tables and such to coordinate; Postgres' listen/notify IPC is much better.

That said, it has issues, as pointed out elsewhere in this thread; when you notify, all listeners wake up, which is not what you want with a one-job-per-worker dispatch system.

If you abstracted the listening to a central job manager app, however, you could use "listen" to wake up just the job manager, and then use that wake-up to dispatch the next job to an available worker.

There are no comments on this comment yet.