Drizzle <> Gel

This guide assumes familiarity with:

Drizzle과의 데이터베이스 연결 기본사항
gel-js 기본사항

Drizzle는 gel-js 클라이언트를 사용하여 Gel 연결을 기본적으로 지원합니다.

1단계 - 패키지 설치

npm

yarn

pnpm

bun

npm i drizzle-orm gel
npm i -D drizzle-kit

yarn add drizzle-orm gel
yarn add -D drizzle-kit

pnpm add drizzle-orm gel
pnpm add -D drizzle-kit

bun add drizzle-orm gel
bun add -D drizzle-kit

2단계 - 드라이버 초기화 및 쿼리 작성

gel

gel with config

// Make sure to install the 'gel' package
import { drizzle } from 'drizzle-orm/gel';

const db = drizzle(process.env.DATABASE_URL);

const result = await db.execute('select 1');

// Make sure to install the 'gel' package
import { drizzle } from "drizzle-orm/gel";

// You can specify any property from the gel connection options
const db = drizzle({
  connection: {
    dsn: process.env.DATABASE_URL,
    tlsSecurity: "default",
  },
});

const result = await db.execute("select 1");

기존 드라이버를 제공해야 하는 경우:

// Make sure to install the 'gel' package 
import { drizzle } from "drizzle-orm/gel";
import { createClient } from "gel";

const gelClient = createClient();
const db = drizzle({ client: gelClient });

const result = await db.execute('select 1');

다음 단계는?

Manage schema

Drizzle Schema PostgreSQL data types Indexes and Constraints Database Views Database Schemas Sequences Extensions

Query data

Relational Queries Select Insert Update Delete Filters Joins sql`` operator