recent_releases (view)
20 rows where rowid = 197431109 and topics = "["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"]"
This data as json, CSV (advanced)
Suggested facets: date, date (date), published_at (date), topics (array)
rowid | repo | release | date | body_markdown | published_at | topics |
---|---|---|---|---|---|---|
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.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 | 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.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"] |
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.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.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.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.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.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.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.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.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.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.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.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.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.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.1a | 2020-09-01 | - First working version | 2020-09-01T04:19:00Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
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;