reddit

w and shiny at the right time (when everyone was deciding that writing the frontend and the backend in the same language, javascript, was an awesome thing -- which I don't necessarily disagree with). If someone needs a database these days, I always just suggest postgres. if it's good enoguh for reddit (https://github.com/reddit/reddit/wiki/Architecture-Overview#...), it's good enough for the next facebook for dogs (unless your problem is completely different then of course you should explore whatever database paradigm fits your problem the best).

it's the fact that your request failed with a 503 error or otherwise timed out as much as it was a data store problem. Next time it happens, wait 5 minutes and try again. > is there really no other way to cluster their data except "one big table"? Maybe like shard subreddits to specific servers ala Hyperdex? The whole point of MongoDB or Cassandra is that you can get shards without all the headache that RDBMSs usually put you through. You configure your sharding function and let the system do the rest. You don't have to connect to the right shard or anything of the sort, which some RDBMSs do (or did, it's been awhile since I've looked) require with sharding. Reddit has their code and architecture posted, though it's out-of-date now, it makes it clear that it's basically just two big tables: https://github.com/reddit/reddit/wiki/Architecture-Overview It's PostgreSQL, ThingDB, Cassandra, memcached, and RabbitMQ.

ddit subscribers have been eligible to see ads targeted to a subreddit as long as they are visiting safe for work content since this commit ~2 years ago: https://github.com/reddit/reddit/commit/f6a37b64c17579b82e22...) The release of our new ads platform also coincided with a re-release of our help center docs, which detail how subreddit targeting works. You can see the specific page here: https://www.reddithelp.com/en/categories/advertising/targeti... As noted there: "Targeting a subreddit means you are targeting the subscribers and recent visitors of that subreddit. Subscribers can see your ad while visiting the targeted subreddit and on other subreddits if they recently visited that targeted subreddit." We made this change in response to advertiser feedback that they would like to see an increase in targeted inventory, the idea being that if you're interested in jerky when you're on /r/jerky you're also interested in jerky when you're not on /r/jerky. This change has helped a good number of our advertisers successfully expand budgets while still meeting their return on ad spend goals, specifically for advertisers that target smaller subreddits regularly. We of course also limit the subreddits your ads can show on outside of the targeted subreddit to ones that are similarly "brand safe" to the ones you are targeting. (e.g. if you are explicitly targeting only NSFW subs your ad will show up on other NSFW subs, but if you're not targeting NSFW subs your ad will never show up on a NSFW sub) While we haven't done any sort of official analysis of CPM changes here, the expected effect of this change was that advertisers would be able to spend significantly more budget (a specific request of many of our advertisers). An expected side effect is that CPMs might possibly increase due to more bids on a per-impression basis, but since you're bidding on a wider range of inventory I would expect that you would be able to reduce your CPMs and still spend the same budget you were spending before, with similar performance. If there's something I can do to help please don't hesitate to email me directly (jamie@reddit.com). In the future for ads problems we also hang out on https://www.reddit.com/r/redditads

ture by other major sites.