recent_releases (view)
344 rows sorted by release
This data as json, CSV (advanced)
Suggested facets: repo, topics, date (date), topics (array)
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
- …
rowid | repo | release ▼ | date | body_markdown | published_at | topics |
---|---|---|---|---|---|---|
611552758 | https://github.com/dogsheep/apple-notes-to-sqlite | https://github.com/dogsheep/apple-notes-to-sqlite/releases/tag/0.1 | 2023-03-09 | - 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) | 2023-03-09T05:12:12Z | ["apple-notes", "datasette", "datasette-tool", "dogsheep", "sqlite"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.1 | 2020-09-01 | - Optimize the FTS table and vacuum the database. #4 - First non-alpha release | 2020-09-01T06:12:05Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.10 | 2020-12-16 | - 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 | 2020-12-16T21:28:13Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.10.1 | 2020-12-19 | - Fix for error if search query contains hyphens such as `github-to-sqlite`. #31 | 2020-12-19T06:19:13Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.10.2 | 2021-06-13 | - Fixed bug where searches consisting only of whitespace caused a server error. [#33](https://github.com/dogsheep/dogsheep-beta/issues/33) | 2021-06-13T14:38:09Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.1a | 2020-09-01 | - First working version | 2020-09-01T04:19:00Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.1a2 | 2020-09-01 | - Now creates an index on the `timestamp` column. #1 | 2020-09-01T04:50:01Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.2 | 2020-09-01 | - Use Porter stemming by default, allow that to be over-ridden with the new `--tokenize=` option. #2 | 2020-09-01T20:41:31Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.3 | 2020-09-02 | - New `category` column plus default `categories` table. #7 | 2020-09-02T21:07:44Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.4 | 2020-09-03 | - Working faceted search interface at `/-/beta` #3 - `is_public` column for filtering between public and private data. #11 - New `received` category. #10 | 2020-09-03T21:11:28Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.4.1 | 2020-09-03 | - Fixed support for [advanced FTS query syntax](https://www.sqlite.org/fts5.html#full_text_query_syntax). #13 | 2020-09-03T21:41:52Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.4a0 | 2020-09-03 | - Incomplete preview of the `/-/beta` search interface. #3 #9 | 2020-09-03T03:54:23Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.4a1 | 2020-09-03 | - Added `received` category. #10 - New `is_public` column. #11 | 2020-09-03T18:03:50Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.5 | 2020-09-04 | - Custom template displays can now render a point on a map. #12 | 2020-09-04T01:46:16Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.6 | 2020-09-05 | - Rerun the search query with FTS quoting if a SQLite FTS error occurs. This means searching for e.g. "#dogfest" will no longer throw an error, while still supporting advanced SQLite FTS syntax. #14 - Maximum width 100% on images in results - Don't display facet headers if there are no results for that facet. | 2020-09-05T16:26:06Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.7 | 2020-09-17 | - Option to sort by relevance / oldest / newest. #21 - Renamed `table` column to `type`. #17 - New `-d` option for passing one or more databases to index. Without this all databases in the config file will be indexed. | 2020-09-17T22:57:09Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.7.1 | 2020-09-17 | - Fixed bug with sort orders displayed for the timeline view. #22 | 2020-09-17T23:13:46Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.7a0 | 2020-09-09 | - Renamed `table` column to `type`. #17 - New `-d` option for passing one or more databases to index. Without this all databases in the config file will be indexed. | 2020-09-09T00:46:06Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.8 | 2020-09-18 | - New `template_debug` configuration setting. #25 - Templates now autoescape by default, use `{{ display.foo|safe }}` if you know you want HTML not to be escaped. - Fixed bug where the wrong template fragment could be used for a row. #24 - Sort order is now persisted when you execute a new search. #23 | 2020-09-18T22:41:33Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.9 | 2020-10-17 | - Facet by date. #16 - Now depends on [Datasette 0.50.2](https://docs.datasette.io/en/stable/changelog.html#v0-50-2) - Uses `datasette.client` and passes through authentication cookies. #28 | 2020-10-17T23:03:04Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.9a0 | 2020-09-20 | - Added by date, as part of developing a timeline view. #16 | 2020-09-20T23:37:48Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
256834907 | https://github.com/dogsheep/dogsheep-photos | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.1a | 2020-04-24 | * First alpha release | 2020-04-24T00:40:57Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] |
256834907 | https://github.com/dogsheep/dogsheep-photos | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.2a | 2020-04-24 | * Only upload photos not already in S3. #9 | 2020-04-24T00:44:21Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] |
256834907 | https://github.com/dogsheep/dogsheep-photos | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.3a | 2020-05-05 | * 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 | 2020-05-05T20:17:00Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] |
256834907 | https://github.com/dogsheep/dogsheep-photos | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.4 | 2020-05-20 | - 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 | 2020-05-20T04:24:28Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] |
256834907 | https://github.com/dogsheep/dogsheep-photos | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.4.1 | 2020-05-25 | - 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 | 2020-05-25T20:13:23Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] |
303218369 | https://github.com/dogsheep/evernote-to-sqlite | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.1 | 2020-10-11 | - Initial release, with support for importing ENEX files. | 2020-10-11T21:47:39Z | ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] |
303218369 | https://github.com/dogsheep/evernote-to-sqlite | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.2 | 2020-10-12 | - 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 | 2020-10-12T00:07:24Z | ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] |
303218369 | https://github.com/dogsheep/evernote-to-sqlite | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3 | 2021-02-11 | - 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) | 2021-02-11T22:16:20Z | ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] |
303218369 | https://github.com/dogsheep/evernote-to-sqlite | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3.1 | 2021-02-11 | - 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) | 2021-02-11T22:40:40Z | ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] |
303218369 | https://github.com/dogsheep/evernote-to-sqlite | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3.2 | 2021-08-26 | - Fixed error when encountering `<en-note>` documents that were not well-formed XML. [#13](https://github.com/dogsheep/evernote-to-sqlite/issues/13) | 2021-08-26T19:02:47Z | ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] |
209590345 | https://github.com/dogsheep/genome-to-sqlite | https://github.com/dogsheep/genome-to-sqlite/releases/tag/0.1 | 2019-09-19 | First release | 2019-09-19T15:41:17Z | ["23andme", "datasette", "datasette-io", "datasette-tool", "dogsheep", "genetics", "personal-analytics", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.1.1 | 2019-09-14 | * Fix bug in authentication handling code | 2019-09-14T19:42:08Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.2 | 2019-09-14 | * Added the `github-to-sqlite starred` command for retrieving starred repos, #1 | 2019-09-14T21:32:34Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.3 | 2019-09-14 | * `license` is now extracted from the `repos` table into a separate `licenses` table with a foreign key, #2 | 2019-09-14T21:50:01Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.4 | 2019-09-17 | * Added `github-to-sqlite repos` command, #3 | 2019-09-17T00:19:42Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.5 | 2019-10-13 | * New command: `github-to-sqlite issue-comments` for importing comments on issues - #7 * `github-to-sqlite issues` now accepts optional `--issue=1` argument * Fixed bug inserting users into already-created table with wrong columns - #6 | 2019-10-13T05:30:05Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.6 | 2019-11-11 | - New `releases` command for fetching releases for a repo, #11 - Repository topics are now fetched by the `repos` command - `github-to-sqlite repos` now accepts multiple usernames - Command now works without `--auth` file (using anonymous API calls), #9 | 2019-11-11T05:34:06Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.7 | 2020-03-11 | * New `github-to-sqlite commits my.db dogsheep/github-to-sqlite` command. #17 | 2020-03-11T02:48:32Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/1.0 | 2020-03-24 | * Full-text search is configured for more tables. #19 * Release assets are now pulled out into a separate `assets` table. #15 * Now depends on sqlite-utils 2.x. #20 * Commit raw authors are now used to populate a new `raw_authors` able. #18 * New live demo at https://github-to-sqlite.dogsheep.net/ #13 * GitHub API errors are now raised as Pyton exceptions. #21 * Fixed bug running `commits` against repos with no commits. #22 | 2020-03-24T00:11:51Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/1.0.1 | 2020-04-16 | * Fixed bug where repository topics were not being correctly fetched #26 * Live demo at https://github-to-sqlite.dogsheep.net/ now uses [datasette-render-markdown](https://github.com/simonw/datasette-render-markdown) and pulls in issue comments #25 | 2020-04-16T18:09:29Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/1.1 | 2020-04-18 | * New `github-to-sqlite contributors` command for fetching contributors to one or more repositories. #28 * The [live demo](https://github-to-sqlite.dogsheep.net/) now includes contributors, and pulls data from `simonw/datasette` and `simonw/sqlite-utils` in addition to the Dogsheep repositories. * The `organization` column in the `repos` table is now a foreign key to `users` as opposed to a big piece of JSON. #27 | 2020-04-18T15:09:55Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.0 | 2020-04-22 | This release includes some backwards-incompatible schema changes: * The `milestone` and `assignee` columns on the `issues` table are now integers that are foreign keys to the `milestones` and `users` tables - previously they could be `text` columns instead. #30 * `milestones` now has an integer foreign key in the `creator` column, and a new `repo` column that is an integer foreign key to the `repos` table. #29 * The `repo` column in the `issues` table is now an integer foreign key to `repos`. Previously it was a string of the format `dogsheep/github-to-sqlite`. #31 | 2020-04-22T01:24:37Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.1 | 2020-04-30 | * New `github-to-sqlite scrape-dependents` command for importing the dependent repositories for a repo. #34 | 2020-04-30T23:03:32Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.2 | 2020-05-02 | * New command: `github-to-sqlite stargazers` ([docs](https://github.com/dogsheep/github-to-sqlite/blob/2.2/README.md#fetching-users-that-have-starred-specific-repos)) for fetching all users who have starred the specified repositories. #4 * Added several views: [dependent_repos](https://github-to-sqlite.dogsheep.net/github/dependent_repos), [repos_starred](https://github-to-sqlite.dogsheep.net/github/repos_starred), [recent_releases](https://github-to-sqlite.dogsheep.net/github/recent_releases). #10 #12 #36 * Added indexes on all foreign key relationships. #35 * GitHub API token can now be read from `GITHUB_TOKEN` environment variable. #33 | 2020-05-02T21:28:00Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.3 | 2020-07-09 | - New `github-to-sqlite repos my.db -r simonw/datasette` option for importing just specific repositories. #42 | 2020-07-09T23:28:07Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.4 | 2020-07-18 | - New `github-to-sqlite tags github.db simonw/datasette` command for importing all tags for a repository. #43 | 2020-07-18T22:35:27Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.5 | 2020-08-18 | - New `github-to-sqlite emojis` command for fetching emoji supported by GitHub. [Demo](https://github-to-sqlite.dogsheep.net/github/emojis). #47 - Added table of contents to README. - Switched to GitHub Actions for CI. - Switched default branch to `main` | 2020-08-18T15:08:20Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.6 | 2020-09-17 | - New `github-to-sqlite get /gists` command for making authenticated API calls against any API path. #50 | 2020-09-17T03:55:03Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.7 | 2020-10-19 | - `github-to-sqlite repos` command now takes options `--readme` and `--readme-html`, which write the README or rendered HTML README into the `readme` or `readme_html` columns, respectively. #52 - New `--accept` option for `github-to-sqlite get`. #50 | 2020-10-19T05:38:34Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.8 | 2020-11-30 | - New command: `github-to-sqlite workflows`, for fetching the YAML configuration used by [GitHub Actions](https://github.com/features/actions) workflows and using it to populate new `workflows`, `jobs` and `steps` tables. #54 - New command: `github-to-sqlite pull-requests` - thanks, @adamjonas! #48 - `github-to-sqlite issues --issue` option can now be used multiple times. | 2020-11-30T01:41:38Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.8.1 | 2020-11-30 | - README now links to example database tables for each command. #56 - Added documentation for `github-to-sqlite releases`. | 2020-11-30T04:18:21Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.8.2 | 2020-12-16 | - `--readme` now stores `null` if the README file does not exist, rather than throwing an error. #57 - README HTML is rewritten to fix broken internal links, e.g. for a table of contents. #58 | 2020-12-16T19:21:58Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
207052882 | https://github.com/dogsheep/github-to-sqlite | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.8.3 | 2021-12-01 | - Minor documentation and inline help improvements. | 2021-12-01T19:37:19Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] |
248903544 | https://github.com/dogsheep/hacker-news-to-sqlite | https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.1a | 2020-03-21 | * `user` and `trees` commands. | 2020-03-21T04:26:28Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "hacker-news"] |
248903544 | https://github.com/dogsheep/hacker-news-to-sqlite | https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.2a | 2020-03-21 | Compatibility with sqlite-utils 1.x | 2020-03-21T19:46:58Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "hacker-news"] |
248903544 | https://github.com/dogsheep/hacker-news-to-sqlite | https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.3 | 2020-03-21 | First non-alpha release. Now configures full-text search for the `users` and `items` tables. #1 | 2020-03-21T19:47:36Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "hacker-news"] |
248903544 | https://github.com/dogsheep/hacker-news-to-sqlite | https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.3.1 | 2020-03-21 | 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). | 2020-03-21T22:41:16Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "hacker-news"] |
248903544 | https://github.com/dogsheep/hacker-news-to-sqlite | https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.4 | 2021-03-13 | 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 ``` | 2021-03-13T19:15:06Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "hacker-news"] |
197882382 | https://github.com/dogsheep/healthkit-to-sqlite | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/0.1 | 2019-07-20 | 2019-07-20T16:43:09Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] | |
197882382 | https://github.com/dogsheep/healthkit-to-sqlite | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/0.2 | 2019-07-20 | Fixed a bug where duplicate records could crash the import. | 2019-07-20T16:44:41Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] |
197882382 | https://github.com/dogsheep/healthkit-to-sqlite | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/0.3 | 2019-07-22 | - 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 | 2019-07-22T03:33:32Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] |
197882382 | https://github.com/dogsheep/healthkit-to-sqlite | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/0.3.1 | 2019-07-24 | Uses less RAM - see #7 | 2019-07-24T06:38:36Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] |
197882382 | https://github.com/dogsheep/healthkit-to-sqlite | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/0.3.2 | 2019-07-26 | Fix for #9 - Too many SQL variables bug | 2019-07-26T06:12:12Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] |
197882382 | https://github.com/dogsheep/healthkit-to-sqlite | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/0.4 | 2019-11-08 | * Fixed workout latitude/longitude points import for iOS 13 - #10 | 2019-11-08T01:19:51Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] |
197882382 | https://github.com/dogsheep/healthkit-to-sqlite | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/0.5 | 2020-03-28 | * Upgraded to latest sqlite-utils | 2020-03-28T01:55:19Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] |
197882382 | https://github.com/dogsheep/healthkit-to-sqlite | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/1.0 | 2020-10-17 | - Fixed a bug where export files generated in languages other than English failed to import. #11 - CI now uses GitHub Actions | 2020-10-17T21:17:34Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] |
197882382 | https://github.com/dogsheep/healthkit-to-sqlite | https://github.com/dogsheep/healthkit-to-sqlite/releases/tag/1.0.1 | 2021-08-20 | - Fixed bug where `activity_summary` table could fail to be built with an error. [#19](https://github.com/dogsheep/healthkit-to-sqlite/issues/19) | 2021-08-20T00:56:17Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] |
206202864 | https://github.com/dogsheep/inaturalist-to-sqlite | https://github.com/dogsheep/inaturalist-to-sqlite/releases/tag/0.2 | 2020-03-24 | * Upgraded to `sqlite-utils` 2.x * First non-alpha release | 2020-03-24T00:36:40Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "inaturalist", "sqlite"] |
206202864 | https://github.com/dogsheep/inaturalist-to-sqlite | https://github.com/dogsheep/inaturalist-to-sqlite/releases/tag/0.2.1 | 2020-10-22 | - Tweaked dependencies for compatibility with new PyPI resolver. | 2020-10-22T00:08:58Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "inaturalist", "sqlite"] |
213286752 | https://github.com/dogsheep/pocket-to-sqlite | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.1 | 2019-10-07 | Initial release | 2019-10-07T05:18:20Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] |
213286752 | https://github.com/dogsheep/pocket-to-sqlite | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2 | 2020-03-27 | * 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 | 2020-03-27T22:26:30Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] |
213286752 | https://github.com/dogsheep/pocket-to-sqlite | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.1 | 2020-10-22 | - Tweaked dependencies for compatibility with new PyPI resolver. | 2020-10-22T00:08:24Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] |
213286752 | https://github.com/dogsheep/pocket-to-sqlite | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.2 | 2022-08-22 | - `-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) | 2022-08-22T16:21:34Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] |
213286752 | https://github.com/dogsheep/pocket-to-sqlite | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.3 | 2023-07-09 | - 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) | 2023-07-09T01:15:03Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] |
205429375 | https://github.com/dogsheep/swarm-to-sqlite | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.1 | 2019-08-31 | First usable release. | 2019-08-31T02:58:32Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] |
205429375 | https://github.com/dogsheep/swarm-to-sqlite | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.2 | 2019-10-16 | * Added --since option, closes #3 | 2019-10-16T20:40:55Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] |
205429375 | https://github.com/dogsheep/swarm-to-sqlite | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.3 | 2020-03-28 | * Upgraded to sqlite-utils 2.x | 2020-03-28T02:28:35Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] |
205429375 | https://github.com/dogsheep/swarm-to-sqlite | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.3.1 | 2020-03-28 | * Fixed bug with very old checkins that were missing their source - thanks, @mfa! #6 | 2020-03-28T02:30:10Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] |
205429375 | https://github.com/dogsheep/swarm-to-sqlite | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.3.2 | 2020-10-12 | - Fix for "table photos has no column named hasSticker" bug, thanks @mattiaborsoi. #10 - Switched CI to GitHub Actions. | 2020-10-12T20:33:48Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] |
205429375 | https://github.com/dogsheep/swarm-to-sqlite | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.3.3 | 2021-01-18 | - Fixed bug where tool could crash with an error about missing columns. #11 | 2021-01-18T04:36:03Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] |
205429375 | https://github.com/dogsheep/swarm-to-sqlite | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.3.4 | 2023-04-11 | - Fixed an error in the `checkins_detail` view. [#15](https://github.com/dogsheep/swarm-to-sqlite/issues/15) | 2023-04-11T03:18:16Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.10 | 2019-10-15 | * favorites command now populates `favorited_by` table - #14 * favorites `--stop_after` option - #20 * Store unescaped `full_text` of Tweet - #21 | 2019-10-15T18:56:09Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.11 | 2019-10-16 | * 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 | 2019-10-16T19:38:42Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.11.1 | 2019-10-16 | * Fix bugs running `home-timeline --since` from scratch. If tables were missing, script would throw an error. | 2019-10-16T22:31:51Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.12 | 2019-10-17 | * 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 | 2019-10-17T18:00:28Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.13 | 2019-10-30 | - New `mentions-timeline` command (#26) | 2019-10-30T02:22:30Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.14 | 2019-11-04 | * `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. | 2019-11-04T05:33:56Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.15 | 2019-11-09 | - Import command no longer fails on empty files - #29 - Fixed bug in `followers` command - #30 - `following` table now has indexes - #28 | 2019-11-09T20:13:07Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.16 | 2020-02-07 | New `friends` command for importing accounts that a specific user follows. | 2020-02-07T07:44:53Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.17 | 2020-03-20 | * Upgraded to latest `sqlite-utils` (currently 2.4.2) * This fixed a bug with `user-timeline` - #34 | 2020-03-20T19:23:40Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.18 | 2020-03-20 | * `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 | 2020-03-20T20:19:42Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.19 | 2020-03-20 | * 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 | 2020-03-20T23:16:53Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.1a | 2019-09-04 | 2019-09-04T22:08:18Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] | |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.2 | 2019-09-04 | Full text search for tweets table | 2019-09-04T22:09:46Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.20 | 2020-04-01 | * 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 | 2020-04-01T04:18:53Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.20.1 | 2020-04-01 | * Buf fix: `since_id` table no longer records a record for `None`, `None`. #41 | 2020-04-01T04:33:35Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.21 | 2020-04-17 | * 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 | 2020-04-17T23:46:51Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.21.1 | 2020-04-30 | * Fixed bug that occurred when the `since_ids` table had not yet been created. #46 | 2020-04-30T18:21:46Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.21.2 | 2020-07-18 | - Added changelog badge | 2020-07-18T22:43:20Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW recent_releases AS select repos.rowid as rowid, repos.html_url as repo, releases.html_url as release, substr(releases.published_at, 0, 11) as date, releases.body as body_markdown, releases.published_at, coalesce(repos.topics, '[]') as topics from releases join repos on repos.id = releases.repo order by releases.published_at desc;