Media Content about subreddit-archiver HOT 1 CLOSED

Hi,

The links to media content are recorded, yes. Right now it doesn't store the media itself. You can find details in schema.sql which describes the output database (it's annotated with comments explaining the columns) but I will outline the relevant columns, they're in the posts table.

1. when the column is_self is false, the post is not a self-post (text-only post) which would mean it's either a link post (a post with that links elsewhere but not to another reddit post) or a crosspost (a post that links to another reddit post). what it points to is stored in the url column.
2. when the url column doesn't point to another reddit post, that means it isn't a crosspost. So it's a link post, in which case it might link to some media (imgur, i.reddit.com, or v.reddit.com, etc.) or some other website (maybe a news article). This is the column where you'll find the links to media if it isn't a link to some other website.

Hope that helps, feel free to ask if you'd like me to elaborate/clarify.

Because reddit allows you to embed from all sorts of places (i.reddit.com, v.reddit.com, gfycat, imgur, etc) I don't think there's a general solution to saving media, but I haven't really thought about it. Can you maybe share what kind of media you're trying to save? I can try look into it.

Also, thanks for the kind words, I really appreciate it :)

from subreddit-archiver.