[Book “Learn PostgreSQL”] Going deeper into MVCC, WALL and isolation levels definitions and explanations.
[GADM-api] I started working on “next page url” header. I considered few approaches and settled on the one that balances complexity, maintainability and performance. I will create a separate query that selects FID column offset by page size. This way I am not querying an redundant row together with it’s geometry but also I am keeping GeoJSON query dedicated to it’s main purposes instead of mingling it together with pagination stuff. It is an extra round trip for db but it should be fine for now.