sqlite

Also known as: sqlite3

Command-line interface for SQLite

https://sqlite.org/

/api/formula/sqlite.json (JSON API)

Formula code on GitHub

Current versions:

stable 3.26.0
bottle 🍾 mojave, high_sierra, sierra

Options:

--with-fts Enable the FTS3 module
--with-fts5 Enable the FTS5 module (experimental)
--with-functions Enable more math and string functions for SQL queries
--with-json1 Enable the JSON1 extension

Depends on:

readline 7.0.5 Library for command-line editing

Analytics:

Installs (30 days)
sqlite 478,632
sqlite --with-functions 396
sqlite --with-json1 84
sqlite --with-fts --with-functions --with-json1 71
sqlite --with-fts --with-fts5 --with-functions --with-json1 52
sqlite --with-functions --with-json1 41
sqlite --with-fts5 --with-functions --with-json1 26
sqlite --with-fts --with-functions 25
sqlite --with-fts5 --with-json1 22
sqlite --with-fts5 16
sqlite --with-fts 12
sqlite --with-fts --with-json1 9
sqlite --with-fts --with-fts5 6
sqlite --universal 4
sqlite --with-fts --with-fts5 --with-json1 4
sqlite --with-unlock-notify 4
sqlite --with-fts --with-fts5 --with-functions 1
sqlite --with-fts5 --with-functions 1
Installs on Request (30 days)
sqlite 27,951
sqlite --with-functions 80
sqlite --with-json1 73
sqlite --with-fts --with-functions --with-json1 70
sqlite --with-fts --with-fts5 --with-functions --with-json1 48
sqlite --with-functions --with-json1 33
sqlite --with-fts5 --with-functions --with-json1 23
sqlite --with-fts5 --with-json1 20
sqlite --with-fts5 16
sqlite --with-fts 12
sqlite --with-fts --with-functions 11
sqlite --with-fts --with-json1 9
sqlite --with-fts --with-fts5 5
sqlite --with-unlock-notify 4
sqlite --universal 2
sqlite --with-fts --with-fts5 --with-json1 2
sqlite --with-fts --with-fts5 --with-functions 1
sqlite --with-fts5 --with-functions 1
Build Errors (30 days)
sqlite 23
sqlite --with-json1 1
Installs (90 days)
sqlite 1,434,032
sqlite --with-functions 1,377
sqlite --with-fts --with-functions --with-json1 259
sqlite --with-json1 258
sqlite --with-fts --with-fts5 --with-functions --with-json1 171
sqlite --with-functions --with-json1 141
sqlite --with-fts --with-functions 108
sqlite --with-fts5 --with-functions --with-json1 87
sqlite --with-fts5 --with-json1 66
sqlite --with-fts5 50
sqlite --with-fts 49
sqlite --with-fts --with-fts5 26
sqlite --with-fts --with-json1 18
sqlite --universal 13
sqlite --with-fts --with-fts5 --with-json1 10
sqlite --with-fts5 --with-functions 10
sqlite --with-fts --with-fts5 --with-functions 5
sqlite --with-unlock-notify 4
Installs on Request (90 days)
sqlite 86,366
sqlite --with-functions 323
sqlite --with-fts --with-functions --with-json1 254
sqlite --with-json1 226
sqlite --with-fts --with-fts5 --with-functions --with-json1 159
sqlite --with-functions --with-json1 109
sqlite --with-fts5 --with-functions --with-json1 76
sqlite --with-fts --with-functions 54
sqlite --with-fts5 --with-json1 52
sqlite --with-fts5 43
sqlite --with-fts 34
sqlite --with-fts --with-fts5 22
sqlite --with-fts --with-json1 17
sqlite --with-fts5 --with-functions 10
sqlite --with-fts --with-fts5 --with-json1 7
sqlite --with-fts --with-fts5 --with-functions 5
sqlite --universal 4
sqlite --with-unlock-notify 4
Installs (365 days)
sqlite 4,107,633
sqlite --with-functions 3,888
sqlite --with-json1 701
sqlite --with-fts --with-functions --with-json1 266
sqlite --with-functions --with-json1 200
sqlite --with-fts5 198
sqlite --with-fts --with-fts5 --with-functions --with-json1 184
sqlite --with-fts --with-functions 184
sqlite --with-fts5 --with-json1 178
sqlite --with-fts5 --with-functions --with-json1 126
sqlite --with-fts 99
sqlite --with-icu4c 97
sqlite --universal 52
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 48
sqlite --with-fts --with-fts5 46
sqlite --with-unlock-notify 42
sqlite --with-docs --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 41
sqlite --with-icu4c --with-functions --with-json1 39
sqlite --with-functions --without-readline 37
sqlite --with-fts --with-json1 34
sqlite --with-functions --with-json1 --without-readline 29
sqlite --with-fts5 --with-functions 26
sqlite --with-icu4c --with-functions 26
sqlite --with-docs 24
sqlite --with-functions --with-dbstat --with-json1 24
sqlite --with-fts --with-icu4c --with-functions 21
sqlite --with-docs --with-fts --with-functions 20
sqlite --with-fts --with-icu4c 19
sqlite --with-docs --with-functions --with-json1 18
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 17
sqlite --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 17
sqlite --with-fts --with-fts5 --with-json1 16
sqlite --with-fts --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 16
sqlite --with-icu4c --with-json1 15
Installs on Request (365 days)
sqlite 186,639
sqlite --with-functions 707
sqlite --with-json1 587
sqlite --with-fts --with-functions --with-json1 256
sqlite --with-fts --with-fts5 --with-functions --with-json1 170
sqlite --with-fts5 167
sqlite --with-functions --with-json1 141
sqlite --with-fts5 --with-json1 127
sqlite --with-fts5 --with-functions --with-json1 104
sqlite --with-icu4c 85
sqlite --with-fts --with-functions 77
sqlite --with-fts 54
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 48
sqlite --with-docs --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 41
sqlite --with-unlock-notify 38
sqlite --with-icu4c --with-functions --with-json1 35
sqlite --with-fts --with-fts5 31
sqlite --with-fts --with-json1 27
sqlite --with-functions --with-json1 --without-readline 23
sqlite --with-fts5 --with-functions 20
sqlite --with-functions --with-dbstat --with-json1 20
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 17
sqlite --with-fts --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 15
sqlite --with-icu4c --with-functions 15
sqlite --with-icu4c --with-json1 15
sqlite --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 14
Fork me on GitHub