LogBook

Mindblown: a blog about philosophy.

  • 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.

  • 2025/06/21 [Learn Postgres]

    I finished chapter about triggers and finally moving on to more interesting topic – Partitioning. The “Triggers” chapter was mainly a dry walkthrough the synopsis. I think I was missing theoretical explanation of how triggers work under the hood.On the other hand “Partitioning” chapter starts with types of partitioning (range, list, hash) – which makes…

  • 2025/06/21 [GADM-api]

    I refined logging mechanism and messages. I added severity levels (DEBUG, INFO, WARN, ERROR) and introduced middleware that logs each request. Also I installed the air package that re-builds and runs my server when I modify files.I discovered I can use Caddy for rate limiting. It seems very easy to setup and will save so…

  • 2025/06/20

    [Books backlog] The backlog of things I want to read is getting longer and longer. I stumbled upon several interesting books and I need to decide which one to pick up next. I am thinking about “Refactoring”, “Code Complete”, “The Staff Engineer’s Path” and “The Software Engineer’s Guidebook”. First two are kind of old and…

Got any book recommendations?

Get In Touch