Turso Per User Starter

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.

https://turso-per-user-starter.vercel.app

Get Started

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

• 

  • 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

• 

  • 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.

Local Development

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

1. Clone this repository

   Begin by cloning this repository to your machine:

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

2. Install dependencies and initialize .env

   Run the following:

   cp .env.example .env
   npm install

3. Create a new SQLite schema database with Turso

   Follow the instructions to install the Turso CLI, and then run the following:

   turso db create <database-name> --type schema

   Alternatively, you can sign up on the web, and create a new schema database from there.

   Now update .env to include your organization, and schema 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.

4. Create a new group token

   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.

5. Run database migrations

   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.

6. Create a new Turso API Token

   Run the following:

   turso auth api-tokens mint clerk

   Then set the API token in the .env file:

   TURSO_API_TOKEN=

7. Configure Clerk

   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=

8. Run the application

   Run the following:

   npm run dev

   Now open http://localhost:3000 with your browser to try out the app!

Optional: Webhook setup

You can automate the creation of databases per user in the background with webhooks.

Read the wiki for more information on how to set up webhooks with Clerk during development, and production.

Tech Stack

• Turso for multi-tenant databases
• Next.js for powerful full stack apps
• Tailwind CSS for utility-first CSS
• Drizzle for database migrations and ORM
• Clerk for authentication
• Vercel for hosting

Need help?

Warning

Turso Multi-DB Schemas are currently in beta.

Join us on Discord