An equivalent of better-sql3 for bun ?

[jaenyf]

🌠 🌠 🌠
Yes, there is bun:sqlite ! But unfortunately, its api doesn't seem working with kysely.
Test it, and you will see that you can't execute queries from the ZenstackClient (they returns empty results), though the raw query from the same shared bun:sqlite instance do return some results.
So, when you are running with bun, it seems you just can't use sqlite for your integration tests.

Unfortunately, the docs on the zenstack website are not correct when they state you can use better-sql3 with bun. That's incorrect. Even if you can add it to bun, it won't load on import and will fail with an error message suggesting you to use bun:sqlite (and linking to oven-sh/bun#4290 )

I wonder what setup can work for fast (ideally in-memory) integration tests involving zenstack client.
I've not yet looked on how the zenstack team is testing, and it could probably be a good way to go.
If you use bun, what are you using ? Containerized db ? Complete test db instance ? Other ?
🌠 🌠 🌠

[sanny-io]

What page of the ZenStack docs are you reading? It says better-sqlite3 does NOT work with Bun, and you must use bun:sqlite with kysely-bun-sqlite

Have you tried this?

https://zenstack.dev/docs/recipe/databases/sqlite#bun

[jaenyf]

Yep, I ended up with the same conclusion !

The docs I read was taken from here : https://zenstack.dev/docs/orm/client

The zenstack team probably forget to update it.

I didn't see https://zenstack.dev/docs/recipe/databases/sqlite#bun but it looks very promising ! I'm testing it straight away ! Thanks !

[sanny-io]

The information on the page you linked seems accurate. Bun as a package manager can be used separately from Bun as a runtime.
They are not the same thing.

Hopefully your test goes well though 🙏

[jaenyf]

Thanks (a lot) it work !

FYI, you can't use better-sqlite3 with bun. When you do use SQLite you end up with this exception (as i explained in my 1st post) :

The linked issue ( oven-sh/bun#4290 ) is open since august 2023, and there is still no support for better-sqlite3, and probably will never be.

So the zenstack doc at https://zenstack.dev/docs/orm/client should indicate to use kysely-bun-sqlite instead of better-sqlite3, as you pointed it out.

[ymc9]

If you want to use bun's native sqlite, this kysely dialect package may be worth a try: https://github.com/dylanblokhuis/kysely-bun-sqlite

[ymc9]

Btw, I'll close the discussions feature on this repo soon, so that we can consolidate channels to github issues + discord. Too many channels to watch 🤣