Daily News - 22nd November 2021
Hello Silly Entities!
Time for another daily news.
Captain's Log #
Last night I did another 100 races to finish at 300 again. I had nothing better to do while launching the new stat system hehe.
Today I've done and probably will only stop at 100 races. Back to being slow again wah... I'm also super tired today from the 3am sleep last night.
Website Work: New Stats System Part II #
A recap from last night... launched stats, tried to avoid "maintenance page". It was mostly going well... but thanks to my unconventional launch technqiues:
- Forgot to run another database query to remove an unused column, breaking the stat collections
- Didn't review my SQL code... apparently I was still using the old schema with the calculate point feature oops hehe; (that's what happens when you don't delete old tables)
I stayed up til 3am to resolve those issues. I hope there wasn't anything else broken hmm... I just know my race count on it is correct hehe.
Some further updates to come #
The next tasks will be to:
- Do another DB audit and optimize the stat load... but I think it's alright, so I'll just implement some cache
- Add some concurrency on stat collection (not sure if it's suitable against the hosting service though hmm)
- Denormalize the user database a bit... have a team history date range to improve some speed and simplify my cringe SQL code hehe
- Review stat collection times; I was advised on a specific collection range based on observations
Stats for All #
I don't plan to branch off my Folly Times stats. It's setup a bit too complex for my personal use hmm. Instead I'll probably start from scratch and stick with simplier stack like MongoDB for the database. I'm hoping all those can be hosted for free somewhere.
Although I haven't scheduled when I'm doing this though.
Competition - Blitz #
Congratulations to the winners:
🥇 1st -KenK- (154 races!) wins 700k + 1 million bonus
🥈 2nd ack! (151 races!) wins 300k + 1 million bonus
🥉 3rd anarchano (100 races!) wins 200k + 1 million bonus
🎖️ 4th Spooky Pumpkin (52 races!) wins 200k
🎖️ 5th xiaobenjixpro (50 races!) wins 100k
GGs. That's all folks with the Step Up event hehe.
Visit here to see the results and start and end date.
Team Update #
Haven't checked the Last 24 hr count, probably same same hmmm.
Step Up Week Ended #
Thank you to the winners that had stepped up today and won the 1 Million bonus! Even though it didn't fare so well with our daily grind, it's better than feeling like I was doing the races by myself.
Next Event Coming After New Season #
I'm thinking of doing another event when next season starts. Not sure when, but it'll be around December I think. My aim will be to do something a bit better than Spooky Comp or keep that format.
Another Gold Comp might be in the prize pool, so stay tune. More to come hehe.
Until next time!
- Silje P. Entidy