releases
20 rows where repo = 197431109
This data as json, CSV (advanced)
Suggested facets: prerelease, created_at (date), published_at (date)
| id ▼ | html_url | node_id | tag_name | target_commitish | name | draft | author | prerelease | created_at | published_at | body | repo | reactions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 30632372 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.4a0 | MDc6UmVsZWFzZTMwNjMyMzcy | 0.4a0 | main | 0.4a0 | 0 | simonw 9599 | 1 | 2020-09-03T03:53:29Z | 2020-09-03T03:54:23Z | - Incomplete preview of the `/-/beta` search interface. #3 #9 | dogsheep-beta 197431109 | |
| 30678449 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.4a1 | MDc6UmVsZWFzZTMwNjc4NDQ5 | 0.4a1 | main | 0.4a1 | 0 | simonw 9599 | 1 | 2020-09-03T18:03:15Z | 2020-09-03T18:03:50Z | - Added `received` category. #10 - New `is_public` column. #11 | dogsheep-beta 197431109 | |
| 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 | |
| 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 | |
| 30699190 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.5 | MDc6UmVsZWFzZTMwNjk5MTkw | 0.5 | main | 0.5 | 0 | simonw 9599 | 0 | 2020-09-04T01:45:35Z | 2020-09-04T01:46:16Z | - Custom template displays can now render a point on a map. #12 | dogsheep-beta 197431109 | |
| 30780951 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.6 | MDc6UmVsZWFzZTMwNzgwOTUx | 0.6 | main | 0.6 | 0 | simonw 9599 | 0 | 2020-09-05T16:24:11Z | 2020-09-05T16:26:06Z | - 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. | dogsheep-beta 197431109 | |
| 30944731 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.7a0 | MDc6UmVsZWFzZTMwOTQ0NzMx | 0.7a0 | main | 0.7a0 | 0 | simonw 9599 | 1 | 2020-09-09T00:45:07Z | 2020-09-09T00:46:06Z | - 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. | dogsheep-beta 197431109 | |
| 31501128 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.7 | MDc6UmVsZWFzZTMxNTAxMTI4 | 0.7 | main | 0.7 | 0 | simonw 9599 | 0 | 2020-09-17T22:56:01Z | 2020-09-17T22:57:09Z | - 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. | dogsheep-beta 197431109 | |
| 31501584 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.7.1 | MDc6UmVsZWFzZTMxNTAxNTg0 | 0.7.1 | main | 0.7.1 | 0 | simonw 9599 | 0 | 2020-09-17T23:13:01Z | 2020-09-17T23:13:46Z | - Fixed bug with sort orders displayed for the timeline view. #22 | dogsheep-beta 197431109 | |
| 31547860 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.8 | MDc6UmVsZWFzZTMxNTQ3ODYw | 0.8 | main | 0.8 | 0 | simonw 9599 | 0 | 2020-09-18T22:40:02Z | 2020-09-18T22:41:33Z | - 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 | dogsheep-beta 197431109 | |
| 31582397 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.9a0 | MDc6UmVsZWFzZTMxNTgyMzk3 | 0.9a0 | main | 0.9a0 | 0 | simonw 9599 | 1 | 2020-09-20T23:37:09Z | 2020-09-20T23:37:48Z | - Added by date, as part of developing a timeline view. #16 | dogsheep-beta 197431109 | |
| 32713381 | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.9 | MDc6UmVsZWFzZTMyNzEzMzgx | 0.9 | main | 0.9 | 0 | simonw 9599 | 0 | 2020-10-17T23:01:38Z | 2020-10-17T23:03:04Z | - 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 | dogsheep-beta 197431109 | |
| 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 |
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]);