Turso + Drizzle — 엣지 데이터베이스 풀스택 구축

프로젝트 설정

npm install drizzle-orm @libsql/client
npm install -D drizzle-kit

Drizzle + Turso

import { drizzle } from "drizzle-orm/libsql";
import { createClient } from "@libsql/client";

const client = createClient({
  url: process.env.TURSO_URL!,
  authToken: process.env.TURSO_TOKEN!,
});

const db = drizzle(client);

// 쿼리
const posts = await db.select().from(postsTable)
  .where(eq(postsTable.published, true))
  .orderBy(desc(postsTable.createdAt))
  .limit(20);

임베디드 레플리카

const client = createClient({
  url: "file:local.db",  // 로컬 레플리카
  syncUrl: process.env.TURSO_URL!,
  authToken: process.env.TURSO_TOKEN!,
});