Awesome
SQLite / Sqlean builds
This repo provides customized builds for sqlite
and sqlean
shells.
SQLite
Builds and publishes SQLite shell (aka command-line interface or CLI) for different OS:
- Ubuntu 20.04+ shell (and other Debian-based distributions). 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.SQLITE_USE_URI
. Enables URI connection strings.
Latest release: 3.46.0
Sqlean
sqlean
shell is SQLite shell bundled with a collection of essential extensions ranging from regular expressions and math statistics to file I/O and dynamic SQL.
sqlean shell =
┌───────────────────────────┐
│ sqlite shell │
├ + ────────────────────────┤
│ crypto ipaddr text │
│ define math unicode │
│ fileio regexp uuid │
│ fuzzy stats vsv │
└───────────────────────────┘
Builds are available for every OS:
sqlean.exe
- for Windowssqlean-ubuntu
- for Ubuntu (and other Debian-based distributions)sqlean-macos
- for macOS (supports both Intel and Apple processors)
Latest release: 3.46.0 (using Sqlean 0.24.0).
Note for macOS users. macOS disables unsigned binaries and prevents the sqlean
shell from running. To resolve this issue, remove the build from quarantine by running the following command in Terminal (replace /path/to/folder
with an actual path to the folder containing the sqlean-macos
binary):
chmod +x /path/to/folder/sqlean-macos
xattr -d com.apple.quarantine /path/to/folder/sqlean-macos
And then run the shell:
$ /path/to/folder/sqlean-macos
SQLite version 3.42.0 2023-05-16 12:36:15
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlean> █