Skip to content

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

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

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

Comments

@hoogw
Copy link

hoogw commented May 5, 2020

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
@seidtgeist
Copy link
Contributor

@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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants