By Phil Whelan on December 15, 2011
Geohashing is a simple way to encode latitude and longitude and grouping nearby points on the globe with varying resolutions. It was created by Gustavo Niemeyer. This blog post looks at how it’s implemented any why it is such an elegant solution for encoding and managing location-based data.
Posted in Geospatial | Tagged clojure, geo, geographic, geohash, geospatial, java, javascript, key-value, location, maps, memcached, nearest neighbour, perl, python, ruby, scala, search |
By Phil Whelan on December 13, 2011
Last week I attended a presentation by James Golick, CTO of fetlife.com. Intriguingly advertised as “Scaling a Website to 300 Million Page Views Per Month with Scala” I thought it was worth a break from building cooq.com to attend. Fetlife have been heavy users of Ruby, but are transitioning to Scala and having been using [...]
Posted in System Administration, Web Development | Tagged a-b-testing, averages, capacity planning, degrade, fetlife, ganglia, metrics, monitoring, percentiles, redis, rollout, ruby, scala |
By Phil Whelan on January 18, 2011
In this blog post I will introduce SQLShell and demonstrate, step-by-step, how to install it and start using it with MySQL. I will also reflect on the possibilites of using this with NoSQL technologies, such as HBase, MongoDB, Hive, CouchDB, Redis and Google BigQuery.
SQLShell is a cross-platform, cross-database command-line tool for SQL, much like psql for PostgreSQL or the mysql command-line tool for MySQL.
Posted in Databases | Tagged clapper.org, couchdb, google storage, hbase, hive, homebrew, jdbc, mongodb, mysql, nosql, oracle, postgresql, psql, rdbms, redis, scala, sqlcmd, sqlite, sqlshell |
