3.40.0 • Published 1 year ago

@antonz/sqlite v3.40.0

Weekly downloads
-
License
MIT
Repository
github
Last release
1 year ago

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

3.40.0

1 year ago