PostgresSQL

Skill level
2 Previously Proficient

In 2010, at FyteComm, I used the PostgresSQL DBMS with the PostGIS extension for managing points, lines and regions where PostGIS could calculate region centroids and min/max extents, find line, point and region intersections, find the union of two regions, export region data as geoJSON, as-well-as speed up geo-queries by using optimized tree-search indexes. It was used in conjunction with customer data such as property tax data (i.e. owner, address, property lines, assessed value, zoning, etc). I just had to learn the PostGIS extension API combined with fairly standard SQL queries to use this database. I just did the normal single-server deployment pretty much out of the box and didn't worry too much about performance optimizations as our customer base wasn't that large.

Experiences using this skill are shown below: