No matching export in "node_modules/@astrojs/db/dist/runtime/index.js" for import "sql"

[hkbertoson]

node_modules/lucia-adapter-astrodb/dist/index.js:1:9:
   1 │ import { sql } from "@astrojs/db/runtime";

Seems like this is not exported from @astrjojs/db/runtime

[xrexy]

Seems like this commit removes exports for both sql and SqliteDB which are imports from drizzle-orm, so a possible fix could be importing from drizzle-orm not @astrojs/db/runtime.

Not sure if it should be fixed in @astrojs/db(or why they even changed it) or if pilcrowOnPaper is fine with the "fix" I mentioned above

[xrexy]

Nvm, I'm dumb this PR moves them to /runtime/config.ts

Edit: they have this in their package.json "./dist/runtime/config.js": { "import": "./dist/runtime/config.js" } so not sure if you can even import the config lol

[hkbertoson]

Yeah im not sure on this. Quite odd

[pilcrowonpaper]

I'm not really sure what API to use since eq() etc exported by Drizzle and Astro DB have different types. Drizzle isn't 1.0 yet, so I'd prefer to stick to whatever version Astro DB is using too.

[hkbertoson]

Sounds like something to talk to the Astro team about.

[theDeal]

What is a solution you guys are using rn?

[xrexy]

I just went back to @astrojs/db 0.8.6, but wouldn't say that's a solution

[josu-dev]

I just went back to @astrojs/db 0.8.6, but wouldn't say that's a solution

I dont know if its a possible solution but i locally changed my dist file of the adapter to import {sql} form 'astro:db' direclty but it breaks with the bundler i think

[boycott]

Whats worked for me is to copy the adapter into my lib directory and call it from there, and adapt it as follows:

import { sql } from 'astro:db';

import type { db as SqliteDB } from 'astro:db';
import type { Table } from "@astrojs/db/runtime";

and then use typeof in the private variable and constructor:

private db: typeof SqliteDB;
...
constructor(db: typeof SqliteDB, sessionTable: SessionTable, userTable: UserTable) {
...
}

[pilcrowonpaper]

Fixed with 0.0.5 - see the README for configuring your project