steampipe plugin install reddit

Table: reddit_my_blocked - Query Reddit Blocked Users using SQL

Reddit Blocked Users is a feature within Reddit that allows users to block other users to prevent them from interacting with them on the platform. It provides a way to manage and maintain a list of users that the authenticated user does not want to interact with. Reddit Blocked Users helps to enhance the user experience by allowing users to control who can interact with them.

Table Usage Guide

The reddit_my_blocked table provides insights into blocked users within Reddit. As a Reddit user, explore the list of blocked users through this table, including their usernames, the reasons for blocking, and the time they were blocked. Utilize it to manage and maintain your interactions on the platform, ensuring a more controlled and personalized Reddit experience.

Examples

List all users you have blocked

Discover the individuals you have chosen to block on Reddit and the dates these actions took place, allowing you to recall and manage your personal online interactions. This can be beneficial in maintaining a positive and controlled social media environment.

select
name,
date
from
reddit_my_blocked
order by
name;
select
name,
date
from
reddit_my_blocked
order by
name;

Last 5 users you blocked

Explore the most recent activities in your Reddit account by identifying the last five users you've blocked. This helps maintain a record of your interactions and monitor any recurring issues with specific users.

select
name,
date
from
reddit_my_blocked
order by
date desc
limit
5;
select
name,
date
from
reddit_my_blocked
order by
date desc
limit
5;

Schema for reddit_my_blocked

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
datetextTime when the block was created.
idtextID of the blocked user.
nametextName of the blocked user.
rel_idtextID of the relationship.

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)" -- reddit

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

steampipe_export_reddit --config '<your_config>' reddit_my_blocked