recent_releases (view)

Table actions

1 row where "date" is on date 2020-12-16 and repo = "https://github.com/dogsheep/dogsheep-beta"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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 2020-12-16
  • Now depends on 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"
]

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;