Database

Database configuration, migrations, and troubleshooting.

What’s in this section

• Database Selection - Choosing between SQLite and PostgreSQL
• Migrations Guide - Database schema migrations with goose
• Migration Concurrency - Handling migrations in distributed systems
• PostgreSQL Setup - Docker Compose setup for PostgreSQL
• PostgreSQL Troubleshooting - Common PostgreSQL issues

Quick Decision

Use Case	Recommended Database
Development/Testing	SQLite (default)
Single instance production	SQLite or PostgreSQL
Multi-instance production	PostgreSQL
AWS ECS deployment	Aurora PostgreSQL Serverless v2

For production deployments, see the Database Selection Guide.

---

Table of contents

• Database Selection
• Migrations Guide
• Migration Concurrency
• PostgreSQL Docker Setup
• PostgreSQL Troubleshooting