github: commits: 760 rows where repo = 140912432

760 rows where repo = 140912432

Search:

descending

sha ▼	message	author_date	committer_date	raw_author	raw_committer	repo	author	committer
00c5a49a87e1ef3e39bb7ec5ab61f7c17f9ecd60	Option to ignore inserts if primary key exists already Support for SQLite's INSERT OR IGNORE In the API layer it looks like this: fresh_db["test"].insert({"id": 1, "bar": 3}, ignore=True) For the CLI layer it looks like this: $ sqlite-utils insert data.db dogs dogs.json --ignore Closes #21	2019-05-29T04:15:57Z	2019-05-29T04:15:57Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
00e4bd5ff18ef4c3db6c1d67e2b974131c80d65c	TSV and JSON support for sqlite-utils memory Closes #281, closes #279, refs #272	2021-06-19T03:11:54Z	2021-06-19T03:11:54Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0142c2a3c2772cc370c734e7e6049e8cc2343a5f	Improved test_create_index_analyze test, refs #378	2022-01-10T20:02:08Z	2022-01-10T20:02:08Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
015bd2a840a008a105f731c50eee319963352c1b	Test for .table_names(fts5=True)	2019-01-25T04:23:53Z	2019-01-25T04:23:53Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
01c7784be54d14ee5b653753c38005d823fcdd09	CI is now GitHub Actions, closes #143	2020-08-28T22:41:29Z	2020-08-28T22:41:29Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
022cdd97a9ddab1a152e23e1e1c42e78c1ed0fa9	Much, much faster extract() implementation Takes my test down from ten minutes to four seconds! * Removed unnecessary update() optimization * Added column_order= to .transform() and .transform_sql() * Tests for reusing lookup table in extract() Closes #172	2020-09-24T15:43:55Z	2020-09-24T15:43:55Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
02862be04c51e8ec6e29517d3c28b030627bb179	Default to FTS5	2018-08-13T00:21:55Z	2018-08-13T00:21:55Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	sqlite-utils 140912432	simonw 9599	simonw 9599
02898bf7af4a4e484ecc8ec852d5fee98463277b	Run flake8 in CI, refs #291	2021-06-23T01:23:12Z	2021-06-23T01:23:12Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
034d498b319d37b0639203fa4fbb304715b3ae03	Support Database(memory=True) for in-memory databases	2019-07-23T00:12:54Z	2019-07-23T00:12:54Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
036ec6d32313487527c66dea613a3e7118b97459	Ignore test .db files	2021-01-03T18:43:21Z	2021-01-03T18:43:21Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
03e3f7d6486123bf3eb852ad007d9761475f138c	Configured Travis CI	2018-07-28T13:48:53Z	2018-07-28T13:48:53Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	sqlite-utils 140912432	simonw 9599	simonw 9599
03ee97d2258254581bea72842518904fc1cbe60f	CLI now supports upsert/insert - closes #115	2020-06-12T17:40:53Z	2020-06-12T17:40:53Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
046e5246c9698a6fc9901ca265ae47c68fcf5d13	Longer delay to hopefully get test to pass, refs #364	2022-01-10T04:51:07Z	2022-01-10T04:51:07Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
04ec53c039feb590c7832d499a14a9caba081f11	Validate column names in more places, refs #86	2020-02-27T04:55:17Z	2020-02-27T04:55:17Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
05317f53411fab3c3d66b88408bc867f2e474a35	Release 0.14	2019-02-24T23:11:51Z	2019-02-24T23:11:51Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
05a85b358fb907d8fcb72f19390ee2ba5a2261a5	Don't assume -1 for error code	2019-02-24T19:50:56Z	2019-02-24T19:50:56Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0747dabb24b608e8524de4858ce50c60ba7e471b	table.update() method * Also now set .last_pk to lastrowid for rowid tables * table.pks introspection now returns ["rowid"] for rowid tables Closes #35	2019-07-28T15:43:50Z	2019-07-28T15:43:50Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
0789bad8f7581fd96dec5bde51a75e937dffb1e0	@db.register_function(deterministic=True), closes #191	2020-10-28T21:24:03Z	2020-10-28T21:30:58Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
07a10bdb2c09c7e275a9db546c42900b1dea4e75	foreign_keys=[...] can now detect tables and keys - closes #25	2019-06-13T05:32:26Z	2019-06-13T05:32:26Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
088d89982299f8136e608fa2b6c30e9529adc714	Release 3.23 Refs #79, #363, #392, #393, #395, #396	2022-02-04T06:41:46Z	2022-02-04T06:41:46Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
092e1368edc4e7f4cb337a62eabd9a6e1245006b	Fixed typo	2019-05-25T14:24:17Z	2019-05-25T14:24:17Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
09316835e609e2321dafa08d37d8f227521373f8	Implemented --tsv option, closes #41	2019-07-19T04:50:38Z	2019-07-19T04:50:38Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0988f2eccc2dfa26b1a55243582222f540a72838	Explicitly include tests and docs in sdist (#75) Also exclude 'tests' from runtime installation - thanks, @jayvdb	2020-01-31T00:21:26Z	2020-01-31T00:21:26Z	John Vandenberg 85de645274a2cefaeda2a43f117f5e672fd8e2f9	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	jayvdb 15092	web-flow 19864447
09c3386f55f766b135b6a1c00295646c4ae29bec	Applied Black, refs #237	2021-02-25T17:13:00Z	2021-02-25T17:13:00Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0a0cec3cf27861455e8cd1c4d84937825a18bb30	Release 1.12.1	2019-11-07T04:58:47Z	2019-11-07T04:58:47Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
0a8194e730f8ecdd9a5af1f6a8d5a889796d7dba	sqlite-utils optimize command, .optimize() and .detect_fts() table methods	2019-01-25T04:35:51Z	2019-01-25T04:35:51Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0aa28293adedc488eb9107dc52b5e9a124887fbd	Fix compatibility with SQLite prior to 3.16.0 pragma_index_info() and pragma_index_list() were introduced in 3.16.0 but the version of SQLite running in Travis CI is earlier than that, hence the test failures: https://travis-ci.com/simonw/sqlite-utils/jobs/137617744	2018-08-01T15:29:53Z	2018-08-01T15:29:53Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	sqlite-utils 140912432	simonw 9599	simonw 9599
0b0a431bff94d24866fc10d82dc91ab00287de2d	Changelog for 2.0 release	2019-12-30T06:18:44Z	2019-12-30T06:18:44Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0b1af42ead3b3902347951180b3364ce1942da6e	Link to my blog entry	2019-02-25T03:45:38Z	2019-02-25T03:45:38Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
0b244d207a460d872cdac029d01deec784058858	Release 3.2.1 Refs #221	2021-01-12T23:22:53Z	2021-01-12T23:22:53Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0b5edd646926d6e01e3bf9f2897d072f4302ce2d	Added basic tests using hypothesis, closes #180	2020-10-19T04:51:50Z	2020-10-19T04:51:50Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0b7b80bd40fe86e4d66a04c9f607d94991c45c0b	Document the convert() with initialization pattern, closes #420	2022-03-25T20:07:29Z	2022-03-25T20:07:29Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0bc49e938e1e3444df734f9178a9a317f68f9716	'sqlite-utils add-column name type' command, closes #15	2019-02-24T20:04:33Z	2019-02-24T20:04:33Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0c1b8b7f96be874bb63801f69323960f277aa49a	Use assertion to enforce <=999 columns	2019-07-28T11:41:57Z	2019-07-28T11:41:57Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0c2451e0690c5f4e6463a2f339b0a280e30ed806	Release 2.3	2020-02-08T23:56:16Z	2020-02-08T23:56:16Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0c36feb6ca5c3ffb9a6df4c8ea4bb732fcab74f4	.enable_fts() now works with columns with spaces in them, closes #90	2020-03-02T06:10:43Z	2020-03-02T06:10:43Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0c6745b70f95663f8ddf4309c578bd568eca75ec	Whitespace fix	2019-02-24T18:42:27Z	2019-02-24T18:42:27Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0ca5585fcb834122193e8e7186f926217b23cb8a	Clarify why you would want transform_sql()	2020-09-23T20:16:01Z	2020-09-23T20:16:01Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0d10402f7b0428c6bb275a106b628298c6d0201d	table.create_index(..., analyze=True), refs #378	2022-01-10T20:00:24Z	2022-01-10T20:00:24Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0d2a47eab99f625be7ef4f77c6e9803177d13a2c	.reset_counts() method and reset-counts command, closes #219	2021-01-03T20:59:31Z	2021-01-03T20:59:31Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0d2e4f49f324de01bcd8257d0adeea3ebf391791	db.schema and 'sqlite-utils schema' command, closes #268	2021-06-11T20:51:49Z	2021-06-11T20:51:49Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0d63128c40aec15a958dddf181c13e0db1c7908b	Preparing v0.2, first release to PyPI	2018-07-29T00:42:41Z	2018-07-29T00:42:41Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	sqlite-utils 140912432	simonw 9599	simonw 9599
0dca784dbe6b75de6e4c0da4869c0b2b9574dde4	Release 3.1.1 Refs #209. Also updated copyright footer in documentation.	2021-01-01T23:56:20Z	2021-01-01T23:56:20Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0e60f3c80cd6df5c177d8405afc54d014addebd0	Better error message if table has no columns, closes #424	2022-04-13T22:39:48Z	2022-04-13T22:39:48Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0e62744da9a429093e3409575c1f881376b0361f	Correct import path for AlterError exception	2020-09-02T20:29:46Z	2020-09-02T20:29:46Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
0e797033f96a1c61b173a3d8af2ff36905687a2e	.transform() on rowid (non-pk) tables bug fix, closes #284	2021-06-19T15:28:26Z	2021-06-19T15:28:26Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0e7b461eb3e925aef713206c15794ceae9259c57	Fixed typo	2019-08-04T04:13:31Z	2019-08-04T04:13:31Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
0eda638d81280c7e585db071c35444e14b0b00f6	table.exists() now a documented method, closes #83	2020-02-08T23:56:03Z	2020-02-08T23:56:03Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0f8b042b47ab4516829a2e56a2668fff0c5329e6	Release 2.11 Refs #118, #120	2020-07-08T17:28:29Z	2020-07-08T17:28:29Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
0fe0f476a73ddbb3fea879bdb6bfef3ba4b97768	Fix for mypy error, closes #396 Should help tests pass for #395 and #79	2022-02-04T06:10:09Z	2022-02-04T06:10:28Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0fe3b38290e1bb2d92746d90318d8662b57218bd	Added db-to-sqlite to "Related projects"	2019-06-29T21:34:24Z	2019-06-29T21:34:24Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
1091a9cbd804504efa8e1126226759e736e3ccdf	Add sqlite-utils memory to the README, refs #272	2021-06-19T03:14:12Z	2021-06-19T03:14:12Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
10c6fbc3689311091a18ad4f8d1098e6761c35bc	Applied Black 20.8b1, refs #142	2020-08-28T22:30:57Z	2020-08-28T22:30:57Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
10e3aab4c63bc02cacd64e7aa1e5eaff2b314b3e	Fixed typo with last_pk	2019-02-24T06:49:54Z	2019-02-24T06:49:54Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
10f4913c144c4680c0feec576c2d4080f5005b33	Release 3.9.1 Refs #271	2021-06-13T02:59:08Z	2021-06-13T02:59:08Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1125460497e0891e730f3e5feff2bb04a78c9163	Improved column type introspection, closes #92	2020-03-14T20:04:06Z	2020-03-14T20:04:06Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
11a9511d23ba79e7c8c92bc90ec29ba7f22e3eb7	Updated README to reflect new query default subcommand	2019-02-23T01:53:48Z	2019-02-23T01:53:48Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
125c625fbc46244a4b4025732e1526fb13c55843	.rows_where(..., order_by=) argument, closes #76	2020-04-16T03:12:55Z	2020-04-16T03:12:55Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
126703706ea153f63e6134ad14e5712e4bbcb8ae	Release 3.19 Refs #342	2021-11-21T04:40:47Z	2021-11-21T04:41:56Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
127a836054fb784dc02ea40dadb55b3741dcd603	Documented new table configuration options via .table()	2019-07-22T23:59:17Z	2019-07-22T23:59:17Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
129141572f249ea290e2a075437e2ebaad215859	`sqlite-utils bulk` command * sqlite-utils bulk command, closes #375 * Refactor import_options and insert_upsert_options, refs #377 * Tests for sqlite-utils bulk, refs #377 * Documentation for sqlite-utils bulk, refs #377	2022-01-11T02:10:54Z	2022-01-11T02:10:54Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
12b8c9de256ba907d4fa8e134bf9ce9bc012302e	sqlite-utils memory --flatten, closes #332	2021-11-14T23:05:00Z	2021-11-14T23:05:00Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
13195d8747764df3952ed1117e0fd2152f1899e7	Test demonstrating fix for #335	2021-11-14T22:55:42Z	2021-11-14T22:55:42Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
13528faa817d79bc3900d3af7473300686b145d7	Release 2.6	2020-04-16T03:13:13Z	2020-04-16T03:13:13Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
13e76b375ac3e3448df5d705ba65fadaaf9887d6	Release 3.10 Refs #272, #274, #275, #276, #282, #284, #285	2021-06-19T16:01:39Z	2021-06-19T16:01:39Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
147b52622d68473ba6ab184657258d8576100b05	sqlite-utils tables ... --schema option, closes #104	2020-05-01T17:09:36Z	2020-05-01T17:12:16Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
148e9c7aeea2486b0562814b82f152506bfb0dd5	Use cog to maintain --fmt list, closes #373	2022-01-09T17:48:48Z	2022-01-09T17:48:48Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
14f643d9e91f5557d5e46251dadac481f4b41021	Better error messages in CLI, closes #309	2021-08-09T22:25:52Z	2021-08-09T22:25:52Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
152eb2afaf35cde5d44e50369f4cb32a72e72fdb	Use pysqlite3 if available	2019-07-22T22:39:35Z	2019-07-22T22:39:35Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
15368c5f59066fc9c6b8ce5d0578132b1b68b75d	First working version of .update(), refs #35	2019-07-14T17:03:18Z	2019-07-28T12:15:50Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
15758d02fd437004fd9f84c9d4a8bf49f0793e13	Fixed spelling of objects, refs #310	2021-08-09T21:45:39Z	2021-08-09T21:45:39Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
16987bd56ef04ed1f1629b58272d8592c3a13249	Removed rogue assert False, refs #240	2021-02-25T16:35:24Z	2021-02-25T16:35:24Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
169ea455fc1f1d5e5b6e44cb339ba7ffa9d49c31	Added table.delete_where(), closes #62	2019-11-04T16:18:06Z	2019-11-04T16:18:06Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
16d7008002b43cf47a973791da93e5cdd5913fc3	Applied black	2019-07-28T15:37:27Z	2019-07-28T15:37:27Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
176f4e0ef4a4825ae3b61a5f7169a8943fccb073	sqlite-utils rebuild-fts command, closes #155	2020-09-08T23:16:03Z	2020-09-08T23:16:03Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1843d55615fa1bdce7d06919965c40acf22b05bb	@cli.command(name="csv") instead of import csv as csv_std	2019-01-29T15:37:01Z	2019-01-29T15:37:12Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
19073d6d972fad9d68dd74c28544cd29083f1c12	Added table.delete(pk) method, refs #62	2019-11-04T16:07:44Z	2019-11-04T16:08:01Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
19e1057ead0c4434f456bafb4812de2812d51bf5	Documentation for create_view()	2018-08-02T15:26:38Z	2018-08-02T15:26:38Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	sqlite-utils 140912432	simonw 9599	simonw 9599
1a053d9438cb217e54e7784777e11620ece8fed0	Added Python library example to README	2019-07-03T18:04:03Z	2019-07-03T18:04:03Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
1a61a6d3d65d14af325889fb5149794bb6c7b214	Ability to insert base64 binary data as JSON, closes #126	2020-07-27T03:59:15Z	2020-07-27T03:59:34Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1a93b72ba710ea2271eaabc204685a27d2469374	Increase csv field_size_limit to maximum, closes #229 Refs #227	2021-02-14T21:33:21Z	2021-02-14T21:33:21Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1a9dab86fe22b122ea44e2161887fe3c0129297f	Release 2.16.1 Refs #139, #142, #143	2020-08-28T22:45:11Z	2020-08-28T22:45:11Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1b6025e8ab5cef6a6f2550cc3be1f80b12cc64a1	Release 0.13	2019-02-24T06:54:43Z	2019-02-24T06:54:43Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1b666f9315d4ea6bb332b2e75e48480c26100199	--delimiter and --quotechar, closes #223	2021-02-06T01:34:47Z	2021-02-06T01:34:47Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1b84c175b455ece931c728e25f3df859c1ad2fdc	--analyze option for create-index, insert, update commands, closes #379, closes #365	2022-01-11T01:36:41Z	2022-01-11T01:36:41Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1c683076d3138d9d853a1adb16fb9e6d248d1245	Sanity check test for optimize --no-vacuum	2019-01-25T04:38:23Z	2019-01-25T04:38:23Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1c745df92340ff861750643181a6a3c6685c3d55	Suggest column types ignores nulls, closes #94	2020-03-23T19:57:02Z	2020-03-23T19:57:02Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1c8a0e874fe0fc2eaade1a6c44d947e1e6c7b2b6	Release 1.2	2019-06-13T06:39:59Z	2019-06-13T06:39:59Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1cad7fad3e7a5b734088f5cc545b69a055e636da	table.enable_counts() method, closes #212	2021-01-02T21:40:10Z	2021-01-02T21:40:10Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1ce96d8c0854476e84216af5e5af71bcebbddb78	Release 3.1 Refs #204, #207, #208	2020-12-13T07:28:20Z	2020-12-13T07:30:59Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1d44b0cc2784c94aed1bcf350225cd86ee1aa7e5	CLI reference page, maintained by cog, closes #383	2022-01-11T21:43:39Z	2022-01-11T21:43:56Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1d64cd2e5b402ff957f9be2d9bb490d313c73989	sqlite-utils create-database command, closes #348	2022-01-09T20:33:16Z	2022-01-09T20:33:16Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1e28eeee8ce55ea68eddb228294a1eff6785b497	Fixed RST syntax bug	2019-05-28T05:25:03Z	2019-05-28T05:25:03Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
1e38a16ea8a58ec3eee8e54eee6c024d87f99d86	Nicer error message for invalid JSON insert, closes #206	2021-01-03T18:42:17Z	2021-01-03T18:42:17Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1e9eb875a64dfc65d786f4c6a52f6ba08b25b86b	Switch from codecs.getreader to io.TextIOWrapper, refs #230	2021-02-14T18:33:26Z	2021-02-14T18:33:26Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1ebffe1dbeaed7311e5b61ed988f4cd701e84808	Correction: SQLite ALTER TABLE can rename columns	2020-09-23T03:09:42Z	2020-09-23T03:09:42Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1f3f902ea4c991e6b8ad0fcfd6cffd01e3aa1c23	Typo	2019-12-30T13:01:36Z	2019-12-30T13:01:36Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1f49f32814a942fa076cfe5f504d1621188097ed	Don't need line_buffering=True here, refs #230	2021-02-15T19:18:28Z	2021-02-15T19:18:28Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1f8178f7e41f64965195c1320d310032d783a8b1	Fix flake8 error, refs #344, #345	2021-11-29T22:29:46Z	2021-11-29T22:29:57Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
1fa5a12a4952b02341e2a59ba75aabb740518ecb	Documentation for db.quote_fts(), refs #246	2021-08-18T18:55:50Z	2021-08-18T18:55:50Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [commits] (
   [sha] TEXT PRIMARY KEY,
   [message] TEXT,
   [author_date] TEXT,
   [committer_date] TEXT,
   [raw_author] TEXT REFERENCES [raw_authors]([id]),
   [raw_committer] TEXT REFERENCES [raw_authors]([id]),
   [repo] INTEGER REFERENCES [repos]([id]),
   [author] INTEGER REFERENCES [users]([id]),
   [committer] INTEGER REFERENCES [users]([id])
);
CREATE INDEX [idx_commits_committer]
                ON [commits] ([committer]);
CREATE INDEX [idx_commits_author]
                ON [commits] ([author]);
CREATE INDEX [idx_commits_repo]
                ON [commits] ([repo]);
CREATE INDEX [idx_commits_raw_committer]
                ON [commits] ([raw_committer]);
CREATE INDEX [idx_commits_raw_author]
                ON [commits] ([raw_author]);