• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 00:56
CEST 06:56
KST 13:56
  • 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
[ASL19] Finals Recap: Standing Tall9HomeStory Cup 27 - Info & Preview18Classic wins Code S Season 2 (2025)16Code S RO4 & Finals Preview: herO, Rogue, Classic, GuMiho0TL Team Map Contest #5: Presented by Monster Energy6
Community News
[BSL20] Non-Korean Championship 4x BSL + 4x China2Flash Announces Hiatus From ASL63Weekly Cups (June 23-29): Reynor in world title form?13FEL Cracov 2025 (July 27) - $8000 live event22Esports World Cup 2025 - Final Player Roster16
StarCraft 2
General
Program: SC2 / XSplit / OBS Scene Switcher The SCII GOAT: A statistical Evaluation Statistics for vetoed/disliked maps Weekly Cups (June 23-29): Reynor in world title form? PiG Sty Festival #5: Playoffs Preview + Groups Recap
Tourneys
RSL: Revival, a new crowdfunded tournament series FEL Cracov 2025 (July 27) - $8000 live event Sparkling Tuna Cup - Weekly Open Tournament WardiTV Mondays Korean Starcraft League Week 77
Strategy
How did i lose this ZvP, whats the proper response Simple Questions Simple Answers
Custom Maps
[UMS] Zillion Zerglings
External Content
Mutation # 481 Fear and Lava Mutation # 480 Moths to the Flame Mutation # 479 Worn Out Welcome Mutation # 478 Instant Karma
Brood War
General
SC uni coach streams logging into betting site Player “Jedi” cheat on CSL Flash Announces Hiatus From ASL BW General Discussion Practice Partners (Official)
Tourneys
CSL Xiamen International Invitational [BSL20] Non-Korean Championship 4x BSL + 4x China The Casual Games of the Week Thread [BSL20] Grand Finals - Sunday 20:00 CET
Strategy
Simple Questions, Simple Answers I am doing this better than progamers do.
Other Games
General Games
Stormgate/Frost Giant Megathread Path of Exile Nintendo Switch Thread What do you want from future RTS games? Beyond All Reason
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
TL Mafia Community Thread Vanilla Mini Mafia
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread Summer Games Done Quick 2025! Trading/Investing Thread Things Aren’t Peaceful in Palestine
Fan Clubs
SKT1 Classic Fan Club! Maru Fan Club
Media & Entertainment
Anime Discussion Thread [Manga] One Piece [\m/] Heavy Metal Thread
Sports
Formula 1 Discussion 2024 - 2025 Football Thread NBA General Discussion TeamLiquid Health and Fitness Initiative For 2023 NHL Playoffs 2024
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread
TL Community
Blogs
Culture Clash in Video Games…
TrAiDoS
from making sc maps to makin…
Husyelt
Blog #2
tankgirl
StarCraft improvement
iopq
Trip to the Zoo
micronesia
Customize Sidebar...

Website Feedback

Closed Threads



Active: 652 users

Aligulac'ing it up, an inside experience

Blogs > Grovbolle
Post a Reply
Grovbolle
Profile Blog Joined July 2011
Denmark3805 Posts
Last Edited: 2013-04-23 06:24:51
April 18 2013 21:45 GMT
#1
Hi TL

I have been contemplating writing this blog for some time by now. With this thread sparking some debate (and a lot of mindless comments) I guess now might be as good a time as ever.

