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

[hoogw]

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:

https://github.com/sql-js/sql.js/issues/68 https://github.com/sql-js/sql.js/issues/89 https://github.com/sql-js/sql.js/issues/316#issuecomment-569073185 https://github.com/sql-js/sql.js/issues/342#issuecomment-587336036

Originally posted by @frafra in https://github.com/sql-js/sql.js/issues/390#issuecomment-623519922

[seidtgeist]

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