• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 18:08
CEST 00:08
KST 07:08
  • 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: Voting10[ASL20] Ro4 Preview: Descent11Team TLMC #5: Winners Announced!3[ASL20] Ro8 Preview Pt2: Holding On9Maestros of the Game: Live Finals Preview (RO4)5
Community News
Chinese SC2 server to reopen; live all-star event in Hangzhou21Weekly Cups (Oct 13-19): Clem Goes for Four3BSL Team A vs Koreans - Sat-Sun 16:00 CET7Weekly Cups (Oct 6-12): Four star herO85.0.15 Patch Balance Hotfix (2025-10-8)81
StarCraft 2
General
RotterdaM "Serral is the GOAT, and it's not close" Chinese SC2 server to reopen; live all-star event in Hangzhou The New Patch Killed Mech! Weekly Cups (Oct 13-19): Clem Goes for Four 5.0.15 Patch Balance Hotfix (2025-10-8)
Tourneys
Merivale 8 Open - LAN - Stellar Fest Tenacious Turtle Tussle RSL Season 3 Qualifier Links and Dates $1,200 WardiTV October (Oct 21st-31st) SC2's Safe House 2 - October 18 & 19
Strategy
Custom Maps
Map Editor closed ?
External Content
Mutation # 496 Endless Infection Mutation # 495 Rest In Peace Mutation # 494 Unstable Environment Mutation # 493 Quick Killers
Brood War
General
OGN to release AI-upscaled StarLeague from Feb 24 Is there anyway to get a private coach? BW General Discussion BGH Auto Balance -> http://bghmmr.eu/ SnOw's Awful Building Placements vs barracks
Tourneys
Small VOD Thread 2.0 ASL final tickets help [Megathread] Daily Proleagues [ASL20] Semifinal B
Strategy
Roaring Currents ASL final Relatively freeroll strategies BW - ajfirecracker Strategy & Training TvP Upgrades
Other Games
General Games
Path of Exile Nintendo Switch Thread Stormgate/Frost Giant Megathread Dawn of War IV ZeroSpace Megathread
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
TL Mafia Community Thread SPIRED by.ASL Mafia {211640}
Community
General
Russo-Ukrainian War Thread US Politics Mega-thread Things Aren’t Peaceful in Palestine YouTube Thread The Chess Thread
Fan Clubs
White-Ra Fan Club The herO Fan Club!
Media & Entertainment
[Manga] One Piece Korean Music Discussion Anime Discussion Thread Series you have seen recently... Movie Discussion!
Sports
2024 - 2026 Football Thread TeamLiquid Health and Fitness Initiative For 2023 MLB/Baseball 2023 Formula 1 Discussion NBA General Discussion
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
The Benefits Of Limited Comm…
TrAiDoS
Sabrina was soooo lame on S…
Peanutsc
Our Last Hope in th…
KrillinFromwales
Certified Crazy
Hildegard
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1280 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 PiG Daily
22:00
Best Games of SC
ByuN vs Solar
Reynor vs herO
MaxPax vs Solar
Clem vs MaxPax
LiquipediaDiscussion
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
UpATreeSC 197
ProTech104
PiGStarcraft65
StarCraft: Brood War
Britney 24341
Bisu 4265
Larva 204
Hyun 107
ggaemo 58
Dota 2
syndereN467
canceldota130
Counter-Strike
Stewie2K499
Foxcn134
Heroes of the Storm
Liquid`Hasu589
Trikslyr48
Other Games
FrodaN3676
Grubby2531
shahzam529
mouzStarbuck315
ToD186
KnowMe186
C9.Mang0119
ViBE82
PPMD35
fpsfer 2
Organizations
Counter-Strike
PGL197
Other Games
BasetradeTV24
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 20 non-featured ]
StarCraft 2
• StrangeGG 85
• RyuSc2 37
• davetesta25
• OhrlRock 2
• LaughNgamezSOOP
• AfreecaTV YouTube
• sooper7s
• intothetv
• Kozan
• IndyKCrew
• Migwel
StarCraft: Brood War
• RayReign 32
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Dota 2
• Noizen28
League of Legends
• Doublelift2229
Other Games
• imaqtpie1464
• Shiphtur156
• Scarra18
Upcoming Events
RSL Revival
3h 52m
RSL Revival
11h 52m
WardiTV Invitational
12h 52m
OSC
16h 52m
SKillous vs goblin
Spirit vs GgMaChine
ByuN vs MaxPax
Afreeca Starleague
1d 9h
Snow vs Soma
Sparkling Tuna Cup
1d 11h
WardiTV Invitational
1d 13h
CrankTV Team League
1d 14h
BASILISK vs Streamerzone
Team Liquid vs Shopify Rebellion
Team Vitality vs Team Falcon
RSL Revival
1d 18h
Wardi Open
2 days
[ Show More ]
CrankTV Team League
2 days
Replay Cast
3 days
WardiTV Invitational
3 days
CrankTV Team League
3 days
Replay Cast
4 days
CrankTV Team League
4 days
Replay Cast
5 days
The PondCast
5 days
CrankTV Team League
5 days
Replay Cast
6 days
WardiTV Invitational
6 days
CrankTV Team League
6 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
KCM Race Survival 2025 Season 4
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

Upcoming

SC4ALL: Brood War
BSL Season 21
BSL 21 Team A
BSL 21 Non-Korean Championship
RSL Offline Finals
RSL Revival: Season 3
Stellar Fest
SC4ALL: StarCraft II
CranK Gathers Season 2: SC II Pro Teams
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.