First things first, if you want to discuss stuff from that thread, go to that thread. If anyone tries that shit I will ban you (from my blog, because apparently I can do that, and I am power hungry as fuck, so don't even try) :D
This blog is to speak about my experience working on the project that is aligulac.com and what is has been like for me.

I will use first names if those are the ones I usually use so a quick translation:
TheBB = Eivind
kiekaboe = Tom
Otolia = Otolia (Because I don't know how to pronounce his name)
Conti = Conti (Don't know his name either)

I joined the project back in mid december. I wrote a long and fancy e-mail for Eivind (I thought he had plenty of volunteers). Turned out, people doesn't want to contribute if they don't have to. I had spotted plenty of his posts in numerous LR-threads, having taken 3 statistics classes and studying a B.Sc in Business Administration and Information Technology I thought it would be interesting and maybe I could get him to add some cool stuff that people would like. I tried contributing a few simple edits to LP, but mostly just stuff like adding 9-16th of an MLG while it was being played etc.

So I joined aligulac, got a fancy log-in and began getting e-mails from Eivind once in a while.

At the point of me joining, the project had Eivind, PhoenixVoid and Conti I think working on it and adding matches. Most of the work where done on a basis of whoever was watching this weeks GSL would add the matches. Needless to say that this meant a lot of work figuring out whether or not matches were already in the DB.

Fast forward to after new years eve and Tom enters the scene. To those unfamiliar with Tom, he is our work horse. Tom is responsible for around 38 % of all the matches that we have entered manually. If our DB has some random cup, chances are Tom added it. Meanwhile I am pushing for Eivind to add some front end stuff to make it easier to both gain an overview of what we have and what we still need, as well as making the "add matches" process easier. This does eventually happen, and only few minor changes have been made. Also note that Eivind used to crash the site/DB once or twice a day whenever I asked him to add something new.

To better be able to communicate, I suggested we made a skype chat, to both facillitate discussion and get to know each other. We got that around 10th january this year. The skype chat is still going BTW and is really great, even though Conti swears against skype meaning that I know nothing about him other than him being able to program, he adds a lot of matches and is responsible for making the whole "earnings" system work. He's also German and fast to spot when players switch teams.

Around the 14th Jan. one of the biggest changes occured, the addition of the NSM (Nested Set Model). This hierarchy model is responsible for our ability to navigate the entire DB of matches, making event specific statistics and in general just gives an overview of the entire thing. Only one minus, when it was implemented, we had 30-40k unassigned matches. How does one fix that? Well by hand, brute force and pure Tom'ness. So we did, starting with the big tournaments first, filling all the holes and adding as we went. This included searching through game results ranging back to the first IEM where Morrow 5-rax reapered the shit out of IdrA in the finals and up till, well january 2013. Currently we still have 9305 "unassigned" matches, albeit most have some form of identifier and will be assigned, at some point, I think, maybe.

During this period I learned a lesson most of my professors in IT-related subjects had kept repeating: "Get the attributes right the first time, it's gonna be a pain in the ass to do them after you begin adding lines to your DB"- Because to be honest, it sucks dick to do it afterwards. Period.

I think around this time Otolia joined the club. A french who knew how to program and who seemed like a great guy. Whenever Eivind and Otolia would discuss technical stuff I always thought of something Nazgul said about R1CH's first day at TL.

Nazgul: rich first day at work
Nazgul: im in a convo with him + meat
Nazgul: its like reading a detective book where half of the words are gibberish


And as Hot_Bid would do, I also sometimes just said random stuff putting together words I knew, which could be something like: "Can't you just optimize the query load time by by-passing the RAID and going directly to the source using Inner-joins?"
I think I fooled Eivind once, although Otolia knew I was just being a dick :D.

Tournaments are played, matches added, lots of hole filled by Tom (no pun intended) and we gain at least a bit of recognition, spearheaded by the bi-weekly updates Eivind makes here on TL. At one point Eivind suggests we make a Twitter account, me having recently picked up Twitter to follow all the juicy stuff and balance whine that goes on there volunteers for the task. I soon realized that actually tweeting interesting stuff and getting followers isn't as easy as I thought, however with Wax being our very first follower (except for Eivind) I got my spirit up and thought it would be fine.

During the entirety of this, Eivind have experimented a lot with the graphs on the site. With confidence interval, without, match-up specific or not? It wasn't until dsjoerg suggested Highcharts that we got the pretty awesome graphs with zoom and cool features which we have now. And we have something in the pipeline, which I suggested (shameless plug), that is going to be pretty cool I think.

Around the time the graphs update went live, the twitter account had around 100 followers, sporting a few celebs such as Rotterdam, MrBitter and Frodan. TLO has said nice things about us, and Day[9] even made a post in one of Eivind's bi-weekly threads. So I guess we were becoming at least a little bit e-famous. However no single person has raised our follower count as much as Boromir/Jaime Lannister/Kaelaris. A few good RT's from him gained us 20-40 followers, which is a lot unless your name is Liquid Ret (Please follow @liquidret on twitter). Currently our "stable" of e-sports personalities following us include: Rotterdam, MrBitter, Frodan, Kaelaris, Adebisi, Welmu, Feast and Grubby. Which I personally take as a huge succes. I try to use our twitter to tweet predictions from the site, relevant updates regarding match-up win rates and stuff like that.

And that brings an end to my story so far. It has been, and still is a lot of fun working on the site. Taking requests, learning a lot about statistics and the entire premise for the site as well as designing and suggesting various improvements to the site.

I want to end my long-ass post with a request, to all those out there who use the site and want to get in on the fun, please go ahead and volunteer, currently a huge part of the workload is done by only a few, meaning the adding of matches/events, maintaining the NSM, keeping player profiles up to date etc. is done by 4-5 people. Al though we are on paper a few more, most of the day-to-day non-coding stuff is done by Tom, Conti, Eivind and myself and we could use a few more once in a while. It is not that hard, it's pretty fun and you do actually feel great for contributing to an, in my opinion, great site. The learning curve isn't that steep, and there is plenty of help/guidance to get from myself and the others. If this has caught your interest, feel free to send an e-mail to evfonn@gmail.com, PM'ing me or TheBB here on TL or tweeting at us @Sc2Aligulac (or just follow us for lots of stats goodies and shenanigans).

If you are a programmer who knows mysql, django and python I am pretty sure we also have plenty of stuff you can dig into.

If you want to fool around with the data, if you think you can develop a better model for calculating the ratings or you just want something to play around with, the entire database is free to download here with an explanation of the fields here

Thanks and shoutouts to: SC2charts.net, TLPD, Wax, Kaelaris, all the great people who use the site and suggest improvements, Eivind, Tom, Otolia, Conti and especially all the people behind Liquipedia because that shit has been GOLD when tracking and arranging old matches.

-Grovbolle

***
Lies, damned lies and statistics: http://aligulac.com
Paljas
Profile Joined October 2011
Germany6926 Posts
April 18 2013 22:20 GMT
#2
Aligulac is easly one of the coolest projects right now.
One question: what exactly is TheBB doing?
He didnt list himself in this thread: http://www.teamliquid.net/forum/viewmessage.php?topic_id=404035
TL+ Member
StarVe
Profile Joined June 2011
Germany13591 Posts
April 18 2013 23:46 GMT
#3
Oh, so much fun to miss out on! Y'all are doing great work, don't let the stubborn weirdos get you down in the update threads!
MCXD
Profile Blog Joined February 2012
Australia2738 Posts
Last Edited: 2013-04-18 23:51:27
April 18 2013 23:49 GMT
#4
On April 19 2013 07:20 Paljas wrote:
Aligulac is easly one of the coolest projects right now.
One question: what exactly is TheBB doing?
He didnt list himself in this thread: http://www.teamliquid.net/forum/viewmessage.php?topic_id=404035


I would assume he's the project manager in general, and also the one who does most of the mathematical/modelling leg-work?
alQahira
Profile Joined June 2011
United States511 Posts
April 19 2013 02:12 GMT
#5
I love Aligulac. Thanks for all your hard work!
Grovbolle
Profile Blog Joined July 2011
Denmark3805 Posts
Last Edited: 2013-04-23 06:27:05
April 19 2013 06:46 GMT
#6
On April 19 2013 07:20 Paljas wrote:
Aligulac is easly one of the coolest projects right now.
One question: what exactly is TheBB doing?
He didnt list himself in this thread: http://www.teamliquid.net/forum/viewmessage.php?topic_id=404035

He does a lot, obviously he started the site, so he built the initial site and scraped Sc2charts for matches, he built the database. He is responsible for around 14 % of the manually added matches, he scraped TLPD, he built the hierarchial model and he programs a lot of the new features etc. He also takes requests from me and the others on stuff we would like. Finally he is responsible for all the math behind the model, he experiments with different model setups to try to optimize the likelihood rating etc.

So to sum up:
He programs a lot.
He does a lot of the manual work, like adding matches, players, events etc.
He does all the math behind the site.
Lies, damned lies and statistics: http://aligulac.com
Kaelaris
Profile Blog Joined September 2010
United Kingdom788 Posts
April 19 2013 10:47 GMT
#7
<3 Good content (P.S. I love statistics) deserves retweeting kk!
CommentatorESL Commentator ♞ Facebook.com/Kaelaris ♞ Twitter.com/Kaelaris ♞ Youtube.com/Kaelaris ♞ Twitch.tv/Kaelaris
PhoenixVoid
Profile Blog Joined December 2011
Canada32740 Posts
April 19 2013 16:26 GMT
#8
Proud to be part of this great project
I'm afraid of demented knife-wielding escaped lunatic libertarian zombie mutants
Wintex
Profile Blog Joined July 2011
Norway16838 Posts
April 19 2013 16:45 GMT
#9
I'll be brief: Aligulac is awesome and you should all be proud.

(PS: Keep Bomber in the top 10 and I'll love you long time).
The Bomber boy
FrodaN
Profile Blog Joined October 2010
754 Posts
April 22 2013 21:24 GMT
#10
you guys should be very proud of your work thx for your contributions!!!
m0ck
Profile Blog Joined November 2010
4194 Posts
May 13 2013 23:48 GMT
#11
Just came by this, and I suppose you, Grovbolle, is the main twitter man.

Som jeg skrev der, tak for jeres arbejde, det er imponerende hvad I har nået på så kort tid. Jeg vil også sige dog, at jeg synes I snyder jeg selv, når I ikke inkluderer maps i jeres database. Jeg forstår at det ville være et uoverkommeligt arbejde at indkorporere det i den eksisterende database, men I burde virkelig overveje at gøre det fremadrettet.

God vind!
slowbacontron
Profile Joined October 2012
United States7722 Posts
May 14 2013 06:57 GMT
#12
I emailed TheBB once asking about volunteering but unfortunately I never actually followed up on that. I still think I can try to help, though! (Just not good with email) How should I get into this?
jjakji fan
Waxangel
Profile Blog Joined September 2002
United States33339 Posts
May 14 2013 15:00 GMT
#13
rock on, stats bros
AdministratorHey HP can you redo everything youve ever done because i have a small complaint?
Grovbolle
Profile Blog Joined July 2011
Denmark3805 Posts
June 12 2013 20:11 GMT
#14
On May 14 2013 08:48 m0ck wrote:
Just came by this, and I suppose you, Grovbolle, is the main twitter man.

Som jeg skrev der, tak for jeres arbejde, det er imponerende hvad I har nået på så kort tid. Jeg vil også sige dog, at jeg synes I snyder jeg selv, når I ikke inkluderer maps i jeres database. Jeg forstår at det ville være et uoverkommeligt arbejde at indkorporere det i den eksisterende database, men I burde virkelig overveje at gøre det fremadrettet.

God vind!

(I'll keep it in English if there are more people who want to read it )
Yes maps are the biggest feature to implement, however, as it is right now, we have all agreed that implementing it will be almost impossible. Unless you choose to just do it "forward", at which point it will still be useless for many months to come.

Lies, damned lies and statistics: http://aligulac.com
Please log in or register to reply.
Live Events Refresh
Next event in 6h 4m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
Nina 270
ProTech58
Ketroc 43
StarCraft: Brood War
Leta 471
Shine 105
Mind 40
Snow 33
Bale 3
Dota 2
monkeys_forever1278
Counter-Strike
Stewie2K1423
Super Smash Bros
Mew2King137
Other Games
summit1g8860
ViBE214
Maynarde58
SortOf9
Organizations
Other Games
gamesdonequick35237
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 17 non-featured ]
StarCraft 2
• Berry_CruncH298
• Hupsaiya 60
• practicex 29
• Kozan
• AfreecaTV YouTube
• intothetv
• sooper7s
• IndyKCrew
• LaughNgamezSOOP
• Migwel
StarCraft: Brood War
• Azhi_Dahaki40
• Diggity6
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
League of Legends
• Lourlo1274
• Rush1035
Upcoming Events
Wardi Open
6h 4m
Replay Cast
19h 4m
Sparkling Tuna Cup
1d 5h
WardiTV European League
1d 11h
MaNa vs sebesdes
Mixu vs Fjant
ByuN vs HeRoMaRinE
ShoWTimE vs goblin
Gerald vs Babymarine
Krystianer vs YoungYakov
PiGosaur Monday
1d 19h
The PondCast
2 days
WardiTV European League
2 days
Jumy vs NightPhoenix
Percival vs Nicoract
ArT vs HiGhDrA
MaxPax vs Harstem
Scarlett vs Shameless
SKillous vs uThermal
uThermal 2v2 Circuit
2 days
Replay Cast
2 days
RSL Revival
3 days
ByuN vs SHIN
Clem vs Reynor
[ Show More ]
Replay Cast
3 days
RSL Revival
4 days
Classic vs Cure
FEL
4 days
RSL Revival
5 days
FEL
5 days
FEL
5 days
Sparkling Tuna Cup
6 days
RSL Revival
6 days
FEL
6 days
Liquipedia Results

Completed

BSL Season 20
HSC XXVII
Heroes 10 EU

Ongoing

JPL Season 2
BSL 2v2 Season 3
Acropolis #3
KCM Race Survival 2025 Season 2
CSL 17: 2025 SUMMER
Copa Latinoamericana 4
Jiahua Invitational
Championship of Russia 2025
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

Upcoming

2025 ACS Season 2: Qualifier
CSLPRO Last Chance 2025
CSL Xiamen Invitational
2025 ACS Season 2
CSLPRO Chat StarLAN 3
K-Championship
uThermal 2v2 Main Event
SEL Season 2 Championship
FEL Cracov 2025
Esports World Cup 2025
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
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.