Dashboard: Hacker News Stories

This report answers the following questions:

What are the max and average scores and comments for recent stories?
What are the details of each story?

This dashboard contains 4 cards, 1 input and 1 table.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-hackernews-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select Hacker News Stories dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run hackernews_insights.dashboard.hackernews_stories --share

Queries

This dashboard uses the the following queries:

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
  round(avg(score), 1) as "Avg Score" from hackernews_new

{
  "$1": "story_type"
}

Dashboard: Hacker News Stories

Usage

Queries

Tags