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, datefrom reddit_my_blockedorder by name;
select name, datefrom reddit_my_blockedorder 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, datefrom reddit_my_blockedorder by date desclimit 5;
select name, datefrom reddit_my_blockedorder by date desclimit 5;
Schema for reddit_my_blocked
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
date | text | Time when the block was created. | |
id | text | ID of the blocked user. | |
name | text | Name of the blocked user. | |
rel_id | text | ID 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