Database

Stashy auto-detects the database driver from the DATABASE_URL connection string.

Supported Databases

DSN prefix	Database
`file:stashy.db`	SQLite (default)
`postgres://user:pass@host/db`	PostgreSQL

Zero-config — just works out of the box:

DATABASE_URL=file:stashy.db  # default

Good for single-instance deployments. The file is created automatically.

DATABASE_URL=postgres://stashy:secret@localhost:5432/stashy?sslmode=disable

Recommended for production multi-instance setups.

Migrations are managed by goose. Run them with:

stashy migrate              # run migrations and exit
stashy serve --migrate      # run migrations then start server

Always run migrations before starting a new version of Stashy.