releases
344 rows sorted by name
This data as json, CSV (advanced)
Suggested facets: target_commitish, prerelease, repo, created_at (date)
published_at (date) >30 ✖
- 2019-09-03 5
- 2020-03-21 4
- 2020-08-12 4
- 2020-09-01 4
- 2020-09-03 4
- 2019-09-04 3
- 2019-09-14 3
- 2019-10-16 3
- 2019-11-13 3
- 2020-02-07 3
- 2020-03-20 3
- 2020-03-28 3
- 2020-04-30 3
- 2020-09-17 3
- 2018-12-16 2
- 2019-01-28 2
- 2019-02-23 2
- 2019-02-24 2
- 2019-07-20 2
- 2019-07-28 2
- 2019-10-07 2
- 2019-10-11 2
- 2019-10-30 2
- 2019-11-02 2
- 2019-11-07 2
- 2020-03-14 2
- 2020-03-23 2
- 2020-03-24 2
- 2020-04-01 2
- 2020-04-16 2
- …
id | html_url | node_id | tag_name | target_commitish | name ▼ | draft | author | prerelease | created_at | published_at | body | repo | reactions |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48604143 | https://github.com/simonw/datasette/releases/tag/0.59a2 | MDc6UmVsZWFzZTQ4NjA0MTQz | 0.59a2 | main | 0.59a2 | 0 | simonw 9599 | 1 | 2021-08-28T01:55:54Z | 2021-08-28T01:57:38Z | - Columns can now have associated metadata descriptions in `metadata.json`, see [Column descriptions](https://docs.datasette.io/en/latest/metadata.html#metadata-column-descriptions). ([#942](https://github.com/simonw/datasette/issues/942)) - New [register_commands()](https://docs.datasette.io/en/latest/plugin_hooks.html#plugin-hook-register-commands) plugin hook allows plugins to register additional Datasette CLI commands, e.g. `datasette mycommand file.db`. ([#1449](https://github.com/simonw/datasette/issues/1449)) - Adding `?_facet_size=max` to a table page now shows the number of unique values in each facet. ([#1423](https://github.com/simonw/datasette/issues/1423)) - Code that figures out which named parameters a SQL query takes in order to display form fields for them is no longer confused by strings that contain colon characters. ([#1421](https://github.com/simonw/datasette/issues/1421)) - Renamed `--help-config` option to `--help-settings`. ([#1431](https://github.com/simonw/datasette/issues/1431)) - `datasette.databases` property is now a documented API. ([#1443](https://github.com/simonw/datasette/issues/1443)) - Datasette base template now wraps everything other than the `<footer>` in a `<div class="not-footer">` element, to help with advanced CSS customization. ([#1446](https://github.com/simonw/datasette/issues/1446)) | datasette 107914493 | |
19669553 | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.1 | MDc6UmVsZWFzZTE5NjY5NTUz | 0.1 | master | 0.1 | 0 | simonw 9599 | 0 | 2019-08-31T02:46:58Z | 2019-08-31T02:58:32Z | First usable release. | swarm-to-sqlite 205429375 | |
20114205 | https://github.com/dogsheep/genome-to-sqlite/releases/tag/0.1 | MDc6UmVsZWFzZTIwMTE0MjA1 | 0.1 | master | 0.1 | 0 | simonw 9599 | 0 | 2019-09-19T15:38:10Z | 2019-09-19T15:41:17Z | First release | genome-to-sqlite 209590345 | |
20506896 | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.1 | MDc6UmVsZWFzZTIwNTA2ODk2 | 0.1 | master | 0.1 | 0 | simonw 9599 | 0 | 2019-10-07T05:07:37Z | 2019-10-07T05:18:20Z | Initial release | pocket-to-sqlite 213286752 | |
30481804 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.1 | MDc6UmVsZWFzZTMwNDgxODA0 | 0.1 | main | 0.1 | 0 | simonw 9599 | 0 | 2020-09-01T06:10:44Z | 2020-09-01T06:12:05Z | - Optimize the FTS table and vacuum the database. #4 - First non-alpha release | dogsheep-beta 197431109 | |
32428098 | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.1 | MDc6UmVsZWFzZTMyNDI4MDk4 | 0.1 | main | 0.1 | 0 | simonw 9599 | 0 | 2020-10-11T21:46:09Z | 2020-10-11T21:47:39Z | - Initial release, with support for importing ENEX files. | evernote-to-sqlite 303218369 | |
95017974 | https://github.com/dogsheep/apple-notes-to-sqlite/releases/tag/0.1 | RE_kwDOJHON9s4Fqdv2 | 0.1 | main | 0.1 | 0 | simonw 9599 | 0 | 2023-03-09T05:11:00Z | 2023-03-09T05:12:12Z | - Initial working version. `apple-notes-to-sqlite notes.db` dumps your notes out to a SQLite database. [#2](https://github.com/dogsheep/apple-notes-to-sqlite/issues/2) - `apple-notes-to-sqlite --dump` outputs them to standard output as newline-delimited JSON. [#3](https://github.com/dogsheep/apple-notes-to-sqlite/issues/3) | apple-notes-to-sqlite 611552758 | |
19993251 | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.1.1 | MDc6UmVsZWFzZTE5OTkzMjUx | 0.1.1 | master | 0.1.1 | 0 | simonw 9599 | 0 | 2019-09-14T19:19:33Z | 2019-09-14T19:42:08Z | * Fix bug in authentication handling code | github-to-sqlite 207052882 | |
15439849 | https://github.com/simonw/sqlite-utils/releases/tag/0.10 | MDc6UmVsZWFzZTE1NDM5ODQ5 | 0.10 | master | 0.10 | 0 | simonw 9599 | 0 | 2019-02-07T05:17:52Z | 2019-02-08T05:19:33Z | https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v0-10 | sqlite-utils 140912432 | |
20721291 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.10 | MDc6UmVsZWFzZTIwNzIxMjkx | 0.10 | master | 0.10 | 0 | simonw 9599 | 0 | 2019-10-15T18:53:53Z | 2019-10-15T18:56:09Z | * favorites command now populates `favorited_by` table - #14 * favorites `--stop_after` option - #20 * Store unescaped `full_text` of Tweet - #21 | twitter-to-sqlite 206156866 | |
35382391 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.10 | MDc6UmVsZWFzZTM1MzgyMzkx | 0.10 | main | 0.10 | 0 | simonw 9599 | 0 | 2020-12-16T21:27:04Z | 2020-12-16T21:28:13Z | - Now depends on [sqlite-utils](https://github.com/simonw/sqlite-utils) >= 3.0. #30 - The user's original search term is now passed to the `display_sql` SQL query as the `:q` parameter. #29 | dogsheep-beta 197431109 | |
35520026 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.10.1 | MDc6UmVsZWFzZTM1NTIwMDI2 | 0.10.1 | main | 0.10.1 | 0 | simonw 9599 | 0 | 2020-12-19T06:18:01Z | 2020-12-19T06:19:13Z | - Fix for error if search query contains hyphens such as `github-to-sqlite`. #31 | dogsheep-beta 197431109 | |
44537329 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.10.2 | MDc6UmVsZWFzZTQ0NTM3MzI5 | 0.10.2 | main | 0.10.2 | 0 | simonw 9599 | 0 | 2021-06-13T14:37:17Z | 2021-06-13T14:38:09Z | - Fixed bug where searches consisting only of whitespace caused a server error. [#33](https://github.com/dogsheep/dogsheep-beta/issues/33) | dogsheep-beta 197431109 | |
15731282 | https://github.com/simonw/sqlite-utils/releases/tag/0.11 | MDc6UmVsZWFzZTE1NzMxMjgy | 0.11 | master | 0.11 | 0 | simonw 9599 | 0 | 2019-02-08T05:23:50Z | 2019-02-23T02:15:34Z | https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v0-11 | sqlite-utils 140912432 | |
20754277 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.11 | MDc6UmVsZWFzZTIwNzU0Mjc3 | 0.11 | master | 0.11 | 0 | simonw 9599 | 0 | 2019-10-16T19:37:10Z | 2019-10-16T19:38:42Z | * Added `--since_id` and `--since` to `user-timeline` command, refs #20 * `--since` and `--since_id` options for `home-timeline`, closes #19 * `import` command now works on files and directories, closes #22 | twitter-to-sqlite 206156866 | |
20758324 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.11.1 | MDc6UmVsZWFzZTIwNzU4MzI0 | 0.11.1 | master | 0.11.1 | 0 | simonw 9599 | 0 | 2019-10-16T19:46:35Z | 2019-10-16T22:31:51Z | * Fix bugs running `home-timeline --since` from scratch. If tables were missing, script would throw an error. | twitter-to-sqlite 206156866 | |
15731354 | https://github.com/simonw/sqlite-utils/releases/tag/0.12 | MDc6UmVsZWFzZTE1NzMxMzU0 | 0.12 | master | 0.12 | 0 | simonw 9599 | 0 | 2019-02-23T02:22:28Z | 2019-02-23T02:31:29Z | https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v0-12 | sqlite-utils 140912432 | |
20783590 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.12 | MDc6UmVsZWFzZTIwNzgzNTkw | 0.12 | master | 0.12 | 0 | simonw 9599 | 0 | 2019-10-17T17:57:33Z | 2019-10-17T18:00:28Z | * The `source` column for a tweet is now a foreign key to a new `sources` table - #12 * New migrations system to upgrade existing databases to handle the new `source` column extraction - #23 * Experimental implementation of new `twitter-to-sqlite search tweets.db search-term` command, which runs a search and saves the tweets from that search - #3 * Fixed bug where sometimes a user record for the authenticated user was not persisted to the `users` table | twitter-to-sqlite 206156866 | |
15739051 | https://github.com/simonw/sqlite-utils/releases/tag/0.13 | MDc6UmVsZWFzZTE1NzM5MDUx | 0.13 | master | 0.13 | 0 | simonw 9599 | 0 | 2019-02-24T06:54:43Z | 2019-02-24T07:00:14Z | https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v0-13 | sqlite-utils 140912432 | |
21073645 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.13 | MDc6UmVsZWFzZTIxMDczNjQ1 | 0.13 | master | 0.13 | 0 | simonw 9599 | 0 | 2019-10-30T02:20:09Z | 2019-10-30T02:22:30Z | - New `mentions-timeline` command (#26) | twitter-to-sqlite 206156866 | |
15744513 | https://github.com/simonw/sqlite-utils/releases/tag/0.14 | MDc6UmVsZWFzZTE1NzQ0NTEz | 0.14 | master | 0.14 | 0 | simonw 9599 | 0 | 2019-02-24T23:11:51Z | 2019-02-24T23:15:16Z | https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v0-14 | sqlite-utils 140912432 | |
21180989 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.14 | MDc6UmVsZWFzZTIxMTgwOTg5 | 0.14 | master | 0.14 | 0 | simonw 9599 | 0 | 2019-11-04T05:32:37Z | 2019-11-04T05:33:56Z | * `search` command gained `--since_id` and `--since` options, for retrieving tweets since the last time the search was run * `search` command is [now documented](https://github.com/dogsheep/twitter-to-sqlite/blob/0.14/README.md#running-searches). Closes #3. | twitter-to-sqlite 206156866 | |
21342008 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.15 | MDc6UmVsZWFzZTIxMzQyMDA4 | 0.15 | master | 0.15 | 0 | simonw 9599 | 0 | 2019-11-09T20:12:32Z | 2019-11-09T20:13:07Z | - Import command no longer fails on empty files - #29 - Fixed bug in `followers` command - #30 - `following` table now has indexes - #28 | twitter-to-sqlite 206156866 | |
23471420 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.16 | MDc6UmVsZWFzZTIzNDcxNDIw | 0.16 | master | 0.16 | 0 | simonw 9599 | 0 | 2020-02-07T07:42:45Z | 2020-02-07T07:44:53Z | New `friends` command for importing accounts that a specific user follows. | twitter-to-sqlite 206156866 | |
24722801 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.17 | MDc6UmVsZWFzZTI0NzIyODAx | 0.17 | master | 0.17 | 0 | simonw 9599 | 0 | 2020-03-20T19:22:37Z | 2020-03-20T19:23:40Z | * Upgraded to latest `sqlite-utils` (currently 2.4.2) * This fixed a bug with `user-timeline` - #34 | twitter-to-sqlite 206156866 | |
24724394 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.18 | MDc6UmVsZWFzZTI0NzI0Mzk0 | 0.18 | master | 0.18 | 0 | simonw 9599 | 0 | 2020-03-20T20:16:46Z | 2020-03-20T20:19:42Z | * `twitter-to-sqlite user-timeline` command now accepts `--sql` and `--attach` and `--ids` options, and can also accept multiple screen names or user IDs as command arguments. #35 | twitter-to-sqlite 206156866 | |
24728163 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.19 | MDc6UmVsZWFzZTI0NzI4MTYz | 0.19 | master | 0.19 | 0 | simonw 9599 | 0 | 2020-03-20T23:14:02Z | 2020-03-20T23:16:53Z | * The `twitter-to-sqlite friends` and `twitter-to-sqlite followers` commands now accept the `--sql` and `--attach` options. #36 * Improved the display of the progress bar for the `user-timeline` command. #38 | twitter-to-sqlite 206156866 | |
24731201 | https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.1a | MDc6UmVsZWFzZTI0NzMxMjAx | 0.1a | master | 0.1a | 0 | simonw 9599 | 0 | 2020-03-21T04:19:07Z | 2020-03-21T04:26:28Z | * `user` and `trees` commands. | hacker-news-to-sqlite 248903544 | |
25832422 | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.1a | MDc6UmVsZWFzZTI1ODMyNDIy | 0.1a | master | 0.1a | 0 | simonw 9599 | 0 | 2020-04-19T00:15:55Z | 2020-04-24T00:40:57Z | * First alpha release | dogsheep-photos 256834907 | |
30477968 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.1a | MDc6UmVsZWFzZTMwNDc3OTY4 | 0.1a | main | 0.1a | 0 | simonw 9599 | 1 | 2020-09-01T04:16:59Z | 2020-09-01T04:19:00Z | - First working version | dogsheep-beta 197431109 | |
30478994 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.1a2 | MDc6UmVsZWFzZTMwNDc4OTk0 | 0.1a2 | main | 0.1a2 | 0 | simonw 9599 | 1 | 2020-09-01T04:49:41Z | 2020-09-01T04:50:01Z | - Now creates an index on the `timestamp` column. #1 | dogsheep-beta 197431109 | |
18750559 | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/0.2 | MDc6UmVsZWFzZTE4NzUwNTU5 | 0.2 | master | 0.2 | 0 | simonw 9599 | 0 | 2019-07-20T16:44:05Z | 2019-07-20T16:44:41Z | Fixed a bug where duplicate records could crash the import. | healthkit-to-sqlite 197882382 | |
19763185 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.2 | MDc6UmVsZWFzZTE5NzYzMTg1 | 0.2 | master | 0.2 | 0 | simonw 9599 | 0 | 2019-09-04T21:17:34Z | 2019-09-04T22:09:46Z | Full text search for tweets table | twitter-to-sqlite 206156866 | |
19993751 | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.2 | MDc6UmVsZWFzZTE5OTkzNzUx | 0.2 | master | 0.2 | 0 | simonw 9599 | 0 | 2019-09-14T21:31:17Z | 2019-09-14T21:32:34Z | * Added the `github-to-sqlite starred` command for retrieving starred repos, #1 | github-to-sqlite 207052882 | |
20755954 | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.2 | MDc6UmVsZWFzZTIwNzU1OTU0 | 0.2 | master | 0.2 | 0 | simonw 9599 | 0 | 2019-10-16T20:40:25Z | 2019-10-16T20:40:55Z | * Added --since option, closes #3 | swarm-to-sqlite 205429375 | |
24793032 | https://github.com/dogsheep/inaturalist-to-sqlite/releases/tag/0.2 | MDc6UmVsZWFzZTI0NzkzMDMy | 0.2 | master | 0.2 | 0 | simonw 9599 | 0 | 2020-03-24T00:35:44Z | 2020-03-24T00:36:40Z | * Upgraded to `sqlite-utils` 2.x * First non-alpha release | inaturalist-to-sqlite 206202864 | |
24950669 | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2 | MDc6UmVsZWFzZTI0OTUwNjY5 | 0.2 | master | 0.2 | 0 | simonw 9599 | 0 | 2020-03-27T22:23:16Z | 2020-03-27T22:26:30Z | * Defaults to only retrieving updated items, unless you use `--all`. #2 * Now displays a progress bar for initial data import and `--all`. * Data is now fetched 500 items at a time using API pagination. #1 * Now depends on `sqlite-utils 2.x`. * `auth.json` now uses `pocket_` prefix on each stored key. #4 | pocket-to-sqlite 213286752 | |
30536189 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.2 | MDc6UmVsZWFzZTMwNTM2MTg5 | 0.2 | main | 0.2 | 0 | simonw 9599 | 0 | 2020-09-01T20:40:52Z | 2020-09-01T20:41:31Z | - Use Porter stemming by default, allow that to be over-ridden with the new `--tokenize=` option. #2 | dogsheep-beta 197431109 | |
32429687 | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.2 | MDc6UmVsZWFzZTMyNDI5Njg3 | 0.2 | main | 0.2 | 0 | simonw 9599 | 0 | 2020-10-12T00:05:21Z | 2020-10-12T00:07:24Z | - Notes now use an ID derived from a hash of their contents. #3 - Date columns are now in ISO format, and indexd. #4 - Notes and resources table now have full-text search configured. #4 - Improved how OCR is stored in the database, only storing the most confident matches. #6 | evernote-to-sqlite 303218369 | |
32891952 | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.1 | MDc6UmVsZWFzZTMyODkxOTUy | 0.2.1 | master | 0.2.1 | 0 | simonw 9599 | 0 | 2020-10-22T00:06:50Z | 2020-10-22T00:08:24Z | - Tweaked dependencies for compatibility with new PyPI resolver. | pocket-to-sqlite 213286752 | |
32891966 | https://github.com/dogsheep/inaturalist-to-sqlite/releases/tag/0.2.1 | MDc6UmVsZWFzZTMyODkxOTY2 | 0.2.1 | master | 0.2.1 | 0 | simonw 9599 | 0 | 2020-10-22T00:08:29Z | 2020-10-22T00:08:58Z | - Tweaked dependencies for compatibility with new PyPI resolver. | inaturalist-to-sqlite 206202864 | |
75010827 | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.2 | RE_kwDODLZ_YM4EeJML | 0.2.2 | main | 0.2.2 | 0 | simonw 9599 | 0 | 2022-08-22T16:18:16Z | 2022-08-22T16:21:34Z | - `-a` is now the shortcut for `--auth` - previously it was duplicated as a shortcut for `--all`. Thanks, [Thomas Lockney](https://github.com/tlockney). [#7](https://github.com/dogsheep/pocket-to-sqlite/issues/7) - `pocket-to-sqlite auth` command now updates the existing `auth.json` file rather than over-writing it. [#10](https://github.com/dogsheep/pocket-to-sqlite/issues/10) | pocket-to-sqlite 213286752 | |
111513749 | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.3 | RE_kwDODLZ_YM4GpZCV | 0.2.3 | main | 0.2.3 | 0 | simonw 9599 | 0 | 2023-07-09T01:14:06Z | 2023-07-09T01:15:03Z | - Progress bar now includes a count of the total number of items to fetch. - Now packaged using `pyproject.toml`. [#12](https://github.com/dogsheep/pocket-to-sqlite/issues/12) | pocket-to-sqlite 213286752 | |
25070766 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.20 | MDc6UmVsZWFzZTI1MDcwNzY2 | 0.20 | master | 0.20 | 0 | simonw 9599 | 0 | 2020-04-01T04:18:17Z | 2020-04-01T04:18:53Z | * Reworked how `--since` works to fix a bug spotted in #39. The most recently seen tweet ID for various commands is now stored in a new `since_ids` table. * New feature: the friends, followers and listed counts for each user are now stored in a `count_history` table and updated any time we spot that the counts in that user's profile have changed. #40 | twitter-to-sqlite 206156866 | |
25070964 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.20.1 | MDc6UmVsZWFzZTI1MDcwOTY0 | 0.20.1 | master | 0.20.1 | 0 | simonw 9599 | 0 | 2020-04-01T04:31:23Z | 2020-04-01T04:33:35Z | * Buf fix: `since_id` table no longer records a record for `None`, `None`. #41 | twitter-to-sqlite 206156866 | |
25632029 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.21 | MDc6UmVsZWFzZTI1NjMyMDI5 | 0.21 | master | 0.21 | 0 | simonw 9599 | 0 | 2020-04-17T23:44:31Z | 2020-04-17T23:46:51Z | * New command: `twitter-to-sqlite lists username` fetches lists owned by the specified users. #43 * Handle tweets with a blank `source`. #44 * Fixed error with `twitter-to-sqlite user-timeline --sql=... --ids`. #42 * Better error messages for non-existing users. #37 | twitter-to-sqlite 206156866 | |
26059149 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.21.1 | MDc6UmVsZWFzZTI2MDU5MTQ5 | 0.21.1 | master | 0.21.1 | 0 | simonw 9599 | 0 | 2020-04-30T18:20:43Z | 2020-04-30T18:21:46Z | * Fixed bug that occurred when the `since_ids` table had not yet been created. #46 | twitter-to-sqlite 206156866 | |
28705982 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.21.2 | MDc6UmVsZWFzZTI4NzA1OTgy | 0.21.2 | master | 0.21.2 | 0 | simonw 9599 | 0 | 2020-07-18T22:42:54Z | 2020-07-18T22:43:20Z | - Added changelog badge | twitter-to-sqlite 206156866 | |
28876263 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.21.3 | MDc6UmVsZWFzZTI4ODc2MjYz | 0.21.3 | master | 0.21.3 | 0 | simonw 9599 | 0 | 2020-07-23T14:56:02Z | 2020-07-23T14:57:11Z | * Added table of contents to the documentation | twitter-to-sqlite 206156866 | |
48150315 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.21.4 | MDc6UmVsZWFzZTQ4MTUwMzE1 | 0.21.4 | main | 0.21.4 | 0 | simonw 9599 | 0 | 2021-08-20T00:14:08Z | 2021-08-20T00:14:30Z | - Fix for `since_id` error with `user-timeline`. [#57](https://github.com/dogsheep/twitter-to-sqlite/issues/57) - Document the use of `--stop_after` with favorites - thanks, Mike Lee Williams. [#49](https://github.com/dogsheep/twitter-to-sqlite/pull/49) - Fixes for Twitter archive imports, thanks Jacob Kaplan-Moss. [#55](https://github.com/dogsheep/twitter-to-sqlite/pull/55) | twitter-to-sqlite 206156866 | |
50003635 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.22 | RE_kwDODEm0Qs4C-v6z | 0.22 | main | 0.22 | 0 | simonw 9599 | 0 | 2021-09-21T17:39:08Z | 2021-09-21T17:41:05Z | - `twitter-to-sqlite import` now imports `app.js` to `archive_app` table. - Small fixes for `twitter-to-sqlite import` reflecting changed filenames in the Twitter export. - Fix for remaining `since_id` bug, thanks Ruben Vermeersch! [#58](https://github.com/dogsheep/twitter-to-sqlite/issues/58) | twitter-to-sqlite 206156866 | {"url": "https://api.github.com/repos/dogsheep/twitter-to-sqlite/releases/50003635/reactions", "total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 1, "rocket": 0, "eyes": 0} |
18598489 | https://github.com/simonw/datasette/releases/tag/0.29.1 | MDc6UmVsZWFzZTE4NTk4NDg5 | 0.29.1 | master | 0.29.1 | 0 | simonw 9599 | 0 | 2019-07-11T16:17:55Z | 2019-07-14T01:43:44Z | - Fixed bug with static mounts using relative paths which could lead to traversal exploits (#555) - thanks Abdussamet Kocak! https://datasette.readthedocs.io/en/stable/changelog.html#v0-29-1 | datasette 107914493 | |
19704661 | https://github.com/simonw/datasette/releases/tag/0.29.2 | MDc6UmVsZWFzZTE5NzA0NjYx | 0.29.2 | master | 0.29.2 | 0 | simonw 9599 | 0 | 2019-07-14T03:04:05Z | 2019-09-03T00:33:35Z | * Bumped Uvicorn to 0.8.4, fixing a bug where the querystring was not included in the server logs. (#559) * Fixed bug where the navigation breadcrumbs were not displayed correctly on the page for a custom query. (#558) * Fixed bug where custom query names containing unicode characters caused errors. https://datasette.readthedocs.io/en/stable/changelog.html#v0-29-2 | datasette 107914493 | |
20795250 | https://github.com/simonw/datasette/releases/tag/0.29.3 | MDc6UmVsZWFzZTIwNzk1MjUw | 0.29.3 | master | 0.29.3 | 0 | simonw 9599 | 0 | 2019-09-03T00:40:53Z | 2019-10-18T05:24:54Z | https://datasette.readthedocs.io/en/stable/changelog.html#v0-29-3 | datasette 107914493 | |
24738954 | https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.2a | MDc6UmVsZWFzZTI0NzM4OTU0 | 0.2a | master | 0.2a | 0 | simonw 9599 | 0 | 2020-03-21T15:27:15Z | 2020-03-21T19:46:58Z | Compatibility with sqlite-utils 1.x | hacker-news-to-sqlite 248903544 | |
25832475 | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.2a | MDc6UmVsZWFzZTI1ODMyNDc1 | 0.2a | master | 0.2a | 0 | simonw 9599 | 0 | 2020-04-24T00:42:43Z | 2020-04-24T00:44:21Z | * Only upload photos not already in S3. #9 | dogsheep-photos 256834907 | |
18762495 | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/0.3 | MDc6UmVsZWFzZTE4NzYyNDk1 | 0.3 | master | 0.3 | 0 | simonw 9599 | 0 | 2019-07-22T03:31:54Z | 2019-07-22T03:33:32Z | - Tool now displays a progress bar during import - you can disable it with `--silent` #5 - You can pass a path to a decompressed XML file instead of a zip file, using `--xml` - Records table is now broken up into different tables for each type of recorded data #6 | healthkit-to-sqlite 197882382 | |
19763200 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.3 | MDc6UmVsZWFzZTE5NzYzMjAw | 0.3 | master | 0.3 | 0 | simonw 9599 | 0 | 2019-09-04T22:10:07Z | 2019-09-04T22:11:01Z | Extract places and media into separate tables Demo: https://twitter-to-sqlite-demo.now.sh/ | twitter-to-sqlite 206156866 | |
19993820 | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.3 | MDc6UmVsZWFzZTE5OTkzODIw | 0.3 | master | 0.3 | 0 | simonw 9599 | 0 | 2019-09-14T21:49:27Z | 2019-09-14T21:50:01Z | * `license` is now extracted from the `repos` table into a separate `licenses` table with a foreign key, #2 | github-to-sqlite 207052882 | |
24738963 | https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.3 | MDc6UmVsZWFzZTI0NzM4OTYz | 0.3 | master | 0.3 | 0 | simonw 9599 | 0 | 2020-03-21T19:46:08Z | 2020-03-21T19:47:36Z | First non-alpha release. Now configures full-text search for the `users` and `items` tables. #1 | hacker-news-to-sqlite 248903544 | |
24954042 | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.3 | MDc6UmVsZWFzZTI0OTU0MDQy | 0.3 | master | 0.3 | 0 | simonw 9599 | 0 | 2020-03-28T02:25:29Z | 2020-03-28T02:28:35Z | * Upgraded to sqlite-utils 2.x | swarm-to-sqlite 205429375 | |
30613603 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.3 | MDc6UmVsZWFzZTMwNjEzNjAz | 0.3 | main | 0.3 | 0 | simonw 9599 | 0 | 2020-09-02T21:07:13Z | 2020-09-02T21:07:44Z | - New `category` column plus default `categories` table. #7 | dogsheep-beta 197431109 | |
37946829 | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3 | MDc6UmVsZWFzZTM3OTQ2ODI5 | 0.3 | main | 0.3 | 0 | simonw 9599 | 0 | 2021-02-11T22:14:01Z | 2021-02-11T22:16:20Z | - Correctly handle entities in XHTML notes. [#9](https://github.com/dogsheep/evernote-to-sqlite/issues/9) - Fixed a bug importing ENEX files on Windows. Thanks, [dskrad](https://github.com/dskrad). [#11](https://github.com/dogsheep/evernote-to-sqlite/issues/11) | evernote-to-sqlite 303218369 | |
18823859 | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/0.3.1 | MDc6UmVsZWFzZTE4ODIzODU5 | 0.3.1 | master | 0.3.1 | 0 | simonw 9599 | 0 | 2019-07-24T06:33:22Z | 2019-07-24T06:38:36Z | Uses less RAM - see #7 | healthkit-to-sqlite 197882382 | |
24740687 | https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.3.1 | MDc6UmVsZWFzZTI0NzQwNjg3 | 0.3.1 | master | 0.3.1 | 0 | simonw 9599 | 0 | 2020-03-21T22:39:34Z | 2020-03-21T22:41:16Z | Added documentation on [Browsing your data with Datasette](https://github.com/dogsheep/hacker-news-to-sqlite/blob/0.3.1/README.md#browsing-your-data-with-datasette). | hacker-news-to-sqlite 248903544 | |
24954053 | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.3.1 | MDc6UmVsZWFzZTI0OTU0MDUz | 0.3.1 | master | 0.3.1 | 0 | simonw 9599 | 0 | 2020-03-28T02:29:41Z | 2020-03-28T02:30:10Z | * Fixed bug with very old checkins that were missing their source - thanks, @mfa! #6 | swarm-to-sqlite 205429375 | |
37947725 | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3.1 | MDc6UmVsZWFzZTM3OTQ3NzI1 | 0.3.1 | main | 0.3.1 | 0 | simonw 9599 | 0 | 2021-02-11T22:38:21Z | 2021-02-11T22:40:40Z | - Explicitly open file using utf-8 encoding - thanks, RiverZhou. [#10](https://github.com/dogsheep/evernote-to-sqlite/pull/10) - Fix import error if note has no "updated" element - thanks, Matej Korosec. [#8](https://github.com/dogsheep/evernote-to-sqlite/pull/8) | evernote-to-sqlite 303218369 | |
18881253 | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/0.3.2 | MDc6UmVsZWFzZTE4ODgxMjUz | 0.3.2 | master | 0.3.2 | 0 | simonw 9599 | 0 | 2019-07-26T06:02:30Z | 2019-07-26T06:12:12Z | Fix for #9 - Too many SQL variables bug | healthkit-to-sqlite 197882382 | |
32470830 | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.3.2 | MDc6UmVsZWFzZTMyNDcwODMw | 0.3.2 | main | 0.3.2 | 0 | simonw 9599 | 0 | 2020-10-12T20:31:24Z | 2020-10-12T20:33:48Z | - Fix for "table photos has no column named hasSticker" bug, thanks @mattiaborsoi. #10 - Switched CI to GitHub Actions. | swarm-to-sqlite 205429375 | |
48523966 | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3.2 | MDc6UmVsZWFzZTQ4NTIzOTY2 | 0.3.2 | main | 0.3.2 | 0 | simonw 9599 | 0 | 2021-08-26T19:01:49Z | 2021-08-26T19:02:47Z | - Fixed error when encountering `<en-note>` documents that were not well-formed XML. [#13](https://github.com/dogsheep/evernote-to-sqlite/issues/13) | evernote-to-sqlite 303218369 | |
36530359 | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.3.3 | MDc6UmVsZWFzZTM2NTMwMzU5 | 0.3.3 | main | 0.3.3 | 0 | simonw 9599 | 0 | 2021-01-18T04:34:56Z | 2021-01-18T04:36:03Z | - Fixed bug where tool could crash with an error about missing columns. #11 | swarm-to-sqlite 205429375 | |
98864081 | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.3.4 | RE_kwDODD6af84F5IvR | 0.3.4 | main | 0.3.4 | 0 | simonw 9599 | 0 | 2023-04-11T03:17:35Z | 2023-04-11T03:18:16Z | - Fixed an error in the `checkins_detail` view. [#15](https://github.com/dogsheep/swarm-to-sqlite/issues/15) | swarm-to-sqlite 205429375 | |
21098052 | https://github.com/simonw/datasette/releases/tag/0.30 | MDc6UmVsZWFzZTIxMDk4MDUy | 0.30 | master | 0.30 | 0 | simonw 9599 | 0 | 2019-10-19T01:08:04Z | 2019-10-30T18:51:30Z | https://datasette.readthedocs.io/en/stable/changelog.html#v0-30 | datasette 107914493 | |
21162064 | https://github.com/simonw/datasette/releases/tag/0.30.1 | MDc6UmVsZWFzZTIxMTYyMDY0 | 0.30.1 | master | 0.30.1 | 0 | simonw 9599 | 0 | 2019-10-30T19:00:21Z | 2019-11-02T00:06:02Z | https://datasette.readthedocs.io/en/stable/changelog.html#v0-30-1 | datasette 107914493 | |
21169835 | https://github.com/simonw/datasette/releases/tag/0.30.2 | MDc6UmVsZWFzZTIxMTY5ODM1 | 0.30.2 | master | 0.30.2 | 0 | simonw 9599 | 0 | 2019-11-02T23:12:46Z | 2019-11-02T23:33:13Z | https://datasette.readthedocs.io/en/latest/changelog.html#v0-30-2 | datasette 107914493 | |
21426299 | https://github.com/simonw/datasette/releases/tag/0.31.1 | MDc6UmVsZWFzZTIxNDI2Mjk5 | 0.31.1 | master | 0.31.1 | 0 | simonw 9599 | 0 | 2019-11-13T02:18:39Z | 2019-11-13T02:40:53Z | - Deployments created using `datasette publish` now use `python:3.8` base Docker image (#629) https://datasette.readthedocs.io/en/latest/changelog.html#v0-31-1 | datasette 107914493 | |
21449006 | https://github.com/simonw/datasette/releases/tag/0.31.2 | MDc6UmVsZWFzZTIxNDQ5MDA2 | 0.31.2 | master | 0.31.2 | 0 | simonw 9599 | 0 | 2019-11-13T16:48:36Z | 2019-11-13T17:38:59Z | - Fixed a bug where datasette publish heroku applications failed to start (#633) - Fix for datasette publish with just --source_url - thanks, Stanley Zheng (#572) - Deployments to Heroku now use Python 3.8.0 (#632) https://datasette.readthedocs.io/en/latest/changelog.html#v0-31-2 | datasette 107914493 | |
24330942 | https://github.com/simonw/datasette/releases/tag/0.38 | MDc6UmVsZWFzZTI0MzMwOTQy | 0.38 | master | 0.38 | 0 | simonw 9599 | 0 | 2020-03-08T23:26:50Z | 2020-03-08T23:42:36Z | * The [Docker build](https://hub.docker.com/r/datasetteproject/datasette) of Datasette now uses SQLite 3.31.1, upgraded from 3.26. (#695) * `datasette publish cloudrun` now accepts an optional `--memory=2Gi` flag for setting the Cloud Run allocated memory to a value other than the default (256Mi). (#694) * Fixed bug where templates that shipped with plugins were sometimes not being correctly loaded. (#697) | datasette 107914493 | |
24836140 | https://github.com/simonw/datasette/releases/tag/0.39 | MDc6UmVsZWFzZTI0ODM2MTQw | 0.39 | master | 0.39 | 0 | simonw 9599 | 0 | 2020-03-25T04:02:37Z | 2020-03-25T04:11:35Z | * New [base_url](https://datasette.readthedocs.io/en/latest/config.html#config-base-url) configuration setting for serving up the correct links while running Datasette under a different URL prefix. (#394) * New metadata settings `"sort"` and `"sort_desc"` for setting the default sort order for a table. See [Setting a default sort order](https://datasette.readthedocs.io/en/latest/metadata.html#metadata-default-sort). (#702) * Sort direction arrow now displays by default on the primary key. This means you only have to click once (not twice) to sort in reverse order. (#677) * New `await Request(scope, receive).post_vars()` method for accessing POST form variables. (#700) * Plugin hooks documentation now links to example uses of each plugin. (#709) | datasette 107914493 | |
26199348 | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.3a | MDc6UmVsZWFzZTI2MTk5MzQ4 | 0.3a | master | 0.3a | 0 | simonw 9599 | 0 | 2020-05-05T20:16:53Z | 2020-05-05T20:17:00Z | * Upload photos to S3 in a thread pool #11 * New `--dry-run` option to `upload` command * New `photos-to-sqlite apple-photos` command for importing Apple Photos metadata #1 * Apple Photos quality scores are imported into `apple_photos_scores` table #15 * Machine learning labels imported from Apple Photos into `labels` table #16 | dogsheep-photos 256834907 | |
19865891 | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.4 | MDc6UmVsZWFzZTE5ODY1ODkx | 0.4 | master | 0.4 | 0 | simonw 9599 | 0 | 2019-09-09T22:41:25Z | 2019-09-09T22:43:05Z | * New `users-lookup` command for fetching multiple user profiles, including using new `--sql` and `--attach` options * New `list-members` subcommand for fetching members of a list * Added `stop_after` option to `user-timeline` command | twitter-to-sqlite 206156866 | |
20031553 | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.4 | MDc6UmVsZWFzZTIwMDMxNTUz | 0.4 | master | 0.4 | 0 | simonw 9599 | 0 | 2019-09-17T00:18:37Z | 2019-09-17T00:19:42Z | * Added `github-to-sqlite repos` command, #3 | github-to-sqlite 207052882 | |
21306693 | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/0.4 | MDc6UmVsZWFzZTIxMzA2Njkz | 0.4 | master | 0.4 | 0 | simonw 9599 | 0 | 2019-11-08T01:19:23Z | 2019-11-08T01:19:51Z | * Fixed workout latitude/longitude points import for iOS 13 - #10 | healthkit-to-sqlite 197882382 | |
26698662 | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.4 | MDc6UmVsZWFzZTI2Njk4NjYy | 0.4 | master | 0.4 | 0 | simonw 9599 | 0 | 2020-05-20T04:22:26Z | 2020-05-20T04:24:28Z | - Renamed this project to `dogsheep-photos`. #26 - `apple-photos` command now works even if you haven't yet run `upload`. #19 - `--image-url-prefix` and `--image-url-suffix` options to `apple-photos`. #24 - New `create-subset` command. #23 | dogsheep-photos 256834907 | |
30688677 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.4 | MDc6UmVsZWFzZTMwNjg4Njc3 | 0.4 | main | 0.4 | 0 | simonw 9599 | 0 | 2020-09-03T21:09:50Z | 2020-09-03T21:11:28Z | - Working faceted search interface at `/-/beta` #3 - `is_public` column for filtering between public and private data. #11 - New `received` category. #10 | dogsheep-beta 197431109 | |
39765751 | https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.4 | MDc6UmVsZWFzZTM5NzY1NzUx | 0.4 | main | 0.4 | 0 | simonw 9599 | 0 | 2021-03-13T19:11:12Z | 2021-03-13T19:15:06Z | Progress display now shows the total as well as the number currently in the queue. ``` % hacker-news-to-sqlite trees hn.db 26440397 done: 1, in queue: 0, total: 1 done: 2, in queue: 28, total: 30 done: 3, in queue: 27, total: 30 ``` | hacker-news-to-sqlite 248903544 | |
26873698 | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.4.1 | MDc6UmVsZWFzZTI2ODczNjk4 | 0.4.1 | master | 0.4.1 | 0 | simonw 9599 | 0 | 2020-05-25T20:11:20Z | 2020-05-25T20:13:23Z | - Documentation now explains how to use this with the [datasette-media](https://github.com/simonw/datasette-media), [datasette-json-html](https://github.com/simonw/datasette-json-html) and [datasette-template-sql](https://github.com/simonw/datasette-template-sql) plugins. #20 | dogsheep-photos 256834907 | |
30690154 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.4.1 | MDc6UmVsZWFzZTMwNjkwMTU0 | 0.4.1 | main | 0.4.1 | 0 | simonw 9599 | 0 | 2020-09-03T21:40:40Z | 2020-09-03T21:41:52Z | - Fixed support for [advanced FTS query syntax](https://www.sqlite.org/fts5.html#full_text_query_syntax). #13 | dogsheep-beta 197431109 | |
25748264 | https://github.com/simonw/datasette/releases/tag/0.40 | MDc6UmVsZWFzZTI1NzQ4MjY0 | 0.40 | master | 0.40 | 0 | simonw 9599 | 0 | 2020-04-22T04:06:39Z | 2020-04-22T04:06:51Z | * Datasette [Metadata](https://datasette.readthedocs.io/en/latest/metadata.html) can now be provided as a YAML file as an optional alternative to JSON. See [Using YAML for metadata](https://datasette.readthedocs.io/en/latest/metadata.html#metadata-yaml). (#713) * Removed support for `datasette publish now`, which used the the now-retired Zeit Now v1 hosting platform. A new plugin, [datasette-publish-now](https://github.com/simonw/datasette-publish-now), can be installed to publish data to Zeit ([now Vercel](https://vercel.com/blog/zeit-is-now-vercel)) Now v2. (#710) * Fixed a bug where the `extra_template_vars(request, view_name)` plugin hook was not receiving the correct `view_name`. (#716) * Variables added to the template context by the `extra_template_vars()` plugin hook are now shown in the `?_context=1` debugging mode (see [template_debug](https://datasette.readthedocs.io/en/latest/config.html#config-template-debug)). (#693) * Fixed a bug where the “templates considered” HTML comment was no longer being displayed. (#689) * Fixed a `datasette publish` bug where `--plugin-secret` would over-ride plugin configuration in the provided `metadata.json` file. (#724) * Added a new CSS class for customizing the canned query page. (#727) | datasette 107914493 | |
26240662 | https://github.com/simonw/datasette/releases/tag/0.41 | MDc6UmVsZWFzZTI2MjQwNjYy | 0.41 | master | 0.41 | 0 | simonw 9599 | 0 | 2020-05-06T18:20:58Z | 2020-05-06T18:30:03Z | You can now create [custom pages](https://datasette.readthedocs.io/en/0.41/custom_templates.html#custom-pages) within your Datasette instance using a custom template file. For example, adding a template file called `templates/pages/about.html` will result in a new page being served at `/about` on your instance. See the [custom pages documentation](https://datasette.readthedocs.io/en/0.41/custom_templates.html#custom-pages) for full details, including how to return custom HTTP headers, redirects and status codes. (#648) [Configuration directory mode](https://datasette.readthedocs.io/en/0.41/config.html#config-dir) (#731) allows you to define a custom Datasette instance as a directory. So instead of running the following: $ datasette one.db two.db \ --metadata.json \ --template-dir=templates/ \ --plugins-dir=plugins \ --static css:css You can instead arrange your files in a single directory called `my-project` and run this: $ datasette my-project/ Also in this release: - New `NOT LIKE` table filter: `?colname__notlike=expression`. (#750) - Datasette now has a *pattern portfolio* at `/-/patterns` - e.g. <https://latest.datasette.io/-/patterns>. This is a page that shows every Datasette user interface component in one place, to aid core development and people building custom CSS themes. (#151) - SQLite [PRAGMA functions](https://www.sqlite.org/pragma.html#pragfunc) such as `pragma_table_info(tablename)` are now allowed in Datasette SQL queries. (#761) - Datasette pages now consistently return a `content-type` of `text/html; charset=utf-8"`. (#752) - Datasette now handles an ASGI `raw_path` value of `None`, which should allow compatibilty with the [Mangum](https://github.com/erm/mangum) adapter for running ASGI apps on AWS Lambda. Thanks, Colin Dellow. (#719) - Installation documentation now covers how to [Install using pipx](https://datasette.readthedocs.io/en/0.41/installation.html#installation-pipx). (#756) - Improved the documentation for [F… | datasette 107914493 | |
26320774 | https://github.com/simonw/datasette/releases/tag/0.42 | MDc6UmVsZWFzZTI2MzIwNzc0 | 0.42 | master | 0.42 | 0 | simonw 9599 | 0 | 2020-05-08T17:38:27Z | 2020-05-08T17:56:36Z | A small release which provides improved internal methods for use in plugins, along with documentation. See #685. * Added documentation for `db.execute()`, see [await db.execute(sql, ...)](https://datasette.readthedocs.io/en/stable/internals.html#database-execute). * Renamed `db.execute_against_connection_in_thread()` to `db.execute_fn()` and made it a documented method, see [await db.execute_fn(fn)](https://datasette.readthedocs.io/en/stable/internals.html#database-execute-fn). * New `results.first()` and `results.single_value()` methods, plus documentation for the `Results` class - see [Results](https://datasette.readthedocs.io/en/stable/internals.html#database-results). | datasette 107914493 | |
26994005 | https://github.com/simonw/datasette/releases/tag/0.43 | MDc6UmVsZWFzZTI2OTk0MDA1 | 0.43 | master | 0.43 | 0 | simonw 9599 | 0 | 2020-05-28T14:11:06Z | 2020-05-28T14:39:18Z | The main focus of this release is a major upgrade to the [register_output_renderer(datasette)](https://datasette.readthedocs.io/en/stable/plugins.html#plugin-register-output-renderer) plugin hook, which allows plugins to provide new output formats for Datasette such as [datasette-atom](https://github.com/simonw/datasette-atom) and [datasette-ics](https://github.com/simonw/datasette-ics). - Redesign of [register_output_renderer(datasette)](https://datasette.readthedocs.io/en/stable/plugins.html#plugin-register-output-renderer) to provide more context to the render callback and support an optional `"can_render"` callback that controls if a suggested link to the output format is provided. ([#581](https://github.com/simonw/datasette/issues/581), [#770](https://github.com/simonw/datasette/issues/770)) - Visually distinguish float and integer columns - useful for figuring out why order-by-column might be returning unexpected results. ([#729](https://github.com/simonw/datasette/issues/729)) - The [Request object](https://datasette.readthedocs.io/en/stable/internals.html#internals-request), which is passed to several plugin hooks, is now documented. ([#706](https://github.com/simonw/datasette/issues/706)) - New `metadata.json` option for setting a custom default page size for specific tables and views, see [Setting a custom page size](https://datasette.readthedocs.io/en/stable/metadata.html#metadata-page-size). ([#751](https://github.com/simonw/datasette/issues/751)) - Canned queries can now be configured with a default URL fragment hash, useful when working with plugins such as [datasette-vega](https://github.com/simonw/datasette-vega), see [Setting a default fragment](https://datasette.readthedocs.io/en/stable/sql_queries.html#canned-queries-default-fragment). ([#706](https://github.com/simonw/datasette/issues/706)) - Fixed a bug in `datasette publish` when running on operating systems where the `/tmp` directory lives in a different volume, using a backport of the Python 3.8 `shutil.copytree()` func… | datasette 107914493 | |
27483276 | https://github.com/simonw/datasette/releases/tag/0.44 | MDc6UmVsZWFzZTI3NDgzMjc2 | 0.44 | master | 0.44 | 0 | simonw 9599 | 0 | 2020-06-12T01:19:30Z | 2020-06-12T07:10:38Z | Authentication and permissions, writable canned queries, flash messages, new plugin hooks and more. [Full release notes](https://datasette.readthedocs.io/en/stable/changelog.html#v0-44). See also [Datasette 0.44: the annotated release notes](https://simonwillison.net/2020/Jun/12/annotated-release-notes/). | datasette 107914493 | |
28134124 | https://github.com/simonw/datasette/releases/tag/0.45 | MDc6UmVsZWFzZTI4MTM0MTI0 | 0.45 | master | 0.45 | 0 | simonw 9599 | 0 | 2020-07-01T21:43:07Z | 2020-07-01T21:46:07Z | Magic parameters for canned queries, a log out feature, improved plugin documentation and four new plugin hooks. ### Magic parameters for canned queries Canned queries now support [Magic parameters](https://docs.datasette.io/en/stable/sql_queries.html#canned-queries-magic-parameters), which can be used to insert or select automatically generated values. For example: ```sql insert into logs (user_id, timestamp) values (:_actor_id, :_now_datetime_utc) ``` This inserts the currently authenticated actor ID and the current datetime. ([#842](https://github.com/simonw/datasette/issues/842)) ### Log out The [ds_actor cookie](https://docs.datasette.io/en/stable/authentication.html#authentication-ds-actor) can be used by plugins (or by Datasette's [--root mechanism](https://docs.datasette.io/en/stable/authentication.html#authentication-root)) to authenticate users. The new `/-/logout` page provides a way to clear that cookie. A "Log out" button now shows in the global navigation provided the user is authenticated using the `ds_actor` cookie. ([#840](https://github.com/simonw/datasette/issues/840)) ### Better plugin documentation The plugin documentation has been re-arranged into four sections, including a brand new section on testing plugins. ([#687](https://github.com/simonw/datasette/issues/687)) - [Plugins](https://docs.datasette.io/en/stable/plugins.html#plugins) introduces Datasette's plugin system and describes how to install and configure plugins. - [Writing plugins](https://docs.datasette.io/en/stable/writing_plugins.html#writing-plugins) describes how to author plugins, from simple one-off plugins to packaged plugins that can be published to PyPI. It also describes how to start a plugin using the new [datasette-plugin](https://github.com/simonw/datasette-plugin) cookiecutter template. - [Plugin hooks](https://docs.datasette.io/en/stable/plugin_hooks.html#plugin-hooks) is a full list of detailed documentation for every Datasette plugin hook. - [Testing plugins](https://… | datasette 107914493 | |
27703093 | https://github.com/simonw/datasette/releases/tag/0.45a0 | MDc6UmVsZWFzZTI3NzAzMDkz | 0.45a0 | master | 0.45a0 | 0 | simonw 9599 | 1 | 2020-06-18T20:58:09Z | 2020-06-18T21:14:00Z | datasette 107914493 | ||
27707079 | https://github.com/simonw/datasette/releases/tag/0.45a1 | MDc6UmVsZWFzZTI3NzA3MDc5 | 0.45a1 | master | 0.45a1 | 0 | simonw 9599 | 1 | 2020-06-18T23:52:16Z | 2020-06-19T00:02:29Z | datasette 107914493 | ||
27856779 | https://github.com/simonw/datasette/releases/tag/0.45a2 | MDc6UmVsZWFzZTI3ODU2Nzc5 | 0.45a2 | master | 0.45a2 | 0 | simonw 9599 | 1 | 2020-06-24T04:17:30Z | 2020-06-24T04:32:12Z | datasette 107914493 | ||
27994774 | https://github.com/simonw/datasette/releases/tag/0.45a3 | MDc6UmVsZWFzZTI3OTk0Nzc0 | 0.45a3 | master | 0.45a3 | 0 | simonw 9599 | 1 | 2020-06-28T03:22:49Z | 2020-06-28T03:27:12Z | datasette 107914493 | ||
28008549 | https://github.com/simonw/datasette/releases/tag/0.45a4 | MDc6UmVsZWFzZTI4MDA4NTQ5 | 0.45a4 | master | 0.45a4 | 0 | simonw 9599 | 1 | 2020-06-29T02:31:16Z | 2020-06-29T02:33:02Z | datasette 107914493 | ||
28097766 | https://github.com/simonw/datasette/releases/tag/0.45a5 | MDc6UmVsZWFzZTI4MDk3NzY2 | 0.45a5 | master | 0.45a5 | 0 | simonw 9599 | 1 | 2020-07-01T04:25:35Z | 2020-07-01T04:27:08Z | datasette 107914493 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [releases] ( [html_url] TEXT, [id] INTEGER PRIMARY KEY, [node_id] TEXT, [tag_name] TEXT, [target_commitish] TEXT, [name] TEXT, [draft] INTEGER, [author] INTEGER REFERENCES [users]([id]), [prerelease] INTEGER, [created_at] TEXT, [published_at] TEXT, [body] TEXT, [repo] INTEGER REFERENCES [repos]([id]) , [reactions] TEXT); CREATE INDEX [idx_releases_repo] ON [releases] ([repo]); CREATE INDEX [idx_releases_author] ON [releases] ([author]);