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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
username	text	=, !=, ~~, ~~, !~~, !~~	The authorized username.

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