- Notifications
You must be signed in to change notification settings - Fork1.1k
Enables FTS5 by default#594
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.
Already on GitHub?Sign in to your account
base:master
Are you sure you want to change the base?
Uh oh!
There was an error while loading.Please reload this page.
Conversation
P-de-Jong commentedOct 31, 2024
This would be great. It would mean we wouldn't need a custom build anymore. |
lovasoa commentedNov 3, 2024
Hi ! Asset sizes are often a limiting factor when integrating large libraries like sql.js. I agree we should include a FTS5 build in our build process, include it in tests, and distribute pre-compiled wasm files for easy access. But it should not be part of the default build. Ideally, we could make it so that switching to fts5 would be as easy as constSQL=awaitinitSqlJs({locateFile:file=>`/dist/fts5.${file}`}); |
lovasoa left a comment• edited
Loading Uh oh!
There was an error while loading.Please reload this page.
edited
Uh oh!
There was an error while loading.Please reload this page.
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others.Learn more.
I'd rather not increase the default asset size for all existing users, none of whom use fts5.
lsb commentedAug 13, 2025
fts5 seems to be supported in the official buildhttps://www.npmjs.com/package/sqlite-wasm-http |
Uh oh!
There was an error while loading.Please reload this page.
This PR enables theFTS5 extension by default.
Why I think it should be supported by default:
The feature is very useful to a wide range of client-based applications, one core use case for sql.js.
The size increase seems reasonable considering the new capabilities, being only 744K for the wasm file (638K before this PR).
Using a custom sql.js build should be last resort, as it means it'll be harder for users to upgrade.
Closes#199, which included additional unrelated changes and didn't have tests.