-
Last night a DB saved my life (Part 2)
Following on from my last post about what DuckDB makes possible, here’s a little more detail about how this works in practice… Installing DuckDB There are two ways to use DuckDB: via the Command Line (CLI/Terminal), and via a library for whatever language you’re programming in. I tend to use the CLI more intensively while…
-
Installing PostgreSQL Extensions on Mac OS X
I’ve been making a lot of use of PostgreSQL and PostGIS for working with geo-data over the past year and, having finally gotten over my hatred of the non-standard administrative commands, I am seriously impressed with what this setup makes possible. Even on a MacBook Air with just 8GB of RAM! However, one area where…
-
Hex Binning Land Registry Data
One of the known problems with choropleth maps is that small zones, even if they contain very significant values, tend to get lost in amongst much larger zones. A current example is that the ridings in London are much smaller than those outside of London, so it can be hard to tell what’s happening in…