turbot/hackernews
steampipe plugin install hackernews

Table: hackernews_user - Query Hacker News Users using SQL

Hacker News is a social news website focusing on computer science and entrepreneurship. It is run by Y Combinator, an American seed money startup accelerator. Users can submit content, comment on other's posts, and earn karma points as a measure of their contributions to the community.

Table Usage Guide

The hackernews_user table provides insights into users' activities on Hacker News. As a data analyst, explore user-specific details through this table, including their creation time, karma points, and submitted posts. Utilize it to uncover information about users, such as their engagement level, contribution to the platform, and the evolution of their karma points over time.

Examples

Get information about a user

Explore the details of a specific user in the HackerNews platform. This can be useful in understanding user behavior or for user profile management.

select
*
from
hackernews_user
where
id = 'pg';
select
*
from
hackernews_user
where
id = 'pg';

Schema for hackernews_user

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
abouttextThe user's optional self-description. HTML.
createdtextCreation timestamp of the user.
idtext=The user's unique username. Case-sensitive. Required.
karmabigintThe user's karma.
submittedjsonbList of the user's stories, polls and comments.

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_user