Trying a Python R-tree implementation
Rtree is a ctypes Python wrapper of libspatialindex that provides a number of advanced spatial indexing features for the spatially curious Python user.
Difficulty 3 · Intermediate
Difficulty level 3 of 5: Intermediate
Having a look at Spacebase
Spacebase is a spatial datastore that began life as military-grade software, which at least sounds kind of cool. It’s an in-memory database, really, so switch off the cluster and the data is gone. Apparently the same thing was (unknown to…
Giving KyotoCabinet a go
Install KC: wget tar xzvf kyotocabinet-1.2.76.tar.gz cd kyotocabinet-1.2.76 ./configure && make && make install # takes a couple of minutes
Having a look at LevelDB
Note: It is worth noting that (the way I interpret it) one of the authors of LevelDB (Sanjay) recommends using TokyoCabinet if the workload is more read-oriented. In turn the TokyoCabinet authors recommend using KyotoCabinet :-) (see video with a…
Deploying a Tornado project in production using Github and WebFaction.
In the following I’m using a server from Webfaction, and my Tornado source code is hosted on Github. Some things are specific to those providers, but should be very easy to adapt. The following is organized into two sections.
Optimizing nginx performance
Found these links that have valuable tips for achieving nginx performance: I’ll try to benchmark before and after with ab and post the results here.
Installing nginx on Mac with pcre library
To build nginx on Mac OS X Snow Leopard, I use the following options to configure ./configure –with-ld-opt=”-L/usr/local/lib” –with-cc-opt=”-I/usr/local/include” If the ld and cc options are not given, it results in an error reported in a ticket on the nginx…
Simple Rest API for storing “point” observations
Database stuff First I’ll describe the database that backs the service. PostGIS database backend Here is how to make a simple table in PostgreSQL, that can store geo-tagged “observations”. It uses a hstore type for key-value pairs and a geography…
Reading diary August 28, 2012
I’m keeping public track of what I read. Today I read three papers using the three pass method. First pass I did a first pass over two papers on distributed file systems. Both papers are by authors Sage A. Weil,…
Examples of querying a OSM PostgreSQL table with the hstore tags column
I have found some tutorials (1 and 2) for using the hstore column type in PostgreSQL. This blog post is specific to querying OpenStreetMap data using the tags column in relations ways and nodes (the tags column is a hstore).