Database

LaunchSaaS uses PostgreSQL with Drizzle ORM for type-safe database operations. This guide covers database configuration and setup.

Setup

Create a Database

Recommended to use hosted PostgreSQL database services. They provide easy setup and management, and often include free tiers sufficient for getting started.

Neon (Recommended)

Neon is a serverless PostgreSQL service with an excellent developer experience.

Setup Steps:

1. Create an account at neon.tech
2. Create a new project
3. Create a database
4. Get your connection string from the dashboard
5. Add the connection string to your .env file:

DATABASE_URL="postgres://user:[email protected]/database?sslmode=require"

Supabase

Supabase provides PostgreSQL databases with additional features like authentication and storage.

Setup Steps:

1. Create an account at supabase.com
2. Create a new project
3. Click on the Connect button
4. Get your connection string in Transaction pooler section
5. Add the connection string to your .env file:

DATABASE_URL="postgres://postgres:[email protected]:6543/postgres"

Initialize the Database

After configuring your database URL, initialize the database:

npm run init

This command will:

1. Generate the Drizzle migrations
2. Apply migrations to your database
3. Create the admin user

Other Database Options

Self-Hosted

Docker

Run PostgreSQL in a Docker container for local development:

docker run --name launchsaas-postgres -e POSTGRES_PASSWORD=mypassword -d -p 5432:5432 postgres

Connection string:

DATABASE_URL="postgres://postgres:mypassword@localhost:5432/postgres"

Local Installation

Install PostgreSQL directly on your machine from postgres.org.

Other Hosted Services

• Railway
• Vercel Postgres
• AWS RDS
• Google Cloud SQL

Database Commands

Schema Organization

Database schemas are located in src/schemas/tables/:

FAQ

Connection Issues

If you're having trouble connecting to your database:

1. Check that your DATABASE_URL is correctly formatted
2. Ensure your IP is allowed in the database's firewall settings
3. Verify that the database user has the correct permissions
4. Check for any network restrictions

Migration Issues

If you're experiencing issues with database migrations:

1. Check your schema definitions for errors
2. Ensure your migration scripts are correctly formatted
3. Try running migrations manually to see detailed errors

References

• Neon Documentation
• Supabase Documentation
• Drizzle ORM Documentation
• Drizzle with Neon
• Drizzle with Supabase

Next Steps