One of the appeals of doing MQ in Postgres is being able to submit events atomic... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		anentropic on May 10, 2024 \| parent \| context \| favorite \| on: Show HN: An SQS Alternative on Postgres One of the appeals of doing MQ in Postgres is being able to submit events atomically in same db transaction as the stuff that raised the event Looking at https://github.com/tembo-io/pgmq/tree/main/tembo-pgmq-python ...how do I integrate the queue ops with my other db access code? Or is it better not to use the client lib in that scenario and use the SQL functions directly? https://github.com/tembo-io/pgmq?tab=readme-ov-file#send-two...

chuckhend on May 10, 2024 [–]

The client libs are a nice convenience, but most users write the sql directly when integrating with other SQL statements, something like:

begin; select * from my table group by... select pgmq.send(); commit;

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact