Turso/SQLite

Turso is a cloud database provider built on libSQL.

• Global data distribution with low latency access
• Built-in replication and high availability
• Serverless architecture with zero maintenance

libSQL is an open source fork of SQLite that. The Turso team actively maintains and develops both libSQL and Turso.

Supersaas integrates natively with Turso. This guide will walk you through setting up Turso with your Supersaas application.

Checkout to the Turso branch

1. First, checkout the turso branch of the repository:

git checkout turso

2. Add your turso credentials to your .env file:

TURSO_DB_URL=libsql://XXXX-XXXX-XXXX.turso.io
TURSO_DB_TOKEN=XXXXXXXX

That's it! The schema, migrations, and database configuration are already set up for you in the turso branch.

Setting up S3 storage

Since we removed NuxtHub, we need to set up S3 storage manually and Supersaas uses Unjs Unstorage as a unified storage layer with the S3 driver for file operations.

The configuration is already handled for you once these environment variables are set.

S3_ACCESS_KEY_ID=XXXXXXXXX
S3_SECRET_ACCESS_KEY=XXXXXXXXXX
S3_BUCKET=your-bucket-name
S3_REGION=your-region
S3_ENDPOINT=your-endpoint
S3_PUBLIC_ENDPOINT=your-public-endpoint

This will work with any S3 compatible storage service.

• AWS S3
• Cloudflare R2
• Digital Ocean Spaces

Package.json Changes

When you switch to the turso branch, the package.json is automatically updated to remove NuxtHub-related dependencies and include the necessary Postgres packages.

Next Steps

Once you've set up your database and storage:

1. Run your migrations - see migrations
2. Start your development server
3. Test file uploads to ensure S3 is configured correctly

You're now ready to use Supersaas with Turso and AWS S3!