[BUG]: No way to use `bun:sqlite` together with dirzzle-kit

[TheKnarf]

What version of drizzle-orm are you using?

v0.29.0

What version of drizzle-kit are you using?

v0.20.1

Describe the Bug

Ran the following command where driver is set to bun:sqlite:

$ bun drizzle-kit push:sqlite
No config path provided, using default path
Reading config file '/Users/knarf/projects/git-repo-backup/drizzle.config.ts'
 Invalid input  Either "turso", "libsql", "better-sqlite" are available options for "--driver"
error: "drizzle-kit" exited with code 1 (SIGHUP)

Expected behavior

For this to work when running with bun drizzle-kit

Environment & setup

No response

[dinfer]

I'm using bun + drizzle-kit. it's very quick to use push:sqlite to change tables in dev environment. Is there any progress here?

[rifaldhiaw]

using driver: "better-sqlite", seems working just fine with bun sqlite

[MickL]

@rifaldhiaw How did you configure it exactly? It tells me "url" is a required option for driver "better-sqlite" but bun:sqlite doesnt have a url

[MickL]

I also dont know how to use bun:sqlite with Drizzle Kit / Drizzle Studio.

This issue is 1,5 years old. I wonder if Drizzle is still in development or where the focus lies? @dankochetov

Another related issue (maybe a duplicate) with 10 upvotes: #1795
Also related: drizzle-team/drizzle-bun#5

P.S. The same goes for Vercel and Neon -> Why cant I use this drivers within drizzle.config ? Issue: #1612

[keisanng]

@dankochetov Will drizzle team fully implement support for Bun SQLite in Drizzle Kit?

[MickL]

@AndriiSherman @dankochetov

[doroved]

I confirm that drizzle studio does not work with bun:sqlite

Please install either 'better-sqlite3' or '@libsql/client' for Drizzle Kit to connect to SQLite databases
error: script "db:studio" exited with code 1

[StevenStavrakis]

still an issue haha

[MickL]

There seems to be some development within Drizzle but I dont feel they look at any Github issues at all. For example I had an open issue which they fixed "by accident" but they didnt close my issue or reacted in any way.

[IslamZaoui]

I found the solution in bunjs docs here

just add this:

// database/index.ts
import { drizzle } from 'drizzle-orm/bun-sqlite';
import { Database } from 'bun:sqlite';
import { migrate } from 'drizzle-orm/bun-sqlite/migrator';

const sqlite = new Database('sqlite.db');
const db = drizzle(sqlite);
migrate(db, { migrationsFolder: './drizzle' });

export { db };

// drizzle.config.ts
import { defineConfig } from 'drizzle-kit';

export default defineConfig({
	dialect: 'sqlite',
	schema: './src/lib/server/database/schema.ts',
	out: './drizzle',
	dbCredentials: {
		url: 'file:./sqlite.db'
	}
});

run bunx drizzle-kit generate to generate migrations in ./drizzle and everything should be fine

edit: you need to restart your dev server to load the migration 😑

[fo-rk]

bunx drizzle-kit studio seems to be working for me on latest drizzle-kit and bun with following config.

{
    "dialect": "sqlite",
    "schema": "./data/schema.js",
    "out": "./drizzle",
    "dbCredentials": {
        "url": "file:./data/db.sqlite"
    },
    "verbose": "true"
}