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.24.0
bottle 🍾 high_sierra, sierra, el_capitan

Keg-only

Options:

--with-docs Install HTML documentation
--without-rtree Disable the R*Tree index module
--with-fts Enable the FTS3 module
--with-fts5 Enable the FTS5 module (experimental)
--with-secure-delete Defaults secure_delete to on
--with-unlock-notify Enable the unlock notification feature
--with-icu4c Enable the ICU module
--with-functions Enable more math and string functions for SQL queries
--with-dbstat Enable the 'dbstat' virtual table
--with-json1 Enable the JSON1 extension
--with-session Enable the session extension
--with-soundex Enable the SOUNDEX function
--without-readline Build without readline support

Depends on recommended:

readline 7.0.3 Library for command-line editing

Depends on optionally:

icu4c 62.1 C/C++ and Java libraries for Unicode and globalization

Analytics:

Installs (30 days)
sqlite 388,709
sqlite --with-functions 415
sqlite --with-json1 63
sqlite --with-fts5 29
sqlite --with-fts5 --with-json1 13
sqlite --with-fts --with-functions 11
sqlite --with-functions --with-json1 11
sqlite --with-icu4c 10
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 9
sqlite --with-fts 8
sqlite --with-fts5 --with-functions --with-json1 8
sqlite --with-functions --without-readline 7
sqlite --with-icu4c --with-functions --with-json1 7
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 6
sqlite --universal 5
sqlite --with-docs 5
sqlite --with-docs --with-fts --with-functions 5
sqlite --with-functions --with-json1 --without-readline 5
sqlite --with-icu4c --with-json1 5
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 4
sqlite --with-docs --with-fts --with-icu4c --with-functions --with-json1 4
sqlite --with-docs --with-functions 4
sqlite --with-fts --with-fts5 4
sqlite --with-fts --with-fts5 --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 4
sqlite --with-fts --with-secure-delete --with-icu4c --with-functions --with-dbstat --with-json1 4
sqlite --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 4
sqlite --with-functions --with-dbstat --with-json1 4
sqlite --with-docs --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 3
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat 3
sqlite --with-docs --with-fts5 --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 3
sqlite --with-docs --with-functions --with-json1 3
sqlite --with-docs --without-rtree --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --without-readline 3
sqlite --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 3
sqlite --with-fts --with-icu4c --with-functions 3
sqlite --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 3
sqlite --with-icu4c --with-functions 3
sqlite --with-dbstat 2
sqlite --with-docs --with-fts --with-fts5 --with-icu4c --with-functions --with-dbstat --with-json1 2
sqlite --with-docs --with-fts --with-fts5 --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 2
sqlite --with-docs --with-fts --with-fts5 --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 2
sqlite --with-docs --with-fts --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-session 2
sqlite --with-docs --with-fts5 --with-functions --with-json1 --with-session 2
sqlite --with-docs --with-fts5 --with-secure-delete --with-icu4c --with-functions --with-dbstat --with-json1 --with-soundex 2
sqlite --with-docs --with-functions --with-json1 --with-session 2
sqlite --with-docs --with-icu4c --with-functions --with-json1 2
sqlite --with-fts --with-fts5 --with-functions --with-json1 2
sqlite --with-fts --with-fts5 --with-functions --with-json1 --with-session 2
sqlite --with-fts --with-fts5 --with-icu4c 2
sqlite --with-fts --with-icu4c 2
sqlite --with-fts --with-icu4c --with-functions --with-dbstat --with-json1 2
sqlite --with-fts5 --with-functions 2
sqlite --with-fts5 --with-icu4c --with-functions 2
sqlite --with-fts5 --with-icu4c --with-functions --with-json1 2
sqlite --with-unlock-notify 2
sqlite --without-readline 2
Installs on Request (30 days)
sqlite 17,331
sqlite --with-functions 74
sqlite --with-json1 50
sqlite --with-fts5 23
sqlite --with-fts5 --with-json1 11
sqlite --with-icu4c 10
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 9
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 6
sqlite --with-fts5 --with-functions --with-json1 6
sqlite --with-icu4c --with-functions --with-json1 6
sqlite --with-icu4c --with-json1 5
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 4
sqlite --with-docs --with-fts --with-icu4c --with-functions --with-json1 4
sqlite --with-fts --with-fts5 --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 4
sqlite --with-docs --with-fts5 --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 3
sqlite --with-docs --without-rtree --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --without-readline 3
sqlite --with-fts --with-functions 3
sqlite --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 3
sqlite --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 3
sqlite --with-functions --with-dbstat --with-json1 3
sqlite --with-functions --with-json1 3
sqlite --with-functions --with-json1 --without-readline 3
sqlite --with-dbstat 2
sqlite --with-docs --with-fts --with-fts5 --with-icu4c --with-functions --with-dbstat --with-json1 2
sqlite --with-docs --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 2
sqlite --with-docs --with-fts --with-fts5 --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 2
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat 2
sqlite --with-docs --with-fts --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-session 2
sqlite --with-docs --with-fts5 --with-secure-delete --with-icu4c --with-functions --with-dbstat --with-json1 --with-soundex 2
sqlite --with-docs --with-functions --with-json1 2
sqlite --with-fts --with-fts5 2
sqlite --with-fts --with-fts5 --with-functions --with-json1 2
sqlite --with-fts --with-fts5 --with-functions --with-json1 --with-session 2
sqlite --with-fts --with-fts5 --with-icu4c 2
sqlite --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 2
sqlite --with-fts --with-secure-delete --with-icu4c --with-functions --with-dbstat --with-json1 2
sqlite --with-fts5 --with-icu4c --with-functions 2
sqlite --with-fts5 --with-icu4c --with-functions --with-json1 2
sqlite --without-readline 2
Build Errors (30 days)
sqlite 38
Installs (90 days)
sqlite 1,015,274
sqlite --with-functions 1,066
sqlite --with-json1 162
sqlite --with-fts5 63
sqlite --with-fts5 --with-json1 53
sqlite --with-icu4c 50
sqlite --with-fts --with-functions 36
sqlite --with-unlock-notify 26
sqlite --with-functions --with-json1 24
sqlite --with-fts 21
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 19
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 18
sqlite --with-functions --without-readline 18
sqlite --with-icu4c --with-functions --with-json1 18
sqlite --with-fts5 --with-functions --with-json1 15
sqlite --with-docs 12
sqlite --with-icu4c --with-functions 12
sqlite --with-functions --with-json1 --without-readline 11
sqlite --universal 10
sqlite --with-fts --with-fts5 10
sqlite --with-docs --with-fts --with-functions 9
sqlite --with-docs --with-functions --with-json1 9
sqlite --with-fts --with-icu4c 9
sqlite --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 9
sqlite --with-fts --with-json1 8
sqlite --with-icu4c --with-json1 8
sqlite --without-readline 8
sqlite --with-dbstat 7
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat 7
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 7
sqlite --with-fts5 --with-icu4c --with-functions --with-json1 7
sqlite --with-functions --with-dbstat --with-json1 7
sqlite --with-docs --with-fts --with-icu4c --with-functions --with-json1 6
sqlite --with-docs --with-fts --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 6
sqlite --with-docs --with-functions 6
sqlite --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 6
sqlite --with-fts --with-icu4c --with-functions 6
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions 5
sqlite --with-docs --with-functions --with-json1 --with-session 5
sqlite --with-fts --with-fts5 --with-functions --with-dbstat --with-json1 5
sqlite --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 5
sqlite --with-fts --with-icu4c --with-functions --with-dbstat --with-json1 5
sqlite --with-fts5 --with-icu4c --with-functions --with-json1 --with-session 5
sqlite --with-docs --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 4
sqlite --with-docs --with-fts --with-fts5 --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 4
sqlite --with-fts --with-fts5 --with-functions --with-json1 4
sqlite --with-fts --with-fts5 --with-functions --with-json1 --with-session 4
sqlite --with-fts --with-fts5 --with-icu4c 4
sqlite --with-fts --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 4
sqlite --with-fts --with-secure-delete --with-icu4c --with-functions --with-dbstat --with-json1 4
sqlite --with-fts5 --with-icu4c --with-functions 4
sqlite --with-fts5 --with-icu4c --with-functions --with-dbstat --with-json1 4
Installs on Request (90 days)
sqlite 40,855
sqlite --with-functions 148
sqlite --with-json1 124
sqlite --with-fts5 50
sqlite --with-icu4c 43
sqlite --with-fts5 --with-json1 37
sqlite --with-unlock-notify 25
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 19
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 18
sqlite --with-icu4c --with-functions --with-json1 17
sqlite --with-functions --with-json1 13
sqlite --with-fts5 --with-functions --with-json1 12
sqlite --with-fts --with-functions 10
sqlite --with-functions --with-json1 --without-readline 10
sqlite --with-icu4c --with-json1 8
sqlite --without-readline 8
sqlite --with-dbstat 7
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 7
sqlite --with-fts 7
sqlite --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 7
sqlite --with-docs --with-fts --with-icu4c --with-functions --with-json1 6
sqlite --with-docs --with-fts --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 6
sqlite --with-docs --with-functions --with-json1 5
sqlite --with-fts --with-fts5 5
sqlite --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 5
sqlite --with-fts --with-json1 5
sqlite --with-fts5 --with-icu4c --with-functions --with-json1 --with-session 5
sqlite --with-functions --with-dbstat --with-json1 5
sqlite --with-icu4c --with-functions 5
sqlite --with-docs 4
sqlite --with-docs --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 4
sqlite --with-docs --with-fts --with-fts5 --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 4
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat 4
sqlite --with-fts --with-fts5 --with-functions --with-json1 --with-session 4
sqlite --with-fts --with-fts5 --with-icu4c 4
sqlite --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 4
sqlite --with-fts --with-icu4c 4
sqlite --with-fts5 --with-icu4c --with-functions 4
sqlite --with-fts5 --with-icu4c --with-functions --with-dbstat --with-json1 4
sqlite --with-fts5 --with-icu4c --with-functions --with-json1 4
Installs (365 days)
sqlite 3,077,933
sqlite --with-functions 4,713
sqlite --with-json1 524
sqlite --with-fts5 169
sqlite --with-fts5 --with-json1 163
sqlite --with-fts --with-functions 141
sqlite --with-icu4c 131
sqlite --universal 95
sqlite --with-functions --with-json1 86
sqlite --with-fts 79
sqlite --with-docs --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 71
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 64
sqlite --with-fts5 --with-functions --with-json1 64
sqlite --with-docs 62
sqlite --with-functions --without-readline 59
sqlite --with-icu4c --with-functions --with-json1 58
sqlite --with-docs --with-fts --with-functions 52
sqlite --with-fts --with-icu4c --with-functions 46
sqlite --with-icu4c --with-functions 46
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 45
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 45
sqlite --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 44
sqlite --with-unlock-notify 44
sqlite --with-docs --with-fts --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 42
sqlite --with-functions --with-dbstat --with-json1 38
sqlite --with-fts --with-fts5 --with-functions --with-json1 36
sqlite --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 33
sqlite --with-fts --with-icu4c 33
sqlite --with-functions --with-json1 --without-readline 32
sqlite --with-docs --with-functions --with-json1 31
sqlite --with-fts --with-fts5 29
sqlite --with-icu4c --with-json1 27
sqlite --with-docs --with-functions 26
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat 25
sqlite --with-docs --with-fts --with-icu4c --with-functions --with-json1 23
sqlite --with-fts --with-json1 22
sqlite --with-fts --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 19
sqlite --with-docs --with-functions --with-dbstat --with-json1 18
sqlite --with-fts --with-fts5 --with-functions --with-dbstat --with-json1 18
sqlite --with-fts --with-icu4c --with-functions --with-dbstat --with-json1 18
sqlite --with-fts --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 18
sqlite --with-fts5 --with-icu4c --with-functions --with-json1 18
sqlite --with-docs --with-functions --with-json1 --with-session 17
sqlite --with-docs --with-fts --with-fts5 --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 16
Installs on Request (365 days)
sqlite 114,319
sqlite --with-functions 497
sqlite --with-json1 347
sqlite --with-fts5 123
sqlite --with-fts5 --with-json1 90
sqlite --with-icu4c 84
sqlite --with-docs --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 57
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 54
sqlite --with-icu4c --with-functions --with-json1 51
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 45
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex 45
sqlite --with-fts5 --with-functions --with-json1 40
sqlite --with-functions --with-json1 40
sqlite --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 34
sqlite --with-unlock-notify 33
sqlite --with-docs --with-fts --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 29
sqlite --with-fts --with-functions 27
sqlite --with-fts 25
sqlite --with-functions --with-dbstat --with-json1 25
sqlite --with-icu4c --with-json1 25
sqlite --with-fts --with-fts5 --with-functions --with-json1 23
sqlite --with-fts --with-fts5 --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 20
sqlite --with-fts --with-icu4c 20
sqlite --with-icu4c --with-functions 20
sqlite --with-fts --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 19
sqlite --with-functions --with-json1 --without-readline 19
sqlite --with-docs --with-functions --with-json1 16
sqlite --with-fts --with-icu4c --with-functions --with-dbstat --with-json1 --with-session 16
sqlite --with-docs --with-fts --with-icu4c --with-functions --with-json1 15
sqlite --with-fts --with-fts5 15
sqlite --without-readline 14
Fork me on GitHub