Mindblown: a blog about philosophy.
-
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…
-
2025/07/13 [Learn Postgres]
Physical replication relies on the concept of streaming WAL segments from primary node to a replica node. The replica is in the state of continuous recovery – it continuously execute WAL segments received from primary node.In Synchronous replication primary node ensures replica received WAL segments before completion, while in asynchronous mode WAL segments are streamed…
-
2025/07/12
Still working on a rate limiter. I think I am getting there. This will be a good moment to introduce unit tests.
-
2025/07/12 [Learn Postgres]
I was mainly writing down notes about Postgres configuration. I have started reading about physical replication but I will include the notes about this chapter later.
-
2025/07/11 [Learn Postgres]
I completed the configuration & monitoring chapter. Postgres allows configuration modifications while cluster runs by means of ALTER SYSTEM command. Modifications applied this way will be appended to postgresql.auto.conf file.You can use configuration generators like PgConfig with simple GUI interface.Information about running queries, sessions and backend processes can be read from pg_stat_activity catalog. Information about…
Got any book recommendations?