Monthly Archives: August 2017

Fun with golang, Google Maps api, and proxying requests

I admire published api code that is thoroughly thought through. Recently I have been working with the Google Maps API in golang and have found that they set it up to allow one to pass in an net/http/client variable which means that it is possible to create a http client which sends the requests via […]

Read More

Recursive common table expressions (CTE) for arbitrary depth hierarchies

The challenge of storing an arbitrary depth hierarchy isn’t so much with the storing of it as it is with the querying it and rendering it in a useful fashion. Given a simple hierarchy stored in a table that has a self-referential parent_id such as: With some sample data: We can extract the data: Which […]

Read More