docker compose online stellen.

1# Local only. On run.zero, run-zero.yaml applies.2services:3  web:4    build: ./web5    ports:6      - "8080:8080"7    environment:8      PORT: "8080"9      DATABASE_URL: postgres://app:app@db:5432/app10    depends_on:11      - db12  db:13    image: postgres:16-alpine14    environment:15      POSTGRES_USER: app16      POSTGRES_PASSWORD: app17      POSTGRES_DB: app18    volumes:19      - db-data:/var/lib/postgresql/data20volumes:21  db-data:

1version: "1"2services:3  web:4    path: ./web5    port: 80806  whoami:7    image: docker.io/traefik/whoami:v1.108    port: 80809    env:10      WHOAMI_PORT_NUMBER: "8080"11addons:12  db:13    type: postgres14    attachTo: [web]

1// Web service of the compose example. Locally DATABASE_URL comes from docker-compose.yml, on run.zero from the postgres addon.2const express = require('express');3const { Pool } = require('pg');45const port = process.env.PORT || 8080;6const url = process.env.DATABASE_URL;7// run.zero: the addon URL carries sslmode=require against a self-signed cert, so drop it and pass ssl explicitly.8const onPlatform = !!url && url.includes('sslmode=');9const pool = url10  ? new Pool({11      connectionString: onPlatform ? url.replace(/[?&]sslmode=[^&]*/, '') : url,12      ssl: onPlatform ? { rejectUnauthorized: false } : false,13    })14  : null;1516async function countVisit() {17  await pool.query('CREATE TABLE IF NOT EXISTS visits (id serial PRIMARY KEY, at timestamptz DEFAULT now())');18  await pool.query('INSERT INTO visits DEFAULT VALUES');19  const { rows } = await pool.query('SELECT count(*)::int AS n FROM visits');20  return rows[0].n;21}2223const app = express();2425app.get('/', async (req, res) => {26  const visits = pool ? await countVisit() : 'no database attached';27  res.type('html').send(`<!doctype html>28<html lang="en"><head><meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1">29<title>docker compose on run.zero</title></head>30<body style="font-family:system-ui,sans-serif;max-width:640px;margin:64px auto;padding:0 24px">31<h1>docker compose on run.zero</h1>32<p>The web service came from ./web, the database from the postgres addon. Visits stored in Postgres: <strong id="visits">${visits}</strong></p>33<p><a href="/api/health">/api/health</a></p>34</body></html>`);35});3637app.get('/api/health', (req, res) => res.json({ status: 'ok', database: !!pool, platform: 'run.zero' }));3839app.listen(port, () => console.log(`listening on ${port}`));

1{2  "name": "run-zero-example-compose-web",3  "version": "1.0.0",4  "private": true,5  "engines": { "node": "22.x" },6  "scripts": { "start": "node server.js" },7  "dependencies": { "express": "^4.21.2", "pg": "^8.13.1" }8}