2 replies

Connection management with Drizzle

I'm seeing lots of examples from AI assistants that implement complex connection management like this class-based example (attached image). However, in the Drizzle docs, the setup is much simpler:

import { drizzle } from 'drizzle-orm/bun-sqlite';
import { Database } from 'bun:sqlite';

const sqlite = new Database('sqlite.db');
const db = drizzle(sqlite);

import { drizzle } from 'drizzle-orm/bun-sqlite';
import { Database } from 'bun:sqlite';

const sqlite = new Database('sqlite.db');
const db = drizzle(sqlite);

Question:
- Do we actually need to implement connection management (opening/closing) ourselves when using Drizzle, or does Drizzle handle this for us?
Specifically:
- Is the simple setup from the docs sufficient for production use?
- Do we need to manually close connections when using Drizzle?
- Should we implement connection pooling or is it unnecessary with SQLite + Drizzle?

Drizzle Team•12mo ago•

2 replies

bkyerv

Connection management with Drizzle

I'm seeing lots of examples from AI assistants that implement complex connection management like this class-based example (attached image). However, in the Drizzle docs, the setup is much simpler:

import { drizzle } from 'drizzle-orm/bun-sqlite';
import { Database } from 'bun:sqlite';

const sqlite = new Database('sqlite.db');
const db = drizzle(sqlite);

import { drizzle } from 'drizzle-orm/bun-sqlite';
import { Database } from 'bun:sqlite';

const sqlite = new Database('sqlite.db');
const db = drizzle(sqlite);

Connection management with Drizzle

Similar Threads

Connection management with Drizzle

Similar Threads

Similar Threads

Similar Threads