4 ms·
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
by anentropic 2y ago
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 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-messages https://github.com/tembo-io/pgmq?tab=readme-ov-file#send-two...
- chuckhend 2y agoThe 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;