Neon Postgres

Database production memakai Neon — Postgres serverless. Connection string disimpan di .env.production.local (bukan di .env shared kalau beda dengan DB lokal).

Console: console.neon.tech
Docs: neon.com/docs

Env di project

# .env.production.local (override prod)
DATABASE_URL=postgresql://user:pass@ep-xxx-pooler.region.aws.neon.tech/neondb?sslmode=require

Dev lokal biasanya Postgres di laptop — override di .env.development.local:

DATABASE_URL=postgresql://trainerhub_beta:...@127.0.0.1:5432/trainerhub_beta_clean

Setup Neon (pertama kali)

Buat project

Neon Console → New Project → pilih region (dekat user / Cloudflare)

Ambil connection string

Project Dashboard → tombol Connect → pilih:

Branch: main / production
Connection pooling: ON (hostname berisi -pooler) — disarankan untuk Workers
Copy string postgresql://...

Simpan aman

Paste ke .env.production.local sebagai DATABASE_URL.
Jangan commit — file ini di-gitignore.

Migrate saat deploy

./thub deploy / deploy-prod.sh menjalankan migrate SQL ke DATABASE_URL production.

Pooled vs direct

Tipe	Kapan dipakai
Pooled (`-pooler` di hostname)	Runtime app, Workers via Hyperdrive
Direct (tanpa pooler)	Migration berat, `psql`, tooling satu koneksi panjang

Neon docs: Connection pooling

Verifikasi koneksi

./thub env merge --prod
psql "$DATABASE_URL" -c "SELECT 1"
./thub doctor

CI/CD (GitHub Actions)

Secret DATABASE_URL di environment production — isi sama dengan Neon production. Script ci-materialize-env.sh menulis ke .env.production.local sebelum deploy.

Troubleshooting

Masalah	Solusi
SSL required	Pastikan `?sslmode=require` di URL
Too many connections	Pakai pooled URL atau Hyperdrive
Migrate gagal di CI	Cek IP allowlist Neon (biasanya open untuk Neon cloud)
Doctor DB merah di lokal	Normal jika Postgres lokal belum jalan — override dev URL

Mulai

Panduan

AI & Dokumen

Layanan eksternal

Arsitektur

Env di project

Setup Neon (pertama kali)

Pooled vs direct

Verifikasi koneksi

CI/CD (GitHub Actions)

Troubleshooting

​Env di project

​Setup Neon (pertama kali)

​Pooled vs direct

​Verifikasi koneksi

​CI/CD (GitHub Actions)

​Troubleshooting

Env di project

Setup Neon (pertama kali)

Pooled vs direct

Verifikasi koneksi

CI/CD (GitHub Actions)

Troubleshooting