I know it's been a while since I've last posted something, and I apologize for that. My job leaves very little time for stuff like this, but I've been fairly motivated by recent events - namely my 12-year Internet service provider starting to really suck - to take inventory of the websites I run, and what I need to do with them.
So I came across this tweet today:
Folks with MSDN? Activate your free Azure credits (*no CC required*) and win an Aston Martin: http://t.co/iEtEsPXk25 — Scott Hanselman (@shanselman) July 2, 2013
While the concept of winning an Aston Martin is appealing in its own right, what interested the geek in me was the fact that MSDN subscribers actually have free Windows Azure credits. Azure is basically a hosting service with a lot of bells and whistles. I checked and saw I get $100 per month credit, and started poking around to see what I can do. I've got a VM with Windows Server and SQL Server up, and am starting to look into experimenting with getting my pet project that has long since been ignored, Cheevos FTW!, up and running on Azure to see how much it'll cost, and how well it performs.
Well, then I got into the small problem that the database for Cheevos is pushing 200 GB. Yikes. I figure that since I have over 6 million characters logged with their achievements, I can afford to cut back some, but that'll still make for a fairly large database. So the plan is to split the database into two pieces. One piece would have the summary data - which runs under 1 MB - and would reside on Azure while the big piece would still be stored here. I'll periodically update the summary data on the server using some kind of API call that will update the database. Meanwhile, when a player enters their character name on Azure, it'll use the API to retrieve their data and compare it to the summary data and store who it loaded. Then I'll download that data back to the big database and crunch the summary numbers periodically. In theory, it sounds kind of smooth.
In practice, there's a lot I need to change about Cheevos to speed it up some, and hopefully this pass over it will give me the opportunity to get that site speedy again.
The next site to go over would most certainly be roncli.com, but that still has a LOT of work left on it before it's even ready for prime time. I've been flopping over whether to launch with just pages and the blog, or if I should wait until I have the music and gaming sections going as well. With the time I've been having lately, though, it's looking less likely that it'll be launched in a reasonable time frame, and by then I'll probably need to reboot the website all over again for a third time. Perhaps I need to just find a way to make time to work on all of this, but I don't see that happening in the near future.
This is my blog where I give my thoughts and opinions on various topics and share my creative endeavors with the world. I run two personal blogs, but combine them here for ease of access.
Blogger - My oldest blog using the Blogger platform contains posts full of opinions, gaming, and code.
Tumblr - Tumblr posts are all about my creative side, containing music, videos, writings, and updates on my web creations.
You can select a category below to view the latest post, or browse thorugh the posts using the navigation found at the top and bottom of each post.
In California, truck license plates are 7 characters, all numbers except for one letter in either the second or the sixth position. Whenever that letter is an X, I get nerd snipped into treating it as a multiplication problem and solving it in my head.
we should have paid more attention to the cats who, for decades, put their bodies on the line to walk on keyboards and sit on laptops and prevent us from programming
Former 2 time world champion DogPlayingTetris becomes the first player to ever rollover the level counter in NES Tetris, performing what's known in the community as "Rebirth". Final score: 29,486,164, 4216 lines, level 347 (256 + 91)... all huge world records. #tetris
I'd also love a 6 hour layover overnight instead of taking the red eye I was going to take and be 7 hours later getting into Cleveland than I wanted, why do you ask? #airporthell
Why yes, I'd love to leave at 4:40 to get to the airport at 6:20 for an 8:20 flight that got delayed to 9:05 which is too late for my connection so now I'm on a 10:20 flight instead. Why do you ask? #airporthell
@shanselman Who at Microsoft do I have to bribe to fix ADO so that those of us on dark mode who copy/paste text from one task to another can do so without our friends on light mode seeing dark text on a dark background?
I updated the blog post with a statement from Revival. While I'm not particularly happy with Revival's decision, I understand their motives. It's just a shame that it was someone from Interplay that had to go and do this. "By games for gamers" my ass.
Damn, got another Tetris world record! This time in the arcade variant developed by Atari. 6,008,005 points, 5,386 lines, round 363. Be warned, it's nearly FIVE HOURS. https://www.twitch.tv/videos/2131759212