X (Twitter)

pnpm run db:generate # Generate the Drizzle client
pnpm run db:migrate # Migrate the database

npm run db:generate # Generate the Drizzle client
npm run db:migrate # Migrate the database

yarn db:generate

src/db/index.ts

// 1. Install: npm install drizzle-orm mysql2
// 2. Update src/db/index.ts
import { drizzle } from 'drizzle-orm/mysql2';
import mysql from 'mysql2/promise';

const connection = await mysql.createConnection(process.env.DATABASE_URL!);

src/db/index.ts

// 1. Install: npm install drizzle-orm better-sqlite3
// 2. Update src/db/index.ts
import { drizzle } from 'drizzle-orm/better-sqlite3';
import Database from 'better-sqlite3';

const sqlite = new Database('sqlite.db');
const db

Database | MkSaaS - Make Your AI SaaS Product in a Weekend

Database

Setup

Create a database

Neon (Recommended)

Supabase

Initialize the database

Environment Setup

Create a database (other options)

Other Hosted Services

Self-Hosted Options

Docker

Local Installation

Using Drizzle ORM

Current Configuration

Database Schema

Using Other Database Providers

Example: Using MySQL

Example: Using SQLite

Connect to the database

FAQ

Connection Issues

Schema Migration Issues

Database Cost Issues

References

Video Tutorial

Next Steps

Authentication

Email Setup

Newsletter

Environment Setup

Table of Contents