Drizzle <> PGlite

According to the official repo, PGlite is a WASM Postgres build packaged into a TypeScript client library that enables you to run Postgres in the browser, Node.js and Bun, with no need to install any other dependencies. It is only 2.6mb gzipped.

It can be used as an ephemeral in-memory database, or with persistence either to the file system (Node/Bun) or indexedDB (Browser).

Unlike previous “Postgres in the browser” projects, PGlite does not use a Linux virtual machine - it is simply Postgres in WASM.

Step 1 - Install packages

npm i drizzle-orm @electric-sql/pglite
npm i -D drizzle-kit

yarn add drizzle-orm @electric-sql/pglite
yarn add -D drizzle-kit

pnpm add drizzle-orm @electric-sql/pglite
pnpm add -D drizzle-kit

bun add drizzle-orm @electric-sql/pglite
bun add -D drizzle-kit

Step 2 - Initialize the driver and make a query

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

const db = drizzle('pglite');

await db.select().from(...);

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

const db = drizzle('pglite', 'path-to-dir');

await db.select().from(...);

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

// connection is a native PGLite configuration
const db = drizzle('pglite', { connection: { dataDir: 'path-to-dir' }});

await db.select().from(...);

If you need a synchronous connection, you can use our additional connection API, where you specify a driver connection and pass it to the Drizzle instance.

import { PGlite } from '@electric-sql/pglite';
import { drizzle } from 'drizzle-orm/pglite';

// In-memory Postgres
const client = new PGlite();
const db = drizzle(client);

await db.select().from(users);

What’s next?