Drizzle support for Lucia v3?

[deadcoder0904]

I get a type error when I try to use Drizzle so I'm assuming its not supported yet?

db/index.ts

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

const client = sqlite(process.env.SQLITE_URL)

export const db = drizzle(client)

auth/lucia.ts

import { BetterSqlite3Adapter } from '@lucia-auth/adapter-sqlite'
import { Lucia } from "lucia";

import { db } from '@/app/db/index'
import { tableNames } from '@/app/db/schema'

const adapter = new BetterSqlite3Adapter(db, tableNames)

I get an error on db on the adapter above:

Argument of type 'BetterSQLite3Database<Record<string, never>>' is not assignable to parameter of type 'Database'.
Type 'BaseSQLiteDatabase<"sync", RunResult, Record<string, never>, ExtractTablesWithRelations<Record<string, never>>>' is missing the following properties from type 'Database': memory, readonly, name, open, and 13 more.ts(2345)

I was trying to update my project on sqlite branch to Lucia v3.

Lmk if I'm doing something wrong?

[pilcrowonpaper]

There's already a Drizzle adapter

https://v3.lucia-auth.com/database/drizzle

You have to pass client instead of db in your code

[deadcoder0904]

thanks, i feel like 6 months ago i faced this same error & you had the same solution haha.

edit: alright the solution was a bit different. had to use @beta of drizzle adapter. i do think a search function is needed for simple searches like drizzle.

[deadcoder0904]

@pilcrowonpaper bdw sqlite docs on drizzle have inconsistent naming. session table is called user_session only on one place -> https://v3.lucia-auth.com/database/drizzle

[pilcrowonpaper]

Fixed :D

[deadcoder0904]

also, await lucia.deleteExpiredSessions(); isn't used in docs or examples. i am supposed to put it in logout, right? or login?

[pilcrowonpaper]

Using a cron job is the best, but if you can't, logout might be fine