After several months of trialling Google’s new Cloud SQL service we’re hugely pleased to have recently taken Do Something Near You out of beta with the addition of enhanced geo-spatial searches (find listings near to my entered location) and a new search by keyword feature.
Originally leveraging Google App Engine’s awesomely scalable (but not without limits) traditional NoSQL data-store, geo-spatial queries had restrictions that meant we had to implement work-arounds to achieve the results we needed from the volumes of data that were quickly amassing. Whilst these work-arounds (namely GeoModel, but also some complex custom caching mechanisms) delivered results, we still weren’t able to search by keyword and performance could have been better, especially considering the expectation we had having chosen Google (the fastest search engine ever) as our infrastructure provider.
Implementation was a little tedious at first, as Cloud SQL was in “Experimental” (and didn’t it feel that way) release when we first developed the prototype, but once it was released commercially it has been smooth sailing even under load. Performance improvements were dramatic, shaving response times by more than 50% on most local search requests.
For the technical amongst you, this video below, filmed at Google I/O, debates Cloud SQL vs traditional data-store, where inequality operators on multiple fields is simply not possible. The critical component of both solutions is the cloud nature which offers two primary advantages. Database maintenance becomes a thing of the past while at the same time it allows scaling to huge volumes of data and usage without needing the ridiculous capital expense of traditional servers and networking hardware.
Cloud hosting is old news, right? Well almost, but the idea of storing a backup of our file system in the cloud is a relatively new one, at least here in Australia. Thankfully as bandwidth and hosting costs come down the idea of offline backups is finally becoming a reality for many too.
We’ve recently explored a few of the more business focused options, read on for our findings. Continue reading →
I stumbled on this one afternoon while walking the cloud. Great colours – yes, the saturation may have been slightly enhanced.
As many of our clients know, Code4 survived until recently with what can be described as a minimalist website. Thankfully most of our business is word of mouth so this didn’t impact too greatly although something had to be done. We had been busy making some great sites so it was time to show them off. After realising that our new brand was going to take longer than we’d planned we knew it was time to get out and launch something. We hope you enjoy it. Don’t forget to sign up to our newsletter to stay in the loop.