webdevRefinery Forum: Koen - Viewing Profile - webdevRefinery Forum

Tomorrow the last season of HIMYM starts and I was wondering what you guys are expecting (and hoping) from this season. Obviously we'll learn who... this should be in spoiler tags.


I'd like to ask everyone not to post any spoilers in the open, because some of us have to wait for a download to become available

I'm working on an Hydrogen application allowing the user to search to a list of items fetched from some APIs. Problem is, these lists I'm fetching are pretty large (a few MB each). And I wouldn't want to use that much bandwidth everytime a user loads the page. So caching is the way to go.

The Steam API allows If-Modified-Since headers and I'm pretty sure Google's spreadsheet API does so as well. So I should definitely be taking advantage of that when loading the files. But I don't want to parse the data again every time the page is loaded either. I prefer to parse the data only when it's fetched from the servers and then store it in a database for later access.

The data doesn't get updated very often, probably once a week, but I don't want people to wait for the data to update on my site. Should I be checking if the data is still up to date every time the page gets loaded? Or should I wait for a while before checking again, either using a cron job or just when a user visits the page and the time has passed?

I'm also not sure if the data will be consistent, if an item gets removed, it'll have to be removed from the database as well. I can only come up with one way to do that, deleting everything in the table and repopulating it again, but I'm not sure how reliable that is.. What if something goes wrong during the repopulating or parsing and the database remains empty?

Lots of rambling, I hope someone's able to understand what I said and help me!

I figured I'd make a new thread for this, didn't want the Google I/O topic to get cluttered.

I want to buy a new smartphone to replace my iPod Touch and ancient phone. I'm looking for an Android phone with a slick design, which can run the new operating systems (Ice Cream Sandwich, Jelly Beans and a while into the future). A proper screen is very important, because I got way used to my retina screen.

Some phones I am considering are Google Galaxy Nexus and HTC One X.

Can you guys please help me pick a phone?

Valve just started their update series leading to Meet The Pyro. You can check it out on http://tf2.com They did some pretty fancy graphics for some of the pages.