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: