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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
about	text		The user's optional self-description. HTML.
created	text		Creation timestamp of the user.
id	text	=	The user's unique username. Case-sensitive. Required.
karma	bigint		The user's karma.
submitted	jsonb		List 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