sqlite
Also known as: sqlite3
Command-line interface for SQLite
/api/formula/sqlite.json (JSON API)
Formula code on GitHub
Current versions:
| stable | ✅ | 3.25.2 |
| 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 |
550,432 |
sqlite --with-functions |
638 |
sqlite --with-json1 |
126 |
sqlite --with-fts --with-functions --with-json1 |
107 |
sqlite --with-fts --with-fts5 --with-functions --with-json1 |
81 |
sqlite --with-fts --with-functions |
63 |
sqlite --with-functions --with-json1 |
59 |
sqlite --with-fts5 --with-functions --with-json1 |
40 |
sqlite --with-fts5 --with-json1 |
28 |
sqlite --with-fts |
25 |
sqlite --with-fts5 |
22 |
sqlite --with-fts --with-fts5 |
12 |
sqlite --universal |
7 |
sqlite --with-fts --with-json1 |
7 |
sqlite --with-fts5 --with-functions |
7 |
sqlite --with-fts --with-fts5 --with-json1 |
4 |
sqlite --with-fts --with-fts5 --with-functions |
3 |
| Installs on Request (30 days) | |
sqlite |
36,454 |
sqlite --with-functions |
150 |
sqlite --with-json1 |
112 |
sqlite --with-fts --with-functions --with-json1 |
104 |
sqlite --with-fts --with-fts5 --with-functions --with-json1 |
75 |
sqlite --with-functions --with-json1 |
44 |
sqlite --with-fts5 --with-functions --with-json1 |
35 |
sqlite --with-fts --with-functions |
28 |
sqlite --with-fts5 --with-json1 |
22 |
sqlite --with-fts5 |
18 |
sqlite --with-fts |
17 |
sqlite --with-fts --with-fts5 |
10 |
sqlite --with-fts5 --with-functions |
7 |
sqlite --with-fts --with-json1 |
6 |
sqlite --with-fts --with-fts5 --with-functions |
3 |
sqlite --with-fts --with-fts5 --with-json1 |
3 |
sqlite --universal |
2 |
| Build Errors (30 days) | |
sqlite |
11 |
| 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 |
