Move `NOTIFY` into a trigger

acaloiaro / neoq

Queue-agnostic background job library for Go, with a pleasant API and powerful features.

MIT License

270 stars 4 forks source link

Move `NOTIFY` into a trigger #73

Closed acaloiaro closed 1 year ago

acaloiaro commented 1 year ago

Currently NOTIFY is done in Go, but this could easily live in a trigger to reduce application complexity and clean up transaction handling for enqueued jobs.

Event the Postgres docs mention this approach: https://www.postgresql.org/docs/current/sql-notify.html

acaloiaro commented 1 year ago

Fixed by #79