turbot/hackernews
steampipe plugin install hackernews

Table: hackernews_show_hn - Query Hacker News 'Show HN' Posts using SQL

Hacker News is a social news website focusing on computer science and entrepreneurship. It is run by Paul Graham's investment fund and startup incubator, Y Combinator. In essence, it's a place where users submit and share content, with 'Show HN' being a specific category where users showcase new projects, products, or interesting initiatives.

Table Usage Guide

The hackernews_show_hn table provides insights into 'Show HN' posts on Hacker News. As a data analyst, explore post-specific details through this table, including post titles, URLs, points, and associated metadata. Utilize it to uncover information about posts, such as the most popular projects, trending topics, and user engagement metrics.

Examples

Show HN stories by score

Explore the popularity of Hacker News 'Show HN' stories by ranking them according to their score. This can help identify trending topics and influential discussions.

select
*
from
hackernews_show_hn
order by
score desc;
select
*
from
hackernews_show_hn
order by
score desc;

Show HN stories with most comments

Explore the most discussed 'Show HN' stories on HackerNews. This query is useful for identifying trending topics or popular discussions within the community.

select
*
from
hackernews_show_hn
order by
descendants desc;
select
*
from
hackernews_show_hn
order by
descendants desc;

Schema for hackernews_show_hn

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
bytextThe username of the item's author.
deadbooleanTrue if the item is dead.
deletedbooleanTrue if the item is deleted.
descendantsbigintIn the case of stories or polls, the total comment count.
idbigint=The item's unique id.
kidsjsonbThe ids of the item's comments, in ranked display order.
parentbigintThe comment's parent: either another comment or the relevant story.
partsjsonbA list of related pollopts, in display order.
pollbigintThe pollopt's associated poll.
scorebigintThe story's score, or the votes for a pollopt.
texttextThe comment, story or poll text. HTML.
timetimestamp with time zoneTimestamp when the item was created.
titletextThe title of the story, poll or job. HTML.
typetextThe type of item. One of "job", "story", "comment", "poll", or "pollopt".
urltextThe URL of the story.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- hackernews

You can pass the configuration to the command with the --config argument:

steampipe_export_hackernews --config '<your_config>' hackernews_show_hn