• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 22:12
CEST 04:12
KST 11:12
  • 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
Code S Season 2 - RO4 & Finals Results (2025)6Code S RO4 & Finals Preview: herO, Rogue, Classic, GuMiho0TL Team Map Contest #5: Presented by Monster Energy4Code S RO8 Preview: herO, Zoun, Bunny, Classic7Code S RO8 Preview: Rogue, GuMiho, Solar, Maru3
Community News
Weekly Cups (June 9-15): herO doubles on GSL week0Firefly suspended by EWC, replaced by Lancer12Classic & herO RO8 Interviews: "I think it’s time to teach [Rogue] a lesson."2Rogue & GuMiho RO8 interviews: "Lifting that trophy would be a testament to all I’ve had to overcome over the years and how far I’ve come on this journey.8Code S RO8 Results + RO4 Bracket (2025 Season 2)14
StarCraft 2
General
Code S Season 2 - RO4 & Finals Results (2025) Nexon wins bid to develop StarCraft IP content, distribute Overwatch mobile game Rain's Behind the Scenes Storytime Firefly suspended by EWC, replaced by Lancer How herO can make history in the Code S S2 finals
Tourneys
RSL: Revival, a new crowdfunded tournament series $3,500 WardiTV European League 2025 [GSL 2025] Code S: Season 2 - Semi Finals & Finals WardiTV Mondays Sparkling Tuna Cup - Weekly Open Tournament
Strategy
How did i lose this ZvP, whats the proper response Simple Questions Simple Answers [G] Darkgrid Layout
Custom Maps
[UMS] Zillion Zerglings
External Content
Mutation # 478 Instant Karma Mutation # 477 Slow and Steady Mutation # 476 Charnel House Mutation # 475 Hard Target
Brood War
General
ASL20 Preliminary Maps BGH Auto Balance -> http://bghmmr.eu/ BW General Discussion Recent recommended BW games FlaSh Witnesses SCV Pull Off the Impossible vs Shu
Tourneys
[Megathread] Daily Proleagues [BSL 2v2] ProLeague Season 3 - Friday 21:00 CET Small VOD Thread 2.0 [BSL20] ProLeague Bracket Stage - Day 4
Strategy
Simple Questions, Simple Answers I am doing this better than progamers do. [G] How to get started on ladder as a new Z player
Other Games
General Games
Path of Exile Stormgate/Frost Giant Megathread Nintendo Switch Thread Beyond All Reason What do you want from future RTS games?
Dota 2
Official 'what is Dota anymore' discussion
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
Vanilla Mini Mafia TL Mafia Community Thread
Community
General
Things Aren’t Peaceful in Palestine US Politics Mega-thread Russo-Ukrainian War Thread UK Politics Mega-thread Echoes of Revolution and Separation
Fan Clubs
SKT1 Classic Fan Club! Maru Fan Club
Media & Entertainment
Korean Music Discussion [Manga] One Piece
Sports
2024 - 2025 Football Thread Formula 1 Discussion NHL Playoffs 2024 TeamLiquid Health and Fitness Initiative For 2023
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List
Blogs
A Better Routine For Progame…
TrAiDoS
StarCraft improvement
iopq
Heero Yuy & the Tax…
KrillinFromwales
I was completely wrong ab…
jameswatts
Need Your Help/Advice
Glider
Trip to the Zoo
micronesia
Customize Sidebar...

Website Feedback

Closed Threads



Active: 31774 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
PiGosaur Monday
00:00
#36
PiGStarcraft722
CranKy Ducklings170
SteadfastSC114
EnkiAlexander 97
rockletztv 45
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
PiGStarcraft722
Nina 133
SteadfastSC 114
StarCraft: Brood War
Artosis 824
HiyA 145
ajuk12(nOOB) 10
Icarus 10
Dota 2
monkeys_forever137
Counter-Strike
Fnx 1752
taco 548
Heroes of the Storm
Khaldor114
Other Games
summit1g10672
C9.Mang0953
shahzam916
JimRising 412
Mew2King227
Maynarde126
Trikslyr63
Sick46
Organizations
Other Games
gamesdonequick892
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 16 non-featured ]
StarCraft 2
• Hupsaiya 64
• Berry_CruncH58
• AfreecaTV YouTube
• sooper7s
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
StarCraft: Brood War
• RayReign 49
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
League of Legends
• Doublelift4413
Counter-Strike
• Shiphtur289
Other Games
• Scarra1194
Upcoming Events
RSL Revival
7h 48m
herO vs sOs
Zoun vs Clem
Replay Cast
21h 48m
The PondCast
1d 7h
RSL Revival
1d 7h
Harstem vs SHIN
Solar vs Cham
Replay Cast
1d 21h
RSL Revival
2 days
Reynor vs Scarlett
ShoWTimE vs Classic
uThermal 2v2 Circuit
2 days
SC Evo League
3 days
Road to EWC
3 days
Circuito Brasileiro de…
3 days
[ Show More ]
Sparkling Tuna Cup
4 days
Road to EWC
4 days
Online Event
6 days
Liquipedia Results

Completed

Acropolis #3 - GSC
2025 GSL S2
Heroes 10 EU

Ongoing

JPL Season 2
BSL 2v2 Season 3
BSL Season 20
Acropolis #3
KCM Race Survival 2025 Season 2
NPSL S3
Rose Open S1
CSL 17: 2025 SUMMER
Copa Latinoamericana 4
RSL Revival: Season 1
Murky Cup #2
BLAST.tv Austin Major 2025
ESL Impact League Season 7
IEM Dallas 2025
PGL Astana 2025
Asian Champions League '25
BLAST Rivals Spring 2025
MESA Nomadic Masters
CCT Season 2 Global Finals
IEM Melbourne 2025
YaLLa Compass Qatar 2025
PGL Bucharest 2025

Upcoming

CSLPRO Last Chance 2025
CSLPRO Chat StarLAN 3
K-Championship
SEL Season 2 Championship
Esports World Cup 2025
HSC XXVII
Championship of Russia 2025
BLAST Open Fall 2025
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual
IEM Cologne 2025
FISSURE Playground #1
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.