Drizzle <> SQLite

Drizzle 原生支持使用 libsql 和 better-sqlite3 驱动程序连接 SQLite。

在使用这两种驱动程序并将其与 Drizzle ORM 集成时，我们发现它们之间有一些差异。例如：

在驱动程序层面，这两者之间可能没有太多差异，但主要的区别在于 libSQL 可以连接到 SQLite 文件和 Turso 远程数据库。LibSQL 是 SQLite 的一个分支，提供了比标准 SQLite 更多的功能，例如：

libSQL 驱动程序支持更多的 ALTER 语句，使您能够比仅使用 better-sqlite3 更轻松地管理您的模式。
您可以原生配置静态加密功能。
libSQL 还支持 SQLite 数据库支持的大量扩展。

libsql

第一步 - 安装包

npm

yarn

pnpm

bun

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

yarn add drizzle-orm @libsql/client
yarn add -D drizzle-kit

pnpm add drizzle-orm @libsql/client
pnpm add -D drizzle-kit

bun add drizzle-orm @libsql/client
bun add -D drizzle-kit

第二步 - 初始化驱动程序并执行查询

Drizzle 原生支持所有 @libsql/client 驱动程序变体：


`@libsql/client`	defaults to `node` import, automatically changes to `web` if `target` or `platform` is set for bundler, e.g. `esbuild --platform=browser`
`@libsql/client/node`	`node` compatible module, supports `:memory:`, `file`, `wss`, `http` and `turso` conneciton protocols
`@libsql/client/web`	module for fullstack web frameworks like `next`, `nuxt`, `astro`, etc.
`@libsql/client/http`	module for `http` and `https` connection protocols
`@libsql/client/ws`	module for `ws` and `wss` conneciton protocols
`@libsql/client/sqlite3`	module for `:memory:` and `file` conneciton protocols
`@libsql/client-wasm`	Separate experimental package for WASM

default

node

web

http

web sockets

wasm

import { drizzle } from 'drizzle-orm/libsql';

const db = drizzle({ connection: {
  url: process.env.DATABASE_URL, 
  authToken: process.env.DATABASE_AUTH_TOKEN 
}});

import { drizzle } from 'drizzle-orm/libsql/node';

const db = drizzle({ connection: {
  url: process.env.DATABASE_URL, 
  authToken: process.env.DATABASE_AUTH_TOKEN 
}});

import { drizzle } from 'drizzle-orm/libsql/web';

const db = drizzle({ connection: {
  url: process.env.DATABASE_URL, 
  authToken: process.env.DATABASE_AUTH_TOKEN 
}});

import { drizzle } from 'drizzle-orm/libsql/http';

const db = drizzle({ connection: {
  url: process.env.DATABASE_URL, 
  authToken: process.env.DATABASE_AUTH_TOKEN 
}});

import { drizzle } from 'drizzle-orm/libsql/ws';

const db = drizzle({ connection: {
  url: process.env.DATABASE_URL, 
  authToken: process.env.DATABASE_AUTH_TOKEN 
}});

import { drizzle } from 'drizzle-orm/libsql/wasm';

const db = drizzle({ connection: {
  url: process.env.DATABASE_URL, 
  authToken: process.env.DATABASE_AUTH_TOKEN 
}});

Step 3 - make a query

libsql

libsql with config

import { drizzle } from 'drizzle-orm/libsql';

const db = drizzle(process.env.DATABASE_URL);
 
const result = await db.execute('select 1');

import { drizzle } from 'drizzle-orm/libsql';

// 您可以指定 libsql 连接选项中的任何属性
const db = drizzle({ connection: { url:'', authToken: '' }});
 
const result = await db.execute('select 1');

如果您需要同步连接，可以使用我们的额外连接 API，在该 API 中您指定驱动程序连接并将其传递给 Drizzle 实例。

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

const client = createClient({ url: process.env.DATABASE_URL, authToken: process.env.DATABASE_AUTH_TOKEN });
const db = drizzle(client);

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

better-sqlite3

第一步 - 安装包

npm

yarn

pnpm

bun

npm i drizzle-orm better-sqlite3
npm i -D drizzle-kit @types/better-sqlite3

yarn add drizzle-orm better-sqlite3
yarn add -D drizzle-kit @types/better-sqlite3

pnpm add drizzle-orm better-sqlite3
pnpm add -D drizzle-kit @types/better-sqlite3

bun add drizzle-orm better-sqlite3
bun add -D drizzle-kit @types/better-sqlite3

第二步 - 初始化驱动程序并执行查询

better-sqlite3

better-sqlite3 with config

import { drizzle } from 'drizzle-orm/better-sqlite3';

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

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

import { drizzle } from 'drizzle-orm/better-sqlite3';

// 您可以指定 better-sqlite3 连接选项中的任何属性
const db =  drizzle({ connection: { source: process.env.DATABASE_URL }});

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

如果您需要提供现有的驱动程序：

import { drizzle } from 'drizzle-orm/better-sqlite3';
import Database from 'better-sqlite3';

const sqlite = new Database('sqlite.db');
const db = drizzle({ client: sqlite });

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