sqlite
Also known as: sqlite3
Command-line interface for SQLite
/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 |
