2019-10-17

Generating land-constrained geographical point grids with PostGIS

postgis software postgres

Demonstrates how to generate geographical point grids constrained to land areas using PostGIS, applied to visualising EV range on maps.

2017-11-02

The case against ORMs

software databases postgres architecture

Argues against using ORMs based on accumulated experience, focusing on ORMs that attempt to reimplement SQL rather than lightweight database helper libraries.

2017-09-29

Four levels of time handling in a database

software databases postgres architecture

Breaks down database time handling into four complexity levels, from basic date storage to advanced temporal data management, based on experience working with PostgreSQL time features.

2017-09-18

Debugging complex PostgreSQL queries with pgdebug

software databases postgres

Explores debugging techniques for complex PostgreSQL queries, introducing pgdebug as a debugging tool.

2017-02-19

Writing readable SQL

software databases postgres

Shares techniques for writing readable SQL queries, particularly useful for complex 100+ line queries written without ORMs.

2014-11-18

Visualising PostGIS data from the shell

postgres postgis

Explores methods for quickly visualising PostGIS query results from the command line, addressing the lack of convenient tools for ad hoc spatial data exploration.

2013-11-11

Installing PostGIS with Homebrew

software mac postgres postgis

Step-by-step instructions for installing PostGIS using Homebrew on macOS, since official documentation didn't cover this method.