DB

We are using turso and sqlite as database to store user/page/monitor settings. The timeseries data is stored in a tinybird datasource (built on top of ClickHouse).

Local Development

Install the Turso CLI.

For local environment, first install sqld.

When installing with Homebrew, follow:

$ brew tap libsql/sqld
$ brew install sqld-beta
$ sqld --help

If you want to keep your database locally, run:

$ turso dev --db-file openstatus.db

It will create a local database in the directory you run the command.

Add the environment variables to inside of the .env file in both projects, the /apps/web and /packages/db:

DATABASE_URL=http://127.0.0.1:8080
DATABASE_AUTH_TOKEN=any-token # no need to change token

Start the migration script inside of /packages/db to have the database schema up to date:

$ pnpm migrate

You should be ready to go! Check out the Drizzle Studio to see if your tables have been created:

$ pnpm studio