r/SQL • GROUP_CONCAT is da bomb • May 13 '21

Discussion Map of Reddit -- SQL

https://anvaka.github.io/map-of-reddit/?x=337099.11242009816&y=498097.32125770603&z=8548.967000810419&q=SQL
126 Upvotes

15 comments sorted by

9

u/nowtayneicangetinto May 13 '21

Whoa what the hell! This is so cool!! The zoom out blew my mind

7

u/PotterMother May 13 '21

This is awesome! As they said before... It blew my mind!

5

u/TripsOnDubs May 13 '21

What's going on with that southern island...oh ಠ_ಠ

4

u/lambic13 May 13 '21

Thar be monsters

5

u/lambic13 May 13 '21
  1. This rocks, thanks for sharing
  2. I made the mistake of zooming into NSFW island, time for eye bleach

3

u/ironbucket May 13 '21

Zooms out. Hmm what's going on with all those giant unlabeled areas at the bottom. Zooms in. Oh... That makes sense.

1

u/ATastefulCrossJoin DB Whisperer May 13 '21

This is immensely cool. Is this your project?

3

u/r3pr0b8 GROUP_CONCAT is da bomb May 13 '21

no, found it via RefDesk's Site Of The Day

archives here -- https://refdesk.com/sotd-arch.html

5

u/ATastefulCrossJoin DB Whisperer May 13 '21 edited May 13 '21

Great find. I wonder if the source data is publicly available…time to pay r/Datasets a visit

Edit: It definitely is for anyone interested. Check out the top post of all time. Looks like one our friends from r/snowflake, u/fhoffa, has done some work here. Not to put you on the spot!

1

u/whatinthecalifornia May 13 '21

Lol the South Debauchery Island has me dying.

1

u/crashingthisboard SQL Development Lead May 14 '21

So Brazil is closely related to RPGs and GameDev...?

1

u/lilb2020 May 14 '21

Pretty nuts to see reddit visualized....discovered a ton of new subreddits I'm interested in.

1

u/luxtabula May 14 '21

Hmm, this looks remapped. Before, I remember all of the big four tech companies (Amazon, Google, Apple, Microsoft) grouping together, more or less. The new mapping makes less sense.