I am celebrating today 30 days for waking up at 6am and working on self developement! [Book “Learn PostgreSQL”] Toady finished the part about parallel workers. I could not spend the usual amount of time on the book because of the trip to the office. I hope to cover more tomorrow when I will start […]

[Book “Learn PostgreSQL”] The “query tuning” chapter is great. I already learned a lot about Postgres planner and optimizer, execution stages (parsing, rewriting, optimization and execution), cost-based optimization and sequential nodes – sequential scan, index nodes and nested loops. Tomorrow I will start with parallel nodes! [GADM-api] I did serious progress on filtering results by […]

Hello July! [Book “Learn PostgreSQL”] I finished my notes about VACUUM and therefore the “transactions” chapter itself. Also, I browsed over the “extensions” chapter. I was interesting to learn about the pgxn and pgxs tools for extensions management. However the rest of this chapter won’t be very useful to me. But I am happy to move […]

My trip to Poland over the weekend put in test my daily habits. Nevertheless I managed to do at leas a small progress every day. Tomorrow I am back to waking up at 6am and focusing on personal development early in the morning. It’s important to make at least a small progress every day, especially […]

I managed to progress the gadm-api project a bit when I was flying back to Amsterdam today. Otherwise it is very difficult to keep the habit of daily updates when traveling. The progress on the Postgres book had to be paused since traveling with 700 page book is very inconvinient. [GADM-api] I started working on […]

I had to travel to Poland today therefore I haven’t got time to progress on Postgres book. [GADM-api] – I finalized a rough version of “next url” header. It works only when ordering by fid column which is not great but will do for now. I need to test if it will work when filtering […]

[Book “Learn PostgreSQL”] I am still writing down notes on “Transactions” chapter. [GADM-api] I added a structured approach for url creation and did some progress on “next url” feature. Also I unified the wording around pagination.

Working from the office always interrupts the morning routine nevertheless I still managed to make small progress today. [Book “Learn PostgreSQL”] 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. [GADM-api] I continue working on “next url” feature. […]

[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 […]

Today I am celebrating a full week of daily updates! [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 […]

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. [GADM-api] Small progress on abstracting feature collection endpoint handlers [Book “Learn PostgreSQL”] I started reading about transactions but without taking notes. I will write them down tomorrow

[Book “Learn PostgreSQL”] 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 […]

[Book “Learn PostgreSQL”] 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) […]

[Book “Learn PostgreSQL”] I started the chapter about triggers and rules. Both seem to be very powerful tools. I can see how they enable for example denormalization. I am still curious about maintainability. Let’s say table A is replicated to table B. If table A changes it’s schema it should be recognised by a linter […]

[Book “Learn PostgreSQL”] I finished the chapter about postgres functions. I feel the syntax is quite cumbersome and I can’t find a good use-case for them now. I imagine they will come handy when combined with triggers or cron jobs. I am looking forward to next chapter about triggers. [GADM-api] I refined how pagination parameters […]

[Book “Learn PostgreSQL”] – Moving on with “Learn PostgresSQL”. Today I went through a major part of “Server-side programming” chapter, including data-types (hstore, json, jsonb, dates and time) and writing functions with SQL and PL/pgSQL. Functions in database seem interesting, I can foresee certain use cases. However they also seem like a serious maintenance effort. […]