Table: reddit_my_friend - Query Reddit Friends using SQL

Reddit is a social news aggregation, web content rating, and discussion website. Registered members submit content to the site such as links, text posts, and images, which are then voted up or down by other members. A unique feature of Reddit is the 'Friends' system, which allows users to follow and interact with other users on the platform.

Table Usage Guide

The reddit_my_friend table provides insights into the 'Friends' feature on Reddit. As a social media analyst, explore details about the users who are friends with the authenticated user through this table, including their username, ID, and the date you became friends. Utilize it to uncover information about your Reddit network, such as who your oldest friend is, or if there are any patterns in the users you befriend.

Examples

List all your friends

Explore your social connections by listing all your friends in alphabetical order, useful for quickly identifying a specific friend or reviewing your social network.

select
  name,
  date
from
  reddit_my_friend
order by
  name;

select
  name,
  date
from
  reddit_my_friend
order by
  name;

Schema for reddit_my_friend

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
date	text		Time when the relationship was created.
id	text		ID of the friend.
name	text		Name of the friend.
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_friend