Robert Rode


Personal blog about coding, energy and data engineering.


PostgreSQL: Index Tuning

Optimizing PostgreSQL is a relevant and controversial topic ("How much resources should I invest in optimization vs. hardware?"): The first part of the series, "Query Optimization Insights", made it to the top 4 posts on

2024-03-28

PostgreSQL: Query Optimization Insights

In an era where the costs for cloud services continue to soar, I want to outline how our data team has successfully managed to run the infrastructure of our energy trading company within the first year using only two PostgreSQL database instances - each equipped with just two CPU cores and four GB of RAM. Despite this minimal use of resources, internal business processes and analytics dashboards ...

2023-11-15

Configuration of Python Applications

During the development of Python applications, I've continually asked myself how and when variables should be passed and initialized for the application's configuration. I want to be able to easily override the configuration for tests, for example, to use a local database for testing. But what exactly is application configuration, and why is it needed? The website 

2023-10-02

Remote work concepts in the office

After many years of working exclusively on-site in an office with colleagues who were also only familiar with this mode of work, the COVID-19 pandemic fundamentally changed how I work. Over a span of more than two years, I worked entirely from home. Now, I'm employed with a company that offers a hybrid work model, allowing both office work and remote work. Many of the principles and practices ...

2023-09-04