Deduplicating messages

[fr3fou]

Hello, I was wondering if it's possible to deduplicate events when publishing them to a pg-boss queue.
My current use case involves receiving messages from AWS SQS and then publishing them to multiple pg-boss queues in a fan-out fashion (using the boss.publish() and boss.subscribe() methods.
AWS SQS doesn't guarantee exactly-once message delivery and that means that I could possibly publish the same message multiple times.
I have several ideas on how to implement this:

• One of them relies on sharing a transaction with pg-boss with my ORM, in this case Prisma. I can't seem to find a way to accomplish this
• The other one involves calling your SQL API – unfortunately there isn't an exposed SQL function for publishing/subscribing, similar to the create_queue and delete_queue which means I can't call those functions from my Prisma transaction either.
• The last one involves making a compound UNIQUE index on (id, name) and set the id to be the same as the message id from AWS. I was looking through some existing issues and came across this comment: Question regarding adding additional indexes #525 (comment) talking about not making UNIQUE indexes, which led me to believe that this isn't the right approach either.
  What would you suggest?

[timgit]

(id, name) is already a unique index in pg-boss, so that should work