PostgreSQL
Geolocation with PostgreSQL
We have loaded Open Street Map points of interests in the article The Most Popular Pub Names — which compares PostgreSQL with MongoDB for simple geographical queries, and …
tag
Geolocation
6 posts
PostgreSQL
PostgreSQL Data Types: Point
Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL Point type. In order to put the Point datatype in a context where it …
Projects
Loading Geolocation Data
As I’ve been mentionning in the past already, I’m currently rewriting pgloader from scratch in Common Lisp. In terms of technical debt that’s akin to …
PostgreSQL
How far is the nearest pub?
In our recent article about The Most Popular Pub Names we did have a look at how to find the pubs nearby, but didn’t compute the distance in between that pub and …
PostgreSQL
The Most Popular Pub Names
In his article titled The Most Popular Pub Names Ross Lawley did show us how to perform some quite interesting geographic queries against MongoDB, using some nice Open …
PostgreSQL
Nearest Big City
In this article, we want to find the town with the greatest number of inhabitants near a given location. A very localized example We first need to find and import some …