Database
Database configuration, migrations, and troubleshooting.
What’s in this section
- Database Selection - Choosing between SQLite, PostgreSQL, and MySQL
- Migrations Guide - Database schema migrations with goose
- Migration Concurrency - Handling migrations in distributed systems
- PostgreSQL Setup - Docker Compose setup for PostgreSQL
- MySQL Setup - Docker Compose setup for MySQL
- 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 or MySQL |
| AWS ECS deployment | Aurora PostgreSQL Serverless v2 or Aurora MySQL |
| AWS RDS MySQL | MySQL 8.4+ |
For production deployments, see the Database Selection Guide.