Drizzle Logo

Drizzle Database Demo

Records

Powered by Drizzle ORM

PostgreSQL access for the local Docker database and Railway deployments

Setup Instructions:

  1. Start local Postgres with pnpm db:up, then confirm it is ready with pnpm db:readybefore adding records.
  2. Use .env.local for private overrides. If it does not set DATABASE_URL, the dev and Drizzle scripts fall back to .env.docker.
  3. For Railway, set Railway's DATABASE_URL in the deployment environment, or in .env.local when running against Railway from this machine.
  4. Generate and apply migrations with pnpm db:generate and pnpm db:migrate.
  5. Use pnpm db:push for prototype schema sync, pnpm db:pull to inspect the configured schema, pnpm db:studio or pnpm db:shell to inspect data, pnpm db:logs to debug the container, and pnpm db:down to stop the local database.