Docs

Primary application database

PostgreSQL

Single PostgreSQL database backs the entire application.

Environments

Environment Database name Notes
Development expeditedssl_development Synced from production via bin/scheduled-db-pull
Test expeditedssl_test Used by Minitest suite
Production Heroku Postgres add-on Attached to app-sslendpoint

Extensions

  • plpgsql
  • pg_stat_statements
  • pg_trgm

Key tables

Notes

  • Schema source of truth: db/schema.rb
  • Local dev DB is a near-prod sync — prefer bin/rails runner for read-only investigation over heroku run.