LogBook

Category: Thread

  • 2025/07/18 [GADM-api]

    In this time I read 700 page Postgres book and progressed on my side project – GADM api service. Today I finalized new endpoint that will allow me to create new access tokens. This endpoint has restricted access, only admin users can call it. I think the next step will be to finally setup new…

  • 2025/07/17 [Learn Postgres]

    Hooray! I finished reading “Learn PostgreSQL” book – a 700 page brick 😉 It took over a month of waking up at 6am reading, making notes in my notebooks and summaries on this blog. I was exposed to many new concepts and feature of Postgres that I was not familiar with before. Now I am…

  • 2025/07/17 [GADM-api]

    I started working on a new endpoint that will allow to create new access tokens. This requires a database migration. I added can_generate_access_tokens permissions to admin user. Now all I need to do is finish the endpoint handler. It will ensure the caller has appropriate permissions and valid token, then it will create new token…

  • 2025/07/16 [Learn Postgres]

    I finished the logical replication chapter and started the last chapter of the book – useful extensions.Postgres provide replication monitoring utilities – it’s the same table that monitors physical replication – pg_stat_replication table. You can also get more information about publishing and subscribing processes by querying pg_publication and pg_subscribtion tables on primary and replica nodes…

  • 2025/07/16 [GADM-api]

    I am getting close to a full month of daily updates. This means I have 30 logbooks entries. This means that I will soon need to refine how this blog queries them. In other words I need to provide pagination and search capabilities. For the moment my plan is to leverage WordPress integration with GraphQL.…

  • 2025/07/15 [Learn Postgres]

    Postgres logical replication relies on pub/sub mechanism. Primary node decodes WAL segments and extrapolates SQL queries from them, then it publishes the commands while replica node subscribes to it and passes received queries directly to query executor. Logical replication:– is a bit slower then physical replications– allows replication across Postgres versions– allows selective data replication…

  • 2025/07/15 [GADM-api]

    I added first token expiration unit test.

  • 2025/07/14 [GADM-api]

    I started working on unit tests for access token caching mechanism.

  • 2025/07/14 [Learn Postgres]

    The remaining part of the chapter about physical replication consisted mainly of a walk-through the replication setup steps. It is recommended to replicate clusters on machines with the same hardware parameters – this way replicas can reuse configuration from primary node without risk of running out of resources. Having multiple replicas can put too much…

  • 2025/07/13 [GADM-api]

    I finished the access token cache and rate limiter. It turned out to be more complex that I anticipated. There are a lot of caveats related to concurrent access to the cache and locking. I am new to the concept of mutexes so I can have a bind spot for potential issues. Because of that…