[Feature Request]: Deno SQLite adapter

[jdnavarro]

Description

Currently better-sqlite3 doesn't work in Deno. It shouldn't be too hard to write an adapter for the native Deno SQLite3 module.

I can send a PR if it's something you are willing to upstream.

[pilcrowonpaper]

I wonder if you can even install @lucia-auth/adapter-sqlite in Deno (resolving dependencies etc)?

[jdnavarro]

Quickly checking with the Deno REPL, it's possible to get an Auth instance with an undefined db:

> import { lucia } from "npm:lucia";
undefined
> import { betterSqlite3 } from "npm:@lucia-auth/adapter-sqlite";
undefined
> lucia({ adapter: betterSqlite3(undefined, {user: "user", key: "user_key", session: "user_session" }) });
Auth {
  adapter: {
    getUser: [AsyncFunction: getUser],
    setUser: [AsyncFunction: setUser],
...

I could try with a dummy sqlite adapter before trying to implement the actual Sqlite3 Deno adapter. Is there any other adapter I could check first?

I tried with a real libSQL db, but it doesn't support local SQLite files in non node environments.

[pilcrowonpaper]

Hm, I wonder what's the best way to handle this. Exporting a package that only works in Deno from @lucia-auth/adapter-sqlite etc seems wrong. I know Deno provides drivers for MySQL and PostgreSQL as well, and it might be better to do something like @lucia-auth/adapter-deno. That said, I'm not sure if there's enough interest to make it an official adapter.

[jdnavarro]

I'm not sure if there's enough interest to make it an official adapter.

Makes sense.

I was exploring the possibility of using Deno as a SvelteKit adapter in order to distribute a single executable. There is already experimental support in node.js for single executable applications, but in our particular case, it gets tricky because we have several FFI bindings.

Aside of the compatibility with lucia and better-sqlite3, there are other factors to consider, so we may abandon the idea.

If we end up going ahead, I can publish an experimental deno lucia adapter as a separate deno module in https://deno.land/x.