Today we're releasing
Supabase Queues is a Postgres-native, durable Message Queue with guaranteed delivery, improving the scalability and resiliency of your applications. It's designed to work seamlessly with the entire Supabase platform.
Supabase Queues is built on the pgmq extension by the team at wherever possible, and the Tembo team have generously licensed their extension with the OSI-compatible for SQL.
Types of Queues
There are several types of queues available:
Adding Messages from the Dashboard
Let's create a new Basic Queue and add a Message.
to your Postgres database from a server, you can add messages using SQL from any Postgres client:
select * from pgmq.send(
queue_name => 'foo',
msg => '{ "hello": "world" }',
);
Adding messages from the client
We have provided several functions that can be invoked from the . There are several functions defined in the pgmq_public schema: send, send_batch, read, pop, archive, delete. You can find more details in the . If you expose this schema, you must use
The postgres and service_role roles receive permissions by default and should remain enabled for server-side operations.
Monitoring Queues and Messages
You can use the Dashboard to inspect your Messages, including: status, number of retries, and payload. You can also postpone, archive, or delete messages at any time.
From the Queues page, just click on a Queue to inspect it. From there you can click on a message to see more details:
in your project.
SOCIAL SHARE CARD GENERATOR