sqlite
Also known as: sqlite3
Command-line interface for SQLite
/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 | ✅ | 61.1 | C/C++ and Java libraries for Unicode and globalization |
Analytics:
| Installs (30 days) | |
|---|---|
sqlite |
369,620 |
sqlite --with-functions |
396 |
sqlite --with-json1 |
57 |
sqlite --with-fts5 |
29 |
sqlite --with-fts5 --with-json1 |
13 |
sqlite --with-functions --with-json1 |
11 |
sqlite --with-fts --with-functions |
10 |
sqlite --with-functions --with-json1 --without-readline |
9 |
sqlite --with-icu4c |
9 |
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex |
8 |
sqlite --with-fts |
8 |
sqlite --with-fts5 --with-functions --with-json1 |
7 |
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 --with-fts --with-fts5 --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex |
6 |
sqlite --universal |
5 |
sqlite --with-docs |
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-functions |
4 |
sqlite --with-docs --with-functions |
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-dbstat |
3 |
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-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 |
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-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-icu4c --with-functions |
3 |
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 --with-soundex |
2 |
sqlite --with-docs --with-fts --with-icu4c --with-functions --with-json1 |
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-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-fts --with-fts5 --with-functions --with-json1 |
2 |
sqlite --with-fts --with-fts5 --with-icu4c |
2 |
sqlite --with-fts --with-icu4c |
2 |
sqlite --with-fts --with-icu4c --with-functions |
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-functions --with-soundex |
2 |
sqlite --with-icu4c --with-json1 |
2 |
sqlite --with-unlock-notify |
2 |
| Installs on Request (30 days) | |
sqlite |
16,087 |
sqlite --with-functions |
64 |
sqlite --with-json1 |
47 |
sqlite --with-fts5 |
23 |
sqlite --with-fts5 --with-json1 |
10 |
sqlite --with-icu4c |
9 |
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex |
8 |
sqlite --with-docs --with-fts --with-secure-delete --with-unlock-notify --with-icu4c --with-functions --with-dbstat --with-json1 --with-session |
6 |
sqlite --with-fts --with-fts5 --with-icu4c --with-functions --with-dbstat --with-json1 --with-session --with-soundex |
6 |
sqlite --with-fts5 --with-functions --with-json1 |
6 |
sqlite --with-functions --with-json1 --without-readline |
6 |
sqlite --with-icu4c --with-functions --with-json1 |
6 |
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-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 --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-json1 |
3 |
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-icu4c --with-functions --with-json1 |
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 --with-functions --with-json1 |
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 --with-functions --with-dbstat --with-json1 |
2 |
sqlite --with-functions --with-soundex |
2 |
sqlite --with-icu4c --with-json1 |
2 |
| Build Errors (30 days) | |
sqlite |
39 |
| 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 |
