LogBook

Category: Thread

  • 2025/06/26 [GADM-api]

    Working from the office always interrupts the morning routine nevertheless I still managed to make small progress today. I continue working on “next url” feature. I need to introduce a structured way of building api urls.

  • 2025/06/26 [Learn Postgres]

    Wrapped up sections about WAL and checkpoints. Tomorrow I will finish VACUUM section and I will be ready to write a proper summary about this chapter.

  • 2025/06/25 [Learn Postgres]

    Going deeper into MVCC, WALL and isolation levels definitions and explanations.

  • 2025/06/25 [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…

  • 2025/06/24 [Learn Postgres]

    [Book “Learn PostgreSQL”] The transaction chapter is the most interesting so far. It expands on the things I already learned from “Designing Data Intensive Application”. I try to write a summary of this chapter once I am done with it. It will cover most interesting topics like:– transaction identifiers (xid) and the wraparound problem– MVCC…

  • 2025/06/24 [GADM-api]

    Today I am celebrating a full week of daily updates! I implemented all feature collection handlers. However I will need to polish and refine some parts. I think the structure and file management is mostly good but small improvements will make it more maintainable.

  • 2025/06/23 [GADM-api]

    Today I did only a tiny progress because of an early morning doctors appointment :(. I am still happy that I didn’t skip the day completely. Small progress on abstracting feature collection endpoint handlers

  • 2025/06/23 [Learn Postgres]

    I started reading about transactions but without taking notes. I will write them down tomorrow

  • 2025/06/22 [Learn Postgres]

    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…

  • 2025/06/22 [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.