DB-X

/** @jsxImportSource @db-x/runtime */
import { Column, Postgres, Table } from '@db-x/postgres-library';

// The single source of truth. Both runtimes below apply this exact tree.
export const schema = (
  <Postgres name="todos-db">
    <Table name="todos">
      <Column name="id" type="serial" primaryKey />
      <Column name="title" type="text" notNull />
      <Column name="done" type="boolean" notNull default="false" />
    </Table>
  </Postgres>
);

/** @jsxImportSource @db-x/runtime */
import { DatabaseTarget } from '@db-x/runtime';
import { schema } from './schema';

// Production: point at an existing RDS / Cloud SQL / Supabase URL.
export default (
  <DatabaseTarget url={process.env.DATABASE_URL!}>
    {schema}
  </DatabaseTarget>
);

/** @jsxImportSource @infra-x/runtime */
import { DockerCompose, Service } from '@infra-x/docker-library';
import { schema } from './schema';

// Local dev / CI: stand Postgres up in Compose, then apply the schema.
export default (
  <DockerCompose>
    <Service name="db" image="postgres:16-alpine">
      {schema}
    </Service>
  </DockerCompose>
);