@stitchdb/drizzle

Drizzle ORM adapter for StitchDB.

Install

npm install @stitchdb/drizzle drizzle-orm

Setup

import { drizzle } from '@stitchdb/drizzle'

const db = drizzle({ apiKey: process.env.STITCHDB_API_KEY })

Usage

import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core'
import { eq } from 'drizzle-orm'

const users = sqliteTable('users', {
  id: integer('id').primaryKey({ autoIncrement: true }),
  name: text('name').notNull(),
  email: text('email').notNull(),
})

// Select
const result = await db.select().from(users).where(eq(users.active, true))

// Insert
await db.insert(users).values({ name: 'Alice', email: 'alice@example.com' })

// Update
await db.update(users).set({ name: 'Bob' }).where(eq(users.id, 1))

// Delete
await db.delete(users).where(eq(users.id, 1))