Why We Chose Drizzle

While Prisma paved the way for type-safe database access in the TypeScript ecosystem, its rust-engine baseline and cold starts made it sub-optimal for heavily distributed serverless environments.

Drizzle gives us zero-dependency SQL-like syntax that runs at the edge, offering absolute type safety right down to our SQL queries.

Initializing the Schema

Drizzle lets you declare your entire database in pure TypeScript. No proprietary schema files required.

import { pgTable, serial, text, timestamp } from "drizzle-orm/pg-core";

export const users = pgTable("users", {
  id: serial("id").primaryKey(),
  name: text("name").notNull(),
  email: text("email").notNull().unique(),
  createdAt: timestamp("created_at").defaultNow(),
});

Edge-Ready Connections

By pairing Drizzle with Serverless Postgres (like Neon or Supabase), your database scales precisely with your serverless functions without exhausting connection pools.

import { neon } from "@neondatabase/serverless";
import { drizzle } from "drizzle-orm/neon-http";
import * as schema from "./schema";

const sql = neon(process.env.DATABASE_URL!);
export const db = drizzle(sql, { schema });