future of better-sqlite3 vs node:sqlite

[forgotPassword]

Node 22.5 exposed sqlite module https://nodejs.org/api/sqlite.html, which also uses sync api. Will this affect the future of the lib?

Would be interesting to test it in the benchmarks.

[mceachen]

I think it’s great to have more options! @JoshuaWise and I commented in the main PR that this feature dropped into, and they decided to adopt much of this library’s API signature.

That said, a specific version of SQLite will be baked into a given version of node, and there are substantive differences between versions that could result in frustration of you couldn’t pull in the SQLite version that has a newer bug fix.

[Prinzhorn]

I had no idea this was added to Node.js! Right now this looks like a basic PoC that supports the bare minimum. And it looks like that's exactly the point. As a heavy user of user-defined functions and virtual tables I doubt the integrated SQLite will ever replace better-sqlite3. So my take is that for advanced use-cases better-sqlite3 is needed, but for basic CRUD tasks the integrated SQLite is perfectly fine.