[Book “Learn PostgreSQL”] I started the chapter about triggers and rules. Both seem to be very powerful tools. I can see how they enable for example denormalization. I am still curious about maintainability. Let’s say table A is replicated to table B. If table A changes it’s schema it should be recognised by a linter and force programmer to update the trigger as well. I don’t want to relay on integration tests to catch these kind or inconsistency errors.
[GADM-api] Yesterday evening I added level 1 /geojson endpoint. I am still not happy with all code duplication – even after abstracting header setters and query parameter parses. Also I need to create an automation for dev server re-lunch on file save.