yoink

yoink uses SeaORM as its Object-Relational Mapping (ORM) layer. This allows you to use either SQLite or PostgreSQL as your database backend.

The database connection is configured via the DATABASE_URL environment variable. The format of the URL depends on the database you choose:

For SQLite:

DATABASE_URL=sqlite://path/to/database.db
# By default:
DATABASE_URL=sqlite:/data/yoink.db?mode=rwc

For PostgreSQL:

DATABASE_URL=postgres://username:password@host:port/database_name

If you want to learn more about the database connection URL format and options, check out the SeaORM documentation.

yoink automatically runs database updates on startup.

This happens on application startup, so you may experience a delay if you have a large database or weaker hardware.

Database