Investigate sqlite driver switch to better-sqlite3

[Rugvip]

Feature Suggestion

Let's investigate whether better-sqlite3 is a better option than @vscode/sqlite3, which has been causing a lot of issues lately due to not providing binaries (#9734, #9622, #9583). Thanks to @benjdlambert's earlier work this is an option 🎉

Possible Implementation

Try out better-sqlite3, if it works out of the box or with somewhat minimal changes, then we likely want to switch over. We also want to make sure that we don't take a big performance hit by comparing the performance of the catalog across the two drivers.

Since SQLite is only intended for development we don't need to take DB file compatibility into account, but let's do give a heads up that an export/import might be needed if someone is relying on SQLite file storage.

Context

We're leaving this issue open for contributions as it is well isolated and a good opportunity for the community to help the project grow. Let us know if you want to pick this up, thank you! 🙏

#9351