Table: reddit_my_post - Query Reddit Posts using SQL

Reddit is a network of communities based on people's interests. It allows users to post content, including text posts, links, and images, which are then voted up or down by other members. Posts are organized by subject into user-created boards called "subreddits", which cover a variety of topics like news, science, movies, video games, music, books, fitness, food, and image-sharing.

Table Usage Guide

The reddit_my_post table provides insights into a user's posts on Reddit. As a data analyst or social media manager, explore post-specific details through this table, including post title, content, subreddit, upvotes, and more. Utilize it to uncover information about user's post activity, engagement, and the popularity of posts across different subreddits.

Examples

5 most recent posts

Discover the latest updates or additions to your Reddit posts. This query can be used to keep track of your most recent posts, helping you to maintain an active and timely presence on the platform.

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

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

Posts by subreddit

Explore which subreddits you are most active in by counting the number of posts you have made in each. This can help you understand your Reddit usage patterns and areas of interest.

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

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

Posts containing the word "docs"

Discover the segments that include the word 'docs' within your Reddit posts. This can help you analyze the frequency and context of discussions about documentation, providing insights into user engagement and potential areas of improvement.

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

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

Schema for reddit_my_post

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
author	text	Author of the post.
author_fullname	text	Full name of the author for the post.
created_utc	timestamp with time zone	Time when the post was created.
edited	timestamp with time zone	Time when the post was edited.
id	text	ID of the post.
is_self	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.
name	text	Slug (full ID) of the post.
num_comments	bigint	Number of comments on the post.
over_18	boolean	True if the post is not safe for work (over 18).
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.
selftext	text	Body of the post.
spoiler	boolean	True if the post is a spoiler.
stickied	boolean	True if the post has been stickied.
subreddit	text	Name of the subreddit, e.g. aws.
subreddit_id	text	ID of the subreddit.
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_post