Deploy an Express API with Postgres and sign-in

import express from "express";
import pg from "pg";

const pool = new pg.Pool({ connectionString: process.env.DATABASE_URL, max: 10 });

const app = express();
app.set("trust proxy", true);
app.use(express.json());

app.get("/health", (_req, res) => res.send("ok"));

// floo's gateway signed this person in and set the header.
app.get("/api/orders", async (req, res) => {
  const email = req.get("x-floo-user-email");
  const { rows } = await pool.query(
    "select id, item, quantity from orders where created_by = $1 order by id desc",
    [email],
  );
  res.json(rows);
});

app.post("/api/orders", async (req, res) => {
  const email = req.get("x-floo-user-email");
  const { item, quantity } = req.body;
  const { rows } = await pool.query(
    "insert into orders (item, quantity, created_by) values ($1, $2, $3) returning id",
    [item, quantity, email],
  );
  res.status(201).json(rows[0]);
});

const port = Number(process.env.PORT ?? 3000);
app.listen(port, "0.0.0.0", () => console.log(`listening on ${port}`));

[app]
name = "orders-api"
access_mode = "accounts"

[services.web]
type = "web"
path = "."
port = 3000
ingress = "public"
dev_command = "node --watch server.js"
migrate_command = "node scripts/migrate.js"

[managed.default]
type = "postgres"