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

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

Local Development

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

1. Begin by cloning this repository to your machine:

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

2. Run the following:

   1
   cp .env.example .env
   2
   npm install

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

   1
   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:

   1
   TURSO_ORG=
   2
   TURSO_DATABASE_NAME=

   The TURSO_ORG can be your personal username, or the name of any organization you have with other users.

4. Run the following:

   1
   turso group tokens create <database-name>

   Now update .env to include the group token:

   1
   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 the following:

   1
   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. Run the following:

   1
   turso auth api-tokens mint clerk

   Then set the API token in the .env file:

   1
   TURSO_API_TOKEN=

1. Sign up to Clerk and create a new application.

   Add your Clerk public key and secret key to the .env file:

   1
   NEXT_PUBLIC_CLERK_PUBLISHABLE_KEY=
   2
   CLERK_SECRET_KEY=

2. Run the following:

   1
   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?

1. Open an issue on GitHub
2. Submit a Pull Request to improve this repo
3. Join us on Discord