[Book “Learn PostgreSQL”] I finished chapter about partitioning. I learned about table inheritance and declarative partitioning types. The chapter covered three partitioning strategies – by range, by list and by hash. Unfortunately the examples covered only list and range. The book didn’t cover how to manage partitioning programmatically which is disappointing considering that range partitioning example would require adding partitions-by-month manually for every month. I found the “partitioning and tablespaces” section interesting but bit too brief.
[GADM-api] Good progress today. I created nice abstraction for the geojsonl streaming endpoint. This allowed me to generate urls and handlers for all GADM levels. Next step is to do the same for feature-collection handlers.