Skip to content
forked from nalgeon/sqlite

64-bit SQLite shell (CLI) builds

License

Notifications You must be signed in to change notification settings

kkirkfield/sqlite

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

47 Commits
 
 
 
 
 
 
 
 

Repository files navigation

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.42.0

About

64-bit SQLite shell (CLI) builds

Resources

License

Stars

Watchers

Forks

Packages

No packages published