Linode Notes – Basic Setup

Buy a Linode plan For location, Tokyo is not available now, and I choose Newark based on speed test (rather than Fremont). Getting started Ref: Getting Started with Linode Deploy…

Continue Reading Linode Notes – Basic Setup

psycopgr: Routing in Python

I am introduing  psycopgr, a Python wrapper of pgRouting written by me. What is psycopgr As said in pgRouting docs: Just considering the different ways that the cost can be…

Continue Reading psycopgr: Routing in Python

pgRouting Notes

Install PostGIS and pgRouting On Mac The following will install pgRouting and its dependencies including PostGIS, and PostgreSQL if not installed: brew install pgrouting On Linux (to add) Install osm2pgrouting…

Continue Reading pgRouting Notes

PostgreSQL Notes

Official Documentation and Tutorial Install and run Mac brew install postgresql Make sure that brew service is installed brew tap homebrew/services Start PostgreSQL as a background service: (will start automatically…

Continue Reading PostgreSQL Notes