remote/sqlite-utils
1
0
Fork 0
mirror of https://github.com/simonw/sqlite-utils.git synced 2026-07-23 17:34:32 +02:00
Code Issues Projects Releases Packages Wiki Activity
606 commits 70 branches 137 tags 7.3 MiB
Commit graph

606 commits

This branch
This branch
All branches
Author SHA1 Message Date
Simon Willison
c265541384 Shorter help summary for rebuild_fts 2021-01-03 12:22:07 -08:00
Simon Willison
94b5023066 table.count now uses cached counts if db.use_counts_table 
Closes #215
 2021-01-03 12:19:34 -08:00
Simon Willison
036ec6d323 Ignore test .db files 2021-01-03 10:43:21 -08:00
Simon Willison
1e38a16ea8 Nicer error message for invalid JSON insert, closes #206 2021-01-03 10:42:17 -08:00
Simon Willison
6d1828e40b
 		Don't run CodeQL against pull requests 
It failed with strange errors. https://github.com/simonw/sqlite-utils/pull/203/checks?check_run_id=1549287178
 2021-01-02 20:30:10 -08:00
Simon Willison
ce042ff1f0 'sqlite-utils enable-counts' command, closes #214 2021-01-02 20:26:39 -08:00
Simon Willison
de08096989 database.triggers_dict, closes #216 2021-01-02 20:19:55 -08:00
Simon Willison
3d041d34d5 Renamed db.escape() to db.quote() and documented it 
Closes #217
 2021-01-02 20:15:04 -08:00
Simon Willison
ce918195a4 Use $ instead of % in CLI documentation 
Refs #218
 2021-01-02 19:52:15 -08:00
Simon Willison
5b246d17a0 'sqlite-utils triggers' command, closes #218 2021-01-02 19:03:15 -08:00
Simon Willison
9a5c92b63e db.enable_counts() method, closes #213 2021-01-02 14:03:52 -08:00
Simon Willison
1cad7fad3e table.enable_counts() method, closes #212 2021-01-02 13:40:10 -08:00
Simon Willison
b067f1ff57 table.triggers_dict property, closes #211 2021-01-01 18:10:04 -08:00
Simon Willison
0dca784dbe Release 3.1.1 3.1.1 
Refs #209. Also updated copyright footer in documentation.
 2021-01-01 15:56:20 -08:00
Simon Willison
33c759a74c Test now tolerates optimize producing larger DB, closes #209 2021-01-01 15:52:36 -08:00
Simon Willison
6a34426b12 Docs now live at sqlite-utils.datasette.io 2020-12-29 13:34:55 -08:00
Simon Willison
8ca35dfb64 Link to new datasette.io website 2020-12-29 13:33:25 -08:00
Simon Willison
f1277f638f
 		Added Homebrew installation instructions 2020-12-13 20:52:24 -08:00
Simon Willison
5e06026e76
 		Typo fix 2020-12-13 16:19:51 -08:00
Simon Willison
1ce96d8c08 Release 3.1 3.1 
Refs #204, #207, #208
 2020-12-12 23:30:59 -08:00
Simon Willison
69a121e088
 		sqlite-utils analyze-tables command and table.analyze_column() method 
Closes #207
 2020-12-12 23:20:11 -08:00
Andreas Madsack
c5f4f0f70c
 		Use jsonify_if_need for sql updates (#204) 
* add failing tests for update with json values
* use jsonify_if_needed in for sql updates

Thanks, @mfa
 2020-12-08 09:49:42 -08:00
Simon Willison
60d3c4821b Changes since the 3.0a0 alpha release 3.0 2020-11-08 09:23:38 -08:00
Simon Willison
68637732e0 Release 3.0 
Refs #192 #193 #196 #199 #198 #197 #200 #201

Closes #194
 2020-11-08 09:19:20 -08:00
Simon Willison
47abca0764 Update README for 3.0 release, refs #194 2020-11-08 09:16:25 -08:00
Simon Willison
ce2b07c358 Updated docs for .search_sql() method 
Also improved indentation of generated SQL queries. Refs #197
 2020-11-08 09:04:37 -08:00
Simon Willison
79109939c3 search --limit now defaults to everything, refs #192 2020-11-08 09:00:43 -08:00
Simon Willison
c5a798c15f .search_sql() fully respects columns=, closes #201 
Refs #192 and #197
 2020-11-08 08:53:53 -08:00
Simon Willison
a8acafbfe0 Fixed RST typo 2020-11-08 08:38:02 -08:00
Simon Willison
60f4aff9b0
 		Link changelog badge to /en/latest/changelog.html 
That way you can see the changelog for alpha releases. Refs #194.
 2020-11-06 18:23:56 -08:00
Simon Willison
6785e89cc0 Release 3.0a0 3.0a0 
Refs #192 #193 #194 #196 #199 #198 #197 #200
 2020-11-06 17:22:24 -08:00
Simon Willison
cbc9841646 Docs for .search() and .search_sql(), refs #197 2020-11-06 16:58:57 -08:00
Simon Willison
bce1872109 order= is now order_by=, refs #197 2020-11-06 16:43:33 -08:00
Simon Willison
2bc1e9c5b4 Added test for .search_sql() and FTS4, refs #197 2020-11-06 16:32:40 -08:00
Simon Willison
6863dc2677 sqlite-utils rows -c, closes #200 2020-11-06 16:28:41 -08:00
Simon Willison
309ae84336 '-f' must now always be specified as '--fmt', refs #194 2020-11-06 16:19:04 -08:00
Simon Willison
afee15f04b --tsv output option, closes #193 2020-11-06 16:09:42 -08:00
Simon Willison
771bd81b62 search_sql() returns most relevant first, not least 
Refs #192
 2020-11-06 15:50:02 -08:00
Simon Willison
63e2bdf18d Added test for sqlite-utils search, refs #192 2020-11-06 15:40:42 -08:00
Simon Willison
d411fba1f4 .search() works for FTS4, yields dicts 
Closes #198, refs #197
 2020-11-06 10:30:41 -08:00
Simon Willison
476825a224 How to use register_function as a method, not a decorator 2020-11-06 10:30:41 -08:00
Simon Willison
27b67f1cae @db.register_function(..., replace=True), closes #199 2020-11-06 10:30:41 -08:00
Simon Willison
7c22a64fb6 .search() now works differently for FTS4 v.s. FTS5 2020-11-06 10:30:41 -08:00
Simon Willison
de39e8db1e Refactored to table.search_sql() method, added --limit 2020-11-06 10:30:41 -08:00
Simon Willison
2c00567aac sqlite-utils search WIP, refs #192 2020-11-06 10:30:41 -08:00
Simon Willison
59d8689ed0 table.virtual_table_using property, closes #196 2020-11-04 19:53:45 -08:00
Simon Willison
43eae8b193 Release 2.23 2.23 
Refs #189, #173, #191
 2020-10-28 14:38:10 -07:00
Simon Willison
0789bad8f7 @db.register_function(deterministic=True), closes #191 2020-10-28 14:30:58 -07:00
Simon Willison
f99a236529
 		Progress bar for sqlite-utils insert command, closes #173 2020-10-27 11:16:02 -07:00
Simon Willison
c7e5dd6451 Applied latest Black 2020-10-27 09:26:01 -07:00