This is an example of how to integrate Turso database with the Epic Stack.

You need to add the database URL and access token as environment variables:

TURSO_DATABASE_URL=
TURSO_AUTH_TOKEN=

You can get both values on the Turso web app or using the Turso CLI.

If you decided to use the CLI, you can create a database named epic-stack-example by running the following command:

turso db create epic-stack-example

To get the URL of your database, run the command below and set its result to TURSO_DATABASE_URL:

turso db show epic-stack-example --url

In the same way, to get a database token, run the command below and set its result to TURSO_AUTH_TOKEN:

turso db tokens create epic-stack-example

Seed your database with this command:

turso db shell epic-stack-example < prisma/migrations/20230914194400_init/migration.sql

To apply migrations to your database, run the migrate command:

npx prisma migrate dev --name add_subtitle_to_notes

Then, copy the migration file path from the new migration folder and run turso db shell:

turso db shell epic-stack-example < prisma/migrations/20240402084116_add_subtitle_to_notes/migration.sql