• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 09:55
CEST 15:55
KST 22:55
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
Team TLMC #5 - Finalists & Open Tournaments0[ASL20] Ro16 Preview Pt2: Turbulence10Classic Games #3: Rogue vs Serral at BlizzCon9[ASL20] Ro16 Preview Pt1: Ascent10Maestros of the Game: Week 1/Play-in Preview12
Community News
BSL 2025 Warsaw LAN + Legends Showmatch0Weekly Cups (Sept 8-14): herO & MaxPax split cups4WardiTV TL Team Map Contest #5 Tournaments1SC4ALL $6,000 Open LAN in Philadelphia8Weekly Cups (Sept 1-7): MaxPax rebounds & Clem saga continues29
StarCraft 2
General
#1: Maru - Greatest Players of All Time Weekly Cups (Sept 8-14): herO & MaxPax split cups Team Liquid Map Contest #21 - Presented by Monster Energy SpeCial on The Tasteless Podcast Team TLMC #5 - Finalists & Open Tournaments
Tourneys
RSL: Revival, a new crowdfunded tournament series Maestros of The Game—$20k event w/ live finals in Paris Sparkling Tuna Cup - Weekly Open Tournament SC4ALL $6,000 Open LAN in Philadelphia WardiTV TL Team Map Contest #5 Tournaments
Strategy
Custom Maps
External Content
Mutation # 491 Night Drive Mutation # 490 Masters of Midnight Mutation # 489 Bannable Offense Mutation # 488 What Goes Around
Brood War
General
BW General Discussion ASL20 General Discussion ASL TICKET LIVE help! :D Soulkey on ASL S20 NaDa's Body
Tourneys
[ASL20] Ro16 Group D [ASL20] Ro16 Group C [Megathread] Daily Proleagues BSL 2025 Warsaw LAN + Legends Showmatch
Strategy
Simple Questions, Simple Answers Muta micro map competition Fighting Spirit mining rates [G] Mineral Boosting
Other Games
General Games
Path of Exile Stormgate/Frost Giant Megathread Nintendo Switch Thread Borderlands 3 General RTS Discussion Thread
Dota 2
Official 'what is Dota anymore' discussion LiquidDota to reintegrate into TL.net
League of Legends
Heroes of the Storm
Simple Questions, Simple Answers Heroes of the Storm 2.0
Hearthstone
Heroes of StarCraft mini-set
TL Mafia
TL Mafia Community Thread
Community
General
US Politics Mega-thread Things Aren’t Peaceful in Palestine UK Politics Mega-thread Canadian Politics Mega-thread Russo-Ukrainian War Thread
Fan Clubs
The Happy Fan Club!
Media & Entertainment
Movie Discussion! [Manga] One Piece Anime Discussion Thread
Sports
2024 - 2026 Football Thread Formula 1 Discussion MLB/Baseball 2023
World Cup 2022
Tech Support
Linksys AE2500 USB WIFI keeps disconnecting Computer Build, Upgrade & Buying Resource Thread High temperatures on bridge(s)
TL Community
BarCraft in Tokyo Japan for ASL Season5 Final The Automated Ban List
Blogs
i'm really bored guys
Peanutsc
I <=> 9
KrillinFromwales
The Personality of a Spender…
TrAiDoS
A very expensive lesson on ma…
Garnet
hello world
radishsoup
Lemme tell you a thing o…
JoinTheRain
RTS Design in Hypercoven
a11
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1392 users

Detailed graphs of stream viewer numbers

Forum Index > SC2 General
Post a Reply
1 2 Next All
soiii
Profile Joined July 2011
Germany266 Posts
Last Edited: 2012-07-23 21:35:19
July 23 2012 19:46 GMT
#1
Hi everybody,

I spend the last couple of weeks when I had some free time from my studies to build a website I always wanted to have. Its about stream viewer numbers with detailed graphs showing them. The address is sc2streamnumbers.com and here is how it looks:

[image loading]

What you are seeing now is the change in the viewer number over the last hour. The viewer number gets saved every 5 minutes. You can change that to the view of the last 24 hours, the last week or month. As a graph with a point for every 5 minutes in the last month would be quite crowded (8640 points) the site creates average values for the different time resolutions.

You can also go back and forth in time or switch on the auto update to automaticly retrieve updated graphs. Also there is a search function and a list with the current online streams which contains roughly the same streams as the famous tl list available here.

How its done
For the fellow programmers browsing this forum here is how its done from the technical point of view. The page queries the xml view of the tl stream list every 5 minutes and saves all the relevant data in a postgresql database. It also creates all the average values if needed. This is done by a python script.

The website itself is made with Django, a beautiful python web framework. Also I used Jquery for the ajax calls and elycharts for the graphs. I feel like this is a very powerful software stack.

If you are interested in the server side code just write me a pm and I can give you access to my repository.

Advertising
I am aware that this thread might fall under the advertising rule as I am not a very active tl member and it somewhat promotes a website. But please keep in mind that there are no ads on the site and this serves a very niche interest. I dont even own a company or something similiar and never put advertising on the sites I made.

