Dashboard: Hacker News Jobs

This report answers the following questions:

How many jobs have been posted in the last 10 days?
Which roles and technologies have been mentioned in recent jobs?
What are the details of each job?

This dashboard contains 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 Jobs dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:

select
  to_char(time::timestamptz, 'YYYY-MM-DD') as day,
  count(*)
from
  hackernews_job
where
  time::timestamptz > now() - interval '10 day'
group by
  day
order by
  day;

Dashboard: Hacker News Jobs

Usage

Queries

Tags