A private Postgres for every app.

CREATE TABLE customers (
  id          BIGSERIAL PRIMARY KEY,
  name        TEXT NOT NULL,
  email       TEXT,
  balance_cents INTEGER NOT NULL DEFAULT 0,
  created_at  TIMESTAMP NOT NULL DEFAULT now()
);

CREATE INDEX idx_customers_email
  ON customers(email);

import { db } from 'hatchable';

export const access = 'member';

export default async function (req, res) {
  const { rows } = await db.query(
    `SELECT name, balance_cents
       FROM customers
      ORDER BY balance_cents DESC
      LIMIT $1`,
    [20]
  );
  res.json({ customers: rows });
}