Have a nice day,
soiii
HaXXspetten
Profile Blog Joined October 2009
Sweden15718 Posts
July 23 2012 19:48 GMT
#2
Heh, that's pretty neat actually ^^

gj
nath
Profile Blog Joined May 2010
United States1788 Posts
July 23 2012 19:49 GMT
#3
i wouldnt say that you used a "very powerful software stack", more like one that is easy to use, but not that powerful.

nevertheless, i really like what you've done here
Founder of Flow Enterprises, LLC http://flow-enterprises.com/
soiii
Profile Joined July 2011
Germany266 Posts
July 23 2012 20:44 GMT
#4
Thanks for the positive feedback so far ^.^ If you found bugs or have ideas what could be changed feel free to post it.
dani`
Profile Joined January 2011
Netherlands2402 Posts
July 23 2012 20:51 GMT
#5
Looks quite nice. I'd recommend changing 'hour/day/week/month Before' to 'Previous hour/day/week/month'. Having a capital letter for the second word is weird, and it makes more sense to have previous <=> next as opposed to before <=> next in my opinion
soiii
Profile Joined July 2011
Germany266 Posts
July 23 2012 21:08 GMT
#6
On July 24 2012 05:51 dani` wrote:
Looks quite nice. I'd recommend changing 'hour/day/week/month Before' to 'Previous hour/day/week/month'. Having a capital letter for the second word is weird, and it makes more sense to have previous <=> next as opposed to before <=> next in my opinion

Sounds reasonable and got changed.
skatblast
Profile Joined September 2011
United States784 Posts
July 23 2012 21:11 GMT
#7
looks like a awesome site
Xanatoss
Profile Joined May 2010
Germany539 Posts
July 23 2012 21:20 GMT
#8
As if you read my Mind O.O
I just looked at the upper right corner of TL.net and thought to myself "I wonder how Stream-Viewer numbers are distributed over time."
Would be awesome if you could implement an overall monitor.

Great work! Always jelly about people with these kind of skills.
The chair slowly turns around. You see his face, but it can't be. He's not supposed to be here. Not him. Not a Protoss. Not THAT Protoss. MC says, "Hi Greg, long time no see." You back slowly out of the booth. But you can't. It's already forcefielded.
babybell
Profile Joined June 2011
776 Posts
July 23 2012 21:26 GMT
#9
woowowow well done dude.
very nice visually too.
SoniC_eu
Profile Joined April 2011
Denmark1008 Posts
July 23 2012 21:28 GMT
#10
nice work dood :D
In order to succeed, your desire for success should be greater than your fear of failure. http://da.twitch.tv/sonic_eu
Anta
Profile Joined April 2012
Germany434 Posts
July 23 2012 21:30 GMT
#11
this is amazing!

sc2 community we are the internet has!
"In short: stop bitching, change your tampons and up your game." mad respect to CloudNineLabs.com http://i.imgur.com/g5KGz.jpg ! I love Dreamhack!
ridethecatbus
Profile Joined February 2012
United States64 Posts
Last Edited: 2012-07-23 21:37:35
July 23 2012 21:37 GMT
#12
soiii, that's awesome man! What do you think of adding a Year-to-date button or letting the user set the time parameters?
nakam
Profile Joined April 2010
Sweden245 Posts
July 23 2012 21:43 GMT
#13
I like it! Would be neat with an option to trim times when the person is not streaming and have like a marker in the graph when the person started streaming.
TL Local Timezone Script - http://www.teamliquid.net/forum/viewmessage.php?topic_id=277156
soiii
Profile Joined July 2011
Germany266 Posts
July 23 2012 21:46 GMT
#14
On July 24 2012 06:37 ridethecatbus wrote:
What do you think of adding a Year-to-date button or letting the user set the time parameters?

Making the time parameters more flexible sounds like a good idea. What exactly do you mean with a Year-to-date button?
soiii
Profile Joined July 2011
Germany266 Posts
July 23 2012 21:52 GMT
#15
On July 24 2012 06:43 nakam wrote:
I like it! Would be neat with an option to trim times when the person is not streaming and have like a marker in the graph when the person started streaming.

Changing the time interval by cutting off empty time might be rather complicated but I will look into a feature were you can jump to the times when the stream was active.
Snackysnacks
Profile Joined December 2010
United States411 Posts
July 23 2012 21:55 GMT
#16
I noticed under Weekly/Monthly doesn't have the current day/Up to day stream numbers
I understand if this is intentional but it would be nicer to see the whole month with the last data value being the latest queried entry.
(╯°□°)╯︵ ┻━┻
archonOOid
Profile Blog Joined March 2011
1983 Posts
Last Edited: 2012-07-23 22:18:19
July 23 2012 22:00 GMT
#17
My personal suggestions that you could add: multiple graphs overlapping each other so that you could compare two streamers, customization (favorites, etc) share of the total number of sc2 (individuals not tournament organizers) streamers and finally an option to display the history of popular offline streamers.
I'm Quotable (IQ)
ridethecatbus
Profile Joined February 2012
United States64 Posts
July 23 2012 22:01 GMT
#18
On July 24 2012 06:46 soiii wrote:
Show nested quote +
On July 24 2012 06:37 ridethecatbus wrote:
What do you think of adding a Year-to-date button or letting the user set the time parameters?

Making the time parameters more flexible sounds like a good idea. What exactly do you mean with a Year-to-date button?


Year-to-date as in 01/01/2012 to today. That or simply a button that shows all of 2012 or 2011.
soiii
Profile Joined July 2011
Germany266 Posts
July 23 2012 22:07 GMT
#19
On July 24 2012 06:55 Snackysnacks wrote:
I noticed under Weekly/Monthly doesn't have the current day/Up to day stream numbers
I understand if this is intentional but it would be nicer to see the whole month with the last data value being the latest queried entry.

Sounds like a good idea.
On July 24 2012 07:00 archonOOid wrote:
My personal suggestions that you could add: multiple graphs overlapping each other so that you could compare two streamers, share of the sc2 individual streamers and display history of popular offline streamers.

Nice idea but quite complicated to do. Will look into that for the 2.0 version of the site
soiii
Profile Joined July 2011
Germany266 Posts
Last Edited: 2012-07-23 22:12:35
July 23 2012 22:12 GMT
#20
On July 24 2012 07:01 ridethecatbus wrote:
Show nested quote +
On July 24 2012 06:46 soiii wrote:
On July 24 2012 06:37 ridethecatbus wrote:
What do you think of adding a Year-to-date button or letting the user set the time parameters?

Making the time parameters more flexible sounds like a good idea. What exactly do you mean with a Year-to-date button?


Year-to-date as in 01/01/2012 to today. That or simply a button that shows all of 2012 or 2011.

Good idea. That might come in handy when the database grows over time. At the moment it only reaches back for about a month.
1 2 Next All
Please log in or register to reply.
Live Events Refresh
The PondCast
13:00
Episode 63
CranKy Ducklings47
Liquipedia
Map Test Tournament
11:00
$450 3v3 Open Cup
WardiTV750
IndyStarCraft 200
LiquipediaDiscussion
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
IndyStarCraft 200
Rex 106
mcanning 49
StarCraft: Brood War
Britney 58418
Calm 8050
Horang2 5202
Bisu 2172
EffOrt 564
Hyuk 551
actioN 451
Light 351
Mini 322
Pusan 259
[ Show more ]
ZerO 226
Soma 137
Soulkey 122
Snow 107
hero 89
Hyun 75
Rush 70
Mind 66
ggaemo 66
Sea.KH 52
ToSsGirL 34
Free 33
sorry 33
Sharp 30
HiyA 28
JYJ27
Sexy 22
scan(afreeca) 17
Aegong 12
Icarus 12
Terrorterran 10
SilentControl 10
IntoTheRainbow 6
Dota 2
Gorgc5257
singsing3374
qojqva2482
Dendi918
XcaliburYe172
Fuzer 168
Counter-Strike
zeus709
hiko476
markeloff171
oskar102
edward0
Other Games
gofns20837
tarik_tv16170
olofmeister1154
B2W.Neo987
DeMusliM314
Lowko294
Hui .214
XaKoH 137
ArmadaUGS94
QueenE61
NeuroSwarm37
Trikslyr26
ZerO(Twitch)10
Organizations
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 15 non-featured ]
StarCraft 2
• intothetv
• AfreecaTV YouTube
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• FirePhoenix5
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
League of Legends
• Nemesis3852
• Jankos1574
Other Games
• WagamamaTV229
• Shiphtur101
Upcoming Events
RSL Revival
20h 5m
Zoun vs Classic
Korean StarCraft League
1d 13h
BSL Open LAN 2025 - War…
1d 18h
RSL Revival
1d 20h
Reynor vs Cure
BSL Open LAN 2025 - War…
2 days
RSL Revival
2 days
Online Event
3 days
Wardi Open
3 days
Monday Night Weeklies
4 days
Sparkling Tuna Cup
4 days
[ Show More ]
LiuLi Cup
5 days
The PondCast
6 days
Liquipedia Results

Completed

Proleague 2025-09-10
Chzzk MurlocKing SC1 vs SC2 Cup #2
HCC Europe

Ongoing

BSL 20 Team Wars
KCM Race Survival 2025 Season 3
BSL 21 Points
ASL Season 20
CSL 2025 AUTUMN (S18)
LASL Season 20
RSL Revival: Season 2
Maestros of the Game
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open Fall 2025
BLAST Open Fall Qual
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual
IEM Cologne 2025
FISSURE Playground #1

Upcoming

2025 Chongqing Offline CUP
BSL World Championship of Poland 2025
IPSL Winter 2025-26
BSL Season 21
SC4ALL: Brood War
BSL 21 Team A
Stellar Fest
SC4ALL: StarCraft II
EC S1
ESL Impact League Season 8
SL Budapest Major 2025
BLAST Rivals Fall 2025
IEM Chengdu 2025
PGL Masters Bucharest 2025
Thunderpick World Champ.
CS Asia Championships 2025
ESL Pro League S22
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2025 TLnet. All Rights Reserved.