Turso Per User Starter - Vercel

Turso Per User Starter

Demo multi-tenancy with the Turso Platforms API

A Next.js application that demonstrates how to use the Turso Platforms API to create a database per user.

Demo

The app below uses a database per user, and is powered by Turso.

Deploy your own Turso powered platform in a few easy steps...

Create a Database
- Once the database is created, you'll be presented with details about your database, and Connect details
- Note down the following (you'll need these later):
  - Database name
  - Org name
  - Group Token (Create Group Token -> Create Token)
  - Platform API Token (Create Platform API Token -> Insert memorable name -> Create Token))
Sign up to Clerk
- Create a new application from the dashboard
- Note down the following (you'll need these later):
  - Public key
  - Secret key
Deploy with Vercel
- Add the following environment variables (from the details you noted down earlier):
  - NEXT_PUBLIC_CLERK_PUBLISHABLE_KEY - Clerk public key
  - CLERK_SECRET_KEY - Clerk secret key
  - TURSO_API_TOKEN - Platform API Token
  - TURSO_ORG - Org name
  - TURSO_DATABASE_NAME - Database name
  - TURSO_GROUP_AUTH_TOKEN - Group Token
- Click Deploy and you're done!

You may optionally set up webhooks to automate the creation of databases in the background — learn more.

Start building your Turso powered platform in a few simple steps...

Begin by cloning this repository to your machine:

git clone https://github.com/notrab/turso-per-user-starter.git
cd turso-per-user-starter

Run the following:
```
cp .env.example .env
npm install
```
Follow the instructions to install the Turso CLI, and then run the following:
```
turso db create <database-name>
```
Alternatively, you can sign up on the web, and create a new database from there.

Now update .env to include your organization, and database name:
```
TURSO_ORG=
TURSO_DATABASE_NAME=
```
The TURSO_ORG can be your personal username, or the name of any organization you have with other users.
Run the following:
```
turso group tokens create <database-name>
```
Now update .env to include the group token:
```
TURSO_GROUP_AUTH_TOKEN=
```
If you didn't already have one, a new group will be created for you with the name default.
Run the following:
```
npm run db:migrate
```
If you make changes to db/schema.ts, make sure to run npm run db:generate to create the migrations, and npm run db:migrate to apply them.
Run the following:
```
turso auth api-tokens mint clerk
```
Then set the API token in the .env file:
```
TURSO_API_TOKEN=
```

Sign up to Clerk and create a new application.

Add your Clerk public key and secret key to the .env file:
```
NEXT_PUBLIC_CLERK_PUBLISHABLE_KEY=
CLERK_SECRET_KEY=
```
Run the following:
```
npm run dev
```
Now open http://localhost:3000 with your browser to try out the app!