Table: reddit_my_saved_post - Query Reddit Saved Posts using SQL

Reddit is a social media platform that allows users to discuss and vote on content shared by other users. Users can save posts for later reference; these saved posts can be from any subreddit and include various details such as the post's title, author, subreddit, and more. This functionality is part of the overall user interaction with the platform, contributing to the personalized user experience.

Table Usage Guide

The reddit_my_saved_post table provides insights into a user's saved posts within Reddit. As a data analyst, explore post-specific details through this table, including title, author, subreddit, and associated metadata. Utilize it to uncover information about saved posts, such as those from specific subreddits, posts by certain authors, and the nature of the content saved by the user. The schema presents a range of attributes of the saved post for your analysis, like the post ID, title, author, subreddit, and more.

Examples

List five most recent posts

Explore the most recent activities on your Reddit account by identifying the five latest saved posts. This can help you keep track of your recent interactions and interests.

select
  created_utc,
  title,
  url
from
  reddit_my_saved_post
order by
  created_utc desc
limit
  5;

select
  created_utc,
  title,
  url
from
  reddit_my_saved_post
order by
  created_utc desc
limit
  5;

List top five posts by score

Gain insights into the most popular posts based on their score. This query helps you identify the top five posts, offering a quick overview of the most engaging content.

select
  score,
  upvote_ratio,
  title,
  url
from
  reddit_my_saved_post
order by
  score desc
limit
  5;

select
  score,
  upvote_ratio,
  title,
  url
from
  reddit_my_saved_post
order by
  score desc
limit
  5;

List posts by subreddit

Discover the segments that garner the most engagement on your saved Reddit posts. This allows you to focus your attention on the most active subreddits, thus optimizing your Reddit usage.

select
  subreddit_name_prefixed,
  count(*)
from
  reddit_my_saved_post
group by
  subreddit_name_prefixed
order by
  count desc;

select
  subreddit_name_prefixed,
  count(*)
from
  reddit_my_saved_post
group by
  subreddit_name_prefixed
order by
  count(*) desc;

List posts that contain the word "docs"

Discover the segments that include references to "docs" in your saved posts on Reddit. This can help you quickly locate posts that mention documentation or similar topics.

select
  created_utc,
  title,
  url,
  selftext
from
  reddit_my_saved_post
where
  selftext ilike '%docs%'
order by
  created_utc;

select
  created_utc,
  title,
  url,
  selftext
from
  reddit_my_saved_post
where
  selftext like '%docs%'
order by
  created_utc;

Schema for reddit_my_saved_post

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
author	text	Author of the post.
author_id	text	Full name of the author for the post.
body	text	Body of the post.
created	timestamp with time zone	Time when the post was created.
edited	timestamp with time zone	Time when the post was edited.
full_id	text	Slug (full ID) of the post.
id	text	ID of the post.
is_self_post	boolean
likes	boolean	True if you've upvoted the post. False if you've downvoted it. Otherwise null.
locked	boolean	True if the post is locked.
nsfw	boolean	True if the post is not safe for work (over 18).
number_of_comments	bigint	Number of comments on the post.
permalink	text	Permalink (path only) to the post.
rank	bigint	Rank of the post among the result rows, use for sorting.
saved	boolean	True if the post has been saved.
score	bigint	Score of the post.
spoiler	boolean	True if the post is a spoiler.
stickied	boolean	True if the post has been stickied.
subreddit_id	text	ID of the subreddit.
subreddit_name	text	Name of the subreddit, e.g. aws.
subreddit_name_prefixed	text	Prefixed name of the subreddit, e.g. /r/aws.
subreddit_subscribers	bigint	Number of subscribers to the subreddit.
title	text	Title of the post.
upvote_ratio	double precision	Upvote ratio of the post.
url	text	URL the post links to, or of the post itself.

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_saved_post