[Book “Learn PostgreSQL”] – Moving on with “Learn PostgresSQL”. Today I went through a major part of “Server-side programming” chapter, including data-types (hstore, json, jsonb, dates and time) and writing functions with SQL and PL/pgSQL.
Functions in database seem interesting, I can foresee certain use cases. However they also seem like a serious maintenance effort. Perhaps they require integration tests or special type checking system. They might also require special deployment system – e.g one that deploys them always (create or replace) instead only during migrations.
[GADM-api] I am working on abstracting my queries with squirrel package. I need to find a reusable and scalable approach before I will move on with next endpoints. At the moment I have two endpoints – one that returns FeatureCollection and one that streams new-line delimited GeoJSON. The second one will require extra abstraction for streaming functionality.