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

hoogw · 2020-05-05T16:03:58Z

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)

seidtgeist · 2020-05-25T23:41:11Z

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

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 added the question label May 5, 2020

lovasoa mentioned this issue Oct 4, 2020

Support for SpatialLite? #424

Closed

sql-js / sql.js

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

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

hoogw commented May 5, 2020 •

edited

seidtgeist commented May 25, 2020

sql-js / sql.js

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

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

Comments

hoogw commented May 5, 2020 • edited

seidtgeist commented May 25, 2020

hoogw commented May 5, 2020 •

edited