Database Setup

Database Setup

Documentation for database architecture, setup, migration, and backend evaluation.

Contents

Neon PostgreSQL (Primary Database)

• Neon Migration Summary — Complete record of the D1 → Neon migration, including scope, decisions, schema, CI/CD, and cross-references
• Neon Setup — Production configuration, Hyperdrive connection pooling, Prisma integration
• Neon Branching — Automated branch-per-PR workflows via GitHub Actions
• Migration Checklist — One-time D1 → Neon data migration steps and verification
• Edge Cache Architecture — D1 as L1 edge cache with Neon as the primary store

Prisma ORM

• Prisma Schema Reference — Field-level documentation for all 14 models
• Prisma Deno Compatibility — Import rewriting and --env flag notes for Deno

Architecture & Evaluation

• Database Architecture — Schema design and storage layer overview
• Local Development Setup — Neon cloud or Docker PostgreSQL for local development
• PostgreSQL Modern — Modern PostgreSQL features and configuration
• Database Evaluation — PlanetScale vs Neon vs Cloudflare vs Prisma comparison
• Prisma Evaluation — Storage backend and ORM comparison
• Migration Plan — Original migration planning document

Quick Start

# One-command project setup (copies env templates, generates Prisma client)
deno task setup

# Or start a local Docker PostgreSQL
deno task db:local:up

Related

• Cloudflare D1 — Edge database / cache integration
• Better Auth + Prisma — Auth provider database integration
• Neon Troubleshooting — Diagnosing connection and migration issues
• Database Testing — Testing patterns for Prisma + Neon