Database
Configure database storage for your Storyden deployment.
Storyden supports multiple database backends, from lightweight embedded SQLite to distributed PostgreSQL-compatible systems. Each option offers different trade-offs between simplicity, performance, and operational requirements.
Configuration
Database configuration is controlled via the DATABASE_URL environment variable. The URL scheme determines which database driver Storyden uses.
Database Options
SQLite
Embedded, zero-config, production-ready.
PostgreSQL
Robust, scalable, industry standard.
Turso
Distributed SQLite with global replication.
The comparison table below summarizes the key differences:
| Feature | SQLite | PostgreSQL | Turso |
|---|---|---|---|
| Infrastructure | None required | Separate service | Managed service |
| Setup complexity | None | Medium | Low |
| Write scalability | Single writer | High | High |
| Read scalability | Excellent | Excellent | Global edge replicas |
| Multi-instance | With Litestream | Yes | Yes |
| Disk usage | Local file | Separate volume | Managed |
| Backups | File copy | pg_dump/WAL | Automatic |
Schema Management
Storyden handles database schema migrations automatically. On startup, the application compares the current schema against the expected schema and applies any necessary migrations. This means you never need to run manual migration commands.
The migration system is transactional and safe. If a migration fails, the database remains in its previous consistent state. Schema changes are versioned and tracked in the codebase, making it easy to understand what changed between versions.
Quick Reference
Environment Variables
See full configuration docs here.
| Variable | Required | Default | Description |
|---|---|---|---|
DATABASE_URL | No | sqlite://data/data.db?_pragma=foreign_keys(1) | Database connection URL |
Supported URL Schemes
sqlite://orsqlite3://- SQLite database (local file)postgres://orpostgresql://- PostgreSQL and CockroachDB.libsql://- Turso remote SQLite
Related Reading
- Search configuration - Database provider affects search performance
- Rate limiting - Rate limiting access if you are seeing database performance issues due to unexpected read-heavy traffic
- Cache configuration - Reduces database load for read-heavy workloads