Deploy with Supabase

​

Requirements

• docker
• time

​

Set up your project

1. Create a project dir and grab the latest .env template

mkdir trigger-docker && cd trigger-docker
curl -L https://github.com/triggerdotdev/docker/raw/main/.env.example > .env

2. Generate secrets with openssl rand -hex 16 for the following variables:

...
MAGIC_LINK_SECRET=15600f1236e568d6c9c400a94e16a4ed
SESSION_SECRET=8d92078940c89588fc8b6f5481f2c6e0
ENCRYPTION_KEY=1189c93e399856a2a9a1454496171b2e
...

​

Create a Supabase DB

1. No account yet? Click here to complete onboarding

2. Create a new project

3. Make a note of your password, we’ll need it in a moment

4. Wait until your project has finished setting up

5. Navigate to Project Settings -> Database and copy your database connection string

6. Paste it into your .env file, and append ?schema=triggerdotdev

...
DATABASE_URL=postgresql://postgres:<PASSWORD>@db.<ID>.supabase.co:5432/postgres?schema=triggerdotdev
...

7. The complete file should look something like this now:

LOGIN_ORIGIN=http://localhost:3030
APP_ORIGIN=http://localhost:3030
PORT=3030
REMIX_APP_PORT=3030

MAGIC_LINK_SECRET=15600f1236e568d6c9c400a94e16a4ed
SESSION_SECRET=8d92078940c89588fc8b6f5481f2c6e0
ENCRYPTION_KEY=1189c93e399856a2a9a1454496171b2e

DATABASE_URL=postgresql://postgres:<PASSWORD>@db.<ID>.supabase.co:5432/postgres?schema=triggerdotdev
DIRECT_URL=${DATABASE_URL}

NODE_ENV=development
RUNTIME_PLATFORM=docker-compose

​

Self-host Trigger.dev with docker compose

1. Create a docker compose file in your project dir

---
version: "3.8"

services:
  triggerdotdev:
    image: ghcr.io/triggerdotdev/trigger.dev:latest
    container_name: triggerdotdev
    restart: unless-stopped
    env_file:
      - .env
    ports:
      - 3030:3030

2. Start your docker container

docker compose up

3. Wait for the database setup to finish - this might take a while

4. You should now be able to visit http://localhost:3030 and see this screen:

5. Click “Continue with Email”, enter your email address and hit submit

6. Grab the magic link from your terminal and proceed with account creation

7. If everything went well, the triggerdotdev and graphile_worker schemas should now be populated. Check your Supabase DB dashboard to be sure:

8. Congratulations, you’re all set up and ready to go with Supabase and Docker! 🚀

​

Bonus: Connection pooling

​

What is connection pooling?

Connection Pool - © 2023 Supabase, Apache License 2.0

When running on a single server, our app can be trusted to manage its own connections - it knows how many are open and can process its internal queue as needed.

Serverless🐝 changes things. Here, many concurrent app instances are started, each unaware of the others’ connections. This can lead to a huge - potentially fatal - increase in connections straight to your DB.

External connection pools solve this by putting an additional layer between client and server, which essentially works like a message queue that gets processed as limits allow. The clients are blind to this and can keep sending their requests as before.

​

Enable connection pooling

1. Copy and paste the connection string from earlier to DIRECT_URL

...
DIRECT_URL=postgresql://postgres:<PASSWORD>@db.<ID>.supabase.co:5432/postgres?schema=triggerdotdev
...

2. Navigate to Project Settings -> Database and copy your connection pool URL

3. Paste it into your .env file next to DATABASE_URL

4. Append ?schema=triggerdotdev&pgbouncer=true and insert your password

...
# notice the differing ports and additional query param
DATABASE_URL=postgresql://postgres:<PASSWORD>@db.<ID>.supabase.co:6543/postgres?schema=triggerdotdev&pgbouncer=true
DIRECT_URL=postgresql://postgres:<PASSWORD>@db.<ID>.supabase.co:5432/postgres?schema=triggerdotdev
...

5. All done! You can now enjoy the benefits of connection pooling ⚡️

​

Next steps