drizzle x bun-sql

drizzleBun.ts

import { text, integer } from "drizzle-orm/sqlite-core";
import { sqliteTable } from "drizzle-orm/sqlite-core";
import { drizzle } from "drizzle-orm/bun-sqlite";
import { Database } from "bun:sqlite";


export const user = sqliteTable('user', {
    id: integer('userId').primaryKey(),
    username: text('username').notNull(),
})

const databaseTables = [`user (id INTEGER PRIMARY KEY, name TEXT)`]; // Drizzle doesn't support creating tables :(

const sqlite = new Database("drizzle/db.sqlite");
for (const tableCreationStatement of databaseTables) {
  await sqlite.exec(`CREATE TABLE IF NOT EXISTS ${tableCreationStatement}`);
}
const db = drizzle(sqlite);

This just give you the basic template in typescript.