Table: hackernews_ask_hn - Query Hacker News Ask 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 particular, the Ask HN section of the site allows users to ask the Hacker News community questions.

Table Usage Guide

The hackernews_ask_hn table provides insights into Ask HN posts on Hacker News. As a data analyst, explore post-specific details through this table, including author, score, and number of comments. Utilize it to uncover information about the most popular posts, the most active authors, and the discussions that generate the most comments.

Examples

Ask HN stories by score

Explore the most popular Ask HN stories on Hackernews, organized by their popularity score. This allows you to quickly identify and engage with the most impactful discussions.

select
  *
from
  hackernews_ask_hn
order by
  score desc;

select
  *
from
  hackernews_ask_hn
order by
  score desc;

Ask HN stories with most comments

Discover the Ask HN stories that have garnered the most engagement, allowing you to focus on popular topics and trends within the HackerNews community. This could be particularly useful for content creators, marketers, or researchers looking for highly interactive themes.

select
  *
from
  hackernews_ask_hn
order by
  descendants desc;

select
  *
from
  hackernews_ask_hn
order by
  descendants desc;

Query examples

Schema for hackernews_ask_hn

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
by	text		The username of the item's author.
dead	boolean		True if the item is dead.
deleted	boolean		True if the item is deleted.
descendants	bigint		In the case of stories or polls, the total comment count.
id	bigint	=	The item's unique id.
kids	jsonb		The ids of the item's comments, in ranked display order.
parent	bigint		The comment's parent: either another comment or the relevant story.
parts	jsonb		A list of related pollopts, in display order.
poll	bigint		The pollopt's associated poll.
score	bigint		The story's score, or the votes for a pollopt.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
text	text		The comment, story or poll text. HTML.
time	timestamp with time zone		Timestamp when the item was created.
title	text		The title of the story, poll or job. HTML.
type	text		The type of item. One of "job", "story", "comment", "poll", or "pollopt".
url	text		The 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_ask_hn