@antonz/sqlite
v3.40.0
Published
SQLite WebAssembly Build
Downloads
221
Readme
SQLite shell builder
Builds and publishes SQLite shell for different OS:
- Ubuntu 20.04 shell. Because for some reason "Linux Shell" from SQLite website does not work on Ubuntu.
- Windows shell (64-bit). Because SQLite website only provides 32-bit shell.
- macOS shell (supports both Intel and Apple processors). Just for convenience.
The list of enabled features:
SQLITE_ENABLE_DBPAGE_VTAB
. Enables the sqlite_dbpage virtual table.SQLITE_ENABLE_DBSTAT_VTAB
. Enables the dbstat virtual table.SQLITE_ENABLE_EXPLAIN_COMMENTS
. Makes EXPLAIN output more readable.SQLITE_ENABLE_FTS4
. Enables FTS3 and FTS4 extensions.SQLITE_ENABLE_FTS5
. Enables the FTS5 extension.SQLITE_ENABLE_GEOPOLY
. Enables the Geopoly extension.SQLITE_ENABLE_JSON1
. Enables the JSON1 extension.SQLITE_ENABLE_MATH_FUNCTIONS
. Enables math functions.SQLITE_ENABLE_OFFSET_SQL_FUNC
. Enables the sqlite_offset(x) function.SQLITE_ENABLE_RTREE
. Enables the R*Tree extension.SQLITE_ENABLE_STAT4
. Helps query planner to make better index choices.SQLITE_ENABLE_STMTVTAB
. Enables the sqlite_stmt virtual table.SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION
. Ignores unknown functions in EXPLAIN, useful for debugging.SQLITE_HAVE_ZLIB
. Required for SQL Archive support. Not available on Windows.SQLITE_LIKE_DOESNT_MATCH_BLOBS
. Forces LIKE and GLOB to return FALSE for BLOBs.SQLITE_THREADSAFE=0
. Turns off support for multithreaded environment.USE_URI
. Enables URI connection strings.
Latest release: 3.40.0