remote/sqlite-utils
1
0
Fork 0
mirror of https://github.com/simonw/sqlite-utils.git synced 2026-07-23 09:24:31 +02:00
Code Issues Projects Releases Packages Wiki Activity
410 commits 70 branches 137 tags 7.2 MiB
Commit graph

410 commits

This branch
This branch
All branches
Author SHA1 Message Date
Tom V
7805d53bcf
 		Fix accidental mega long line in docs (#158) 
Thanks @tomviner
 2020-09-15 23:21:42 -07:00
Simon Wiles
367082e787
 		Typos in tests (#156) 
Thanks @simonwiles
 2020-09-09 11:21:22 -07:00
Simon Willison
6be6126364 Release 2.18 2.18 
Refs #145. #155
 2020-09-08 16:37:28 -07:00
Simon Willison
32f1badfec Tracer example using print, refs #150 2020-09-08 16:27:55 -07:00
Simon Wiles
e6d202b742
 		Handle case where subsequent records (after first batch) include extra columns 
Refs #145.

* Extract build_insert_queries_and_params
* Extract insert_chunk so it can be called recursively

Thanks, @simonwiles
 2020-09-08 16:20:36 -07:00
Simon Willison
176f4e0ef4 sqlite-utils rebuild-fts command, closes #155 2020-09-08 16:16:03 -07:00
Simon Willison
76548596a6 optimize command now accepts optional tables, refs #155 2020-09-08 15:34:55 -07:00
Simon Willison
9680a0291c 'Soundness check' is better 2020-09-08 15:24:39 -07:00
Simon Willison
64799df78b .optimize() no longer cleans up _docsize 
This isn't necessary any more since the new .rebuild_fts()
method can achieve the same thing.

Refs #155, #153
 2020-09-08 15:18:12 -07:00
Simon Willison
4c0f79398f table.rebuild_fts() method, refs #155 2020-09-08 15:09:25 -07:00
Simon Willison
deb2eb013f Release notes for 2.17 2.17 2020-09-07 15:08:12 -07:00
Simon Willison
f28cd4de6d
 		Release 2.17 
Refs #144, #148, #149, #150, #151, #152, #153
 2020-09-07 14:58:49 -07:00
Simon Willison
cf2cb244fa
 		Tracer mechanism for showing underlying SQL queries 
* Pass a tracer= function to Database constructor
* New db.tracer() contextmanager
* Neater SQL indentation, because tracer means it could be visible now
* New db.execute() and db.executescript() methods

Closes #150
 2020-09-07 14:56:59 -07:00
Simon Willison
3e87500e15 table.optimize() deletes junk docsize rows 
Closes #153. Closes #149.
 2020-09-07 14:16:13 -07:00
Simon Willison
c449064297 Additional tests for WAL mode 
This should have been included in 2d2d724e32

Refs #132
 2020-09-07 13:46:12 -07:00
Simon Willison
de10590344 recursive_triggers=on by default, closes #152 
Refs #149
 2020-09-07 13:45:06 -07:00
Simon Willison
e878f2a8fe Applied latest black 2020-09-07 12:45:54 -07:00
Simon Willison
59e3d4d171 Neater indentation for SQL used in schemas, closes #148 2020-09-07 11:12:45 -07:00
Simon Willison
0e62744da9
 		Correct import path for AlterError exception 2020-09-02 13:29:46 -07:00
Simon Willison
e0cd430e89
 		Docs for sqlite_utils.AlterError in add_foreign_keys() 2020-09-02 13:17:01 -07:00
Simon Willison
cbc22ef20c
 		Add numpy to the matrix, refs #144 2020-08-28 15:56:06 -07:00
Simon Willison
1a9dab86fe Release 2.16.1 2.16.1 
Refs #139, #142, #143
 2020-08-28 15:45:11 -07:00
Simon Willison
01c7784be5 CI is now GitHub Actions, closes #143 2020-08-28 15:41:29 -07:00
Simon Willison
d7d3f96286 Black now runs in GitHub actions, refs #143 2020-08-28 15:37:45 -07:00
Simon Willison
8c405965e9 GitHub Actions workflows, refs #143 2020-08-28 15:36:55 -07:00
Simon Willison
10c6fbc368 Applied Black 20.8b1, refs #142 2020-08-28 15:30:57 -07:00
Simon Wiles
947bb7626f
 		insert_all(..., alter=True) works for columns introduced after first 100 records 
* Insert all columns for every chunk
* Update unit test to reflect new behaviour
* Test that exception is raised
* Update documentation

Closes #139. Thanks, Simon Wiles!
 2020-08-28 15:30:13 -07:00
Simon Willison
ea87c2b943 Release 2.16 2.16 
Refs #134, #135
 2020-08-21 14:02:29 -07:00
Simon Willison
c8b2433481 Install spatialite in Travis for --load-extension tests, refs #134 2020-08-21 14:01:44 -07:00
Simon Willison
7e9aad7e1c --load-extension option for sqlite-utils query, closes #134 2020-08-21 13:54:11 -07:00
Simon Willison
bf4c6b7c82 find_spatialite() utility function, closes #135 2020-08-21 13:30:02 -07:00
Simon Willison
c8d7969192 Release 2.15.1 2.15.1 
Refs #133
 2020-08-12 09:59:48 -07:00
Simon Willison
d03fc607b3
 		Package as sdist as well, refs #133 
Also refs https://github.com/simonw/homebrew-datasette/issues/10
 2020-08-12 09:56:36 -07:00
Simon Willison
66ed36258a Renaming from master to main 2020-08-10 14:04:32 -07:00
Simon Willison
7536a5a0f6 Release 0.15 2.15 
Refs #132
 2020-08-10 12:06:02 -07:00
Simon Willison
2d2d724e32 Tools for enabling and disabling WAL, closes #132 2020-08-10 11:59:21 -07:00
Simon Willison
957f8c9b4c
 		2.14.1 release notes 2.14.1 2020-08-05 23:31:11 -07:00
Simon Willison
5de24ee0a4
 		Release 2.14.1 2020-08-05 23:28:50 -07:00
Simon Willison
db1e08c2c8
 		Documentation for table.detect_fts() method 2020-08-05 19:21:49 -07:00
Simon Willison
5560d717cb
 		Updated list of supported parameters to db.table() 2020-08-01 14:30:43 -07:00
Simon Willison
a8b922bcb9 Release 2.14 2.14 
Refs #127, #130
 2020-08-01 13:58:47 -07:00
Simon Willison
57e4eb8e55 sqlite-utils populate-fts --tokenize= option, closes #130 2020-08-01 13:51:05 -07:00
Simon Willison
617e6f070c enable_fts(..., tokenize=X) parameter, refs #130 2020-08-01 13:40:36 -07:00
Simon Willison
8fe1e6d1be insert-files can now read from stdin, closes #127 2020-07-29 20:08:12 -07:00
Simon Willison
710454d72a Release 2.13 2.13 
Refs #128
 2020-07-29 18:13:53 -07:00
Simon Willison
f804690274 Support inserting UUID and memoryview, closes #128 2020-07-29 18:10:33 -07:00
Simon Willison
3214af4a20
 		Fixed bug in one of the insert-files examples 2020-07-27 18:53:57 -07:00
Simon Willison
3f6a10b807 Release 2.12 2.12 
Refs #122, #123, #124, #125, #126
 2020-07-27 00:21:26 -07:00
Simon Willison
ebc802f7ff sqlite-utils insert-files command, closes #122 2020-07-27 00:08:57 -07:00
Simon Willison
1a61a6d3d6 Ability to insert base64 binary data as JSON, closes #126 2020-07-26 20:59:34 -07:00