• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 09:14
CEST 15:14
KST 22:14
  • 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
TL.net Map Contest #21: Voting4[ASL20] Ro4 Preview: Descent10Team TLMC #5: Winners Announced!3[ASL20] Ro8 Preview Pt2: Holding On9Maestros of the Game: Live Finals Preview (RO4)5
Community News
Weekly Cups (Oct 6-12): Four star herO65.0.15 Patch Balance Hotfix (2025-10-8)72Weekly Cups (Sept 29-Oct 5): MaxPax triples up3PartinG joins SteamerZone, returns to SC2 competition325.0.15 Balance Patch Notes (Live version)119
StarCraft 2
General
The New Patch Killed Mech! TL.net Map Contest #21: Voting 5.0.15 Patch Balance Hotfix (2025-10-8) Ladder Impersonation (only maybe) Weekly Cups (Oct 6-12): Four star herO
Tourneys
Sparkling Tuna Cup - Weekly Open Tournament Master Swan Open (Global Bronze-Master 2) Tenacious Turtle Tussle WardiTV Mondays SC2's Safe House 2 - October 18 & 19
Strategy
Custom Maps
External Content
Mutation # 495 Rest In Peace Mutation # 494 Unstable Environment Mutation # 493 Quick Killers Mutation # 492 Get Out More
Brood War
General
[ASL20] Ro4 Preview: Descent BW caster Sayle ASL20 General Discussion BW General Discussion BSL Season 21
Tourneys
[ASL20] Semifinal B [ASL20] Semifinal A [Megathread] Daily Proleagues [ASL20] Ro8 Day 4
Strategy
Current Meta BW - ajfirecracker Strategy & Training Siegecraft - a new perspective TvZ Theorycraft - Improving on State of the Art
Other Games
General Games
Nintendo Switch Thread Stormgate/Frost Giant Megathread ZeroSpace Megathread Dawn of War IV Path of Exile
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
Deck construction bug Heroes of StarCraft mini-set
TL Mafia
SPIRED by.ASL Mafia {211640} TL Mafia Community Thread
Community
General
US Politics Mega-thread Things Aren’t Peaceful in Palestine Russo-Ukrainian War Thread Men's Fashion Thread Sex and weight loss
Fan Clubs
The herO Fan Club! The Happy Fan Club!
Media & Entertainment
Anime Discussion Thread [Manga] One Piece Movie Discussion!
Sports
2024 - 2026 Football Thread Formula 1 Discussion MLB/Baseball 2023 NBA General Discussion TeamLiquid Health and Fitness Initiative For 2023
World Cup 2022
Tech Support
SC2 Client Relocalization [Change SC2 Language] Linksys AE2500 USB WIFI keeps disconnecting Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List Recent Gifted Posts
Blogs
Inbreeding: Why Do We Do It…
Peanutsc
From Tilt to Ragequit:The Ps…
TrAiDoS
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1096 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
LiuLi Cup
11:00
46
herO vs ClemLIVE!
Creator vs TBD
WardiTV1033
TKL 200
Rex135
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
TKL 200
Rex 135
LamboSC2 88
ProTech55
StarCraft: Brood War
Calm 8823
Sea 5427
Rain 4063
Flash 1577
Horang2 1514
Zeus 880
Leta 725
actioN 707
Soma 652
Stork 464
[ Show more ]
BeSt 401
Snow 367
Mini 307
hero 231
ZerO 210
Last 192
EffOrt 192
Hyun 178
Light 155
Mong 124
PianO 107
JYJ78
Sharp 77
Barracks 66
ToSsGirL 65
Rush 61
Pusan 61
Larva 56
Mind 54
JulyZerg 46
Killer 37
Movie 32
Shine 27
Backho 25
sas.Sziky 24
Icarus 21
soO 18
Shinee 15
scan(afreeca) 13
Sacsri 11
HiyA 10
Terrorterran 9
Noble 7
Bale 6
Dota 2
qojqva3304
Gorgc3149
Dendi1248
XcaliburYe295
420jenkins275
BananaSlamJamma148
League of Legends
JimRising 362
Counter-Strike
x6flipin307
Other Games
singsing2179
olofmeister892
B2W.Neo613
DeMusliM336
crisheroes300
Pyrionflax269
byalli180
Fuzer 113
Mew2King36
QueenE29
ZerO(Twitch)11
Organizations
Counter-Strike
PGL4040
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 13 non-featured ]
StarCraft 2
• iHatsuTV 10
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• C_a_k_e 988
League of Legends
• Jankos1888
Upcoming Events
OSC
9h 46m
Replay Cast
9h 46m
The PondCast
20h 46m
OSC
22h 46m
Wardi Open
1d 21h
CranKy Ducklings
2 days
Safe House 2
3 days
Sparkling Tuna Cup
3 days
Safe House 2
4 days
Liquipedia Results

Completed

Acropolis #4 - TS2
WardiTV TLMC #15
HCC Europe

Ongoing

BSL 21 Points
ASL Season 20
CSL 2025 AUTUMN (S18)
C-Race Season 1
IPSL Winter 2025-26
EC S1
Thunderpick World Champ.
CS Asia Championships 2025
ESL Pro League S22
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

Upcoming

SC4ALL: Brood War
BSL Season 21
BSL 21 Team A
RSL Offline Finals
RSL Revival: Season 3
Stellar Fest
SC4ALL: StarCraft II
eXTREMESLAND 2025
ESL Impact League Season 8
SL Budapest Major 2025
BLAST Rivals Fall 2025
IEM Chengdu 2025
PGL Masters Bucharest 2025
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.