turbot/github

steampipe plugin install githubsteampipe plugin install github
On This Page
Get Involved

Table: github_release

A release is a package of software, along with release notes and links to binary files, for other people to use.

The github_release table can be used to query information about any release, and you must specify which repository in the where or join clause using the repository_full_name column.

Examples

List releases

select
name,
published_at
from
github_release
where
repository_full_name = 'turbot/steampipe'
order by
published_at desc;

Download statistics per release

select
r.name as release_name,
r.published_at,
a ->> 'name' as asset_name,
a ->> 'download_count' as download_count
from
github_release as r,
jsonb_array_elements(assets) as a
where
r.repository_full_name = 'turbot/steampipe'
and a ->> 'content_type' in ('application/zip', 'application/gzip')
order by
r.published_at desc,
asset_name;

.inspect github_release

GitHub Releases bundle project files for download by users.

NameTypeDescription
assetsjsonbList of assets contained in the release.
assets_urltextAssets URL for the release.
author_logintextThe login name of the user that created the release.
bodytextText describing the contents of the tag.
created_attimestamp without time zoneTime when the release was created.
draftbooleanTrue if this is a draft (unpublished) release.
html_urltextHTML URL for the release.
idbigintUnique ID of the release.
nametextThe name of the release.
node_idtextNode where GitHub stores this data internally.
prereleasebooleanTrue if this is a prerelease version.
published_attimestamp without time zoneTime when the release was published.
repository_full_nametextFull name of the repository that contains the release.
tag_nametextThe name of the tag the release is associated with.
tarball_urltextTarball URL for the release.
target_commitishtextSpecifies the commitish value that determines where the Git tag is created from. Can be any branch or commit SHA.
upload_urltextUpload URL for the release.
urltextURL of the release.
zipball_urltextZipball URL for the release.