The Wayback Machine - https://web.archive.org/web/20210124105420/https://github.com/sql-js/sql.js/issues/392
Skip to content

/ sql.js

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 our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

How to turn on "FTS3", "spatialite" extension? #392

Open
hoogw opened this issue May 5, 2020 · 1 comment
Open

How to turn on "FTS3", "spatialite" extension? #392

hoogw opened this issue May 5, 2020 · 1 comment
Labels
question

Comments

@hoogw
Copy link

@hoogw hoogw commented May 5, 2020 •
edited

I read all those below, but it is still for me impossible to do it.
Too hard for many people like me.

Can you provide a guide or document details how to include FTS3 and spatialite extension?

a step by step guide will make us easier.

Or simple just provide a final build result and published it here for download, that will be great!

Look for "load extension", "FTS3", "spatialite" in the existing issues:

#68
#89
#316 (comment)
#342 (comment)

Originally posted by @frafra in #390 (comment)
@hoogw hoogw changed the title Look for "load extension", "FTS3", "spatialite" in the existing issues: How to turn on "FTS3", "spatialite" extension? May 5, 2020
@lovasoa lovasoa added the question label May 5, 2020
@seidtgeist
Copy link
Contributor

@seidtgeist seidtgeist commented May 25, 2020

@hoogw I’ve managed to recompile by changing the Makefile as such:

CFLAGS = \
        -O2 \
        -DSQLITE_OMIT_LOAD_EXTENSION \
        -DSQLITE_DISABLE_LFS \
-       -DSQLITE_ENABLE_FTS3 \
-       -DSQLITE_ENABLE_FTS3_PARENTHESIS \
+       -DSQLITE_ENABLE_FTS5 \
+       -DSQLITE_ENABLE_JSON1 \
+       -DSQLITE_ENABLE_DBSTAT_VTAB \
        -DSQLITE_THREADSAFE=0

FTS5, JSON1 and DBSTAT are working great!
@lovasoa lovasoa mentioned this issue Oct 4, 2020
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
question
Projects
None yet
Milestone
No milestone
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
3 participants
@seidtgeist @hoogw @lovasoa