Oh, my God! It’s full of Tweets!

In: Uncategorized

4 Mar 2014

I have had a crazy experience with Twitter and the concept of something going viral on the Internet.

I tweet a lot of (IMHO) interesting articles, blog posts, web pages, Github projects and other things, which find their way into my browser on my twitter account @jonasbn – these get a few clicks, a favorite or two once in a while and the occasional retweet.

I use bufferapp to monitor and schedule this to sort of spread the load out and this give me some additional data/statistics on my tweets and postings to Linkedin, I will get back to my observation on bufferapp later.

The other day, first of March to be exact something extraordinary happened. I tweeted a link to an image showing SQL joins visualized. I had located it via a weekly email newsletter I am getting, since it was a diagram I already new after having located it in a Google search result a long time go. I actually tweeted it at some point in the past, where nothing really happened, but something surely did this time around.

A short time after the tweet, I got a response from @Obra, an old friend and fellow perl monger, but also a master hacker. And I think his mention got things rolling. For the next 3 days, actually all the way up to today (luckily it is decreasing now) I kept getting notifications indicating retweets and favorites and at the time of writing, the post has received:

- 384 favorites

And according to bufferapp, the post has had a potential reach of approx. 23600 readers.

In the beginning I check my iPhone every time it buzzed, I actually thought it was my oldest son writing, since he got iMessage enabled on his iPad and is practicing writing, by writing short messages to me his dad. But it was just people retweeting and favoriting to an extent I have never experienced before.

I kept thinking it would stop, so I did not disable the notifications, but every time I thought it had stopped, a new wave rolled.

In between all the retweets, mentions and favorites was an occasional response. I will quote some of there here:

@obra: Suddenly the names for joins make sense
This is the tweet I suspect fired it off

@havvy: @jonasbn @ljharb Needs to show the set theory formulas for them too.
Other users get mentioned as it spreads out and requests for optimizations

@Pyegar: @obra @IanMulvany @jonasbn “Now and Venn, there’s a Fool, such as I.” — Prof. Elvis Presley.
I do not get this one, but hey…

@pauliom: @jonasbn @klmcmahon wouldn’t the bottom left be better described with a UNION?
A question I am inclined to respond to, but I did create the original chart

@EffectiX: @jonasbn @Starefossen I love that chart. I have it pegged in my desk for quick reference. :D
I personally have it in a menu in the dock as a PDF for quick viewing

@Starefossen: @EffectiX @jonasbn me to!
Excitement :-)

@bollaking: @jonasbn: A classic – SQL joins visualized – 1m55Wqo.jpg (966×760)
Found at
http://bit.ly/1gGW5yx  pic.twitter.com/YLMyjPncWm” How easy is dat
I dunno

@Claus: @jonasbn @tobiashm great – but also horribly wrong. Joins are subsets of the *product set* AxB, not of A+B
Perhaps, 384 favorites might have been misguided by my tweet – again I did not make the original diagram

This is really something I have never experienced before and it was quite fun and interesting to observe a tweet go viral. The only thing, which I found a bit sad, was that it was just something I had stumbled upon on the Internet and not something original I had written or created. I posted to tweets to two of my own blog posts on the 2nd. of March and they where back to the regular pattern I mentioned in the beginning.

I have looked at the responses and are considering responding, perhaps creating a copy of the original and creating my own version
- incorporating the request for formulas
- looking into a diagram of unions and the like
- investigating the possible issue with subset
- finding out whether Elvis Presley really has a degree

But I do suspect that I would just find out that it is not as easy – as dat. Original content is hard to do. Getting stuff to go viral is pure coincidence and people who tell you otherwise are probably just after your money.

I like the diagram since it helps me to visualize SQL joins, I like graphical representations and I am a very visual person, but not an artist, graphical designer or in any way good at drawing up stuff – and it seems like 384 people who favorited the tweet feel the same as me.

So kudos to the creator of the original diagram – Christopher-moffatt (ref: http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins)

And just for the record it seems one of my favorite podcasters: Jeff Atwood did something similar (ref: http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/).

And just to follow up on bufferapp, it reached the count of 23600 pretty fast so either bufferapp has an issue with counting or all the twitter users are all interconnected or they have no followers – I personally think it is the first thing.

Take care and happy tweeting,

jonasbn, Copenhagen/Denmark

1 Response to Oh, my God! It’s full of Tweets!



March 9th, 2014 at 16:28

I investigated briefly the difference between join and union and responded to @pauliom. The diagrams show SQL joins and yes the left botton can be described as a union, but there is actually a small difference, ref: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/cb8fed73-c134-46ef-aff8-7d4ea57a1033/difference-between-union-all-and-full-outer-join?forum=transactsql

Comment Form

About this blog

This is the corporate blog of logicLAB. A software development company based in Copenhagen, Denmark

March 2014
« Oct