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_userwhere id = 'pg';
select *from hackernews_userwhere 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