turbot/hackernews_insights

Query: hackernews_sources_detail

Usage

powerpipe query hackernews_insights.query.hackernews_sources_detail

SQL

with stories as (
select * from hackernews_new where $1 = 'New'
union
select * from hackernews_top where $1 = 'Top'
union
select * from hackernews_best where $1 = 'Best'
)
select
h.id as "ID",
h.by as "By",
to_char(h.time::timestamptz, 'YYYY-MM-DD HH24:MI:SS') as "Time",
h.score as "Score",
h.descendants as "Comments",
h.title as "Title",
h.url as "URL"
from
stories h
where
h.url ~ $2
order by
h.score desc

Params

ArgsNameDefaultDescriptionVariable
$1story_type
    $2domain

      Dashboards

      The query is used in the dashboards: