Category: Uncategorized

My Always-On Dev Environment on a Raspberry Pi 5

There’s a particular kind of friction every developer knows: you sit down at a different machine, your laptop instead of your desktop, or your phone while waiting for a train. Then suddenly your project feels far away. The repo isn’t cloned. The Node version is wrong. The database is empty. The ten minutes you had to jot down an idea evaporate into setup.

I wanted to get rid of that friction entirely. The result is a small, always-on development server running on a Raspberry Pi 5 in the corner of my room, and a setup where every device I own: desktop, laptop, Android phone. They’re just a different window into the same live project.

This article is the story of how that environment is built, why it’s shaped the way it is, and where its limits are.

Continue reading My Always-On Dev Environment on a Raspberry Pi 5

Optimizing Relative Read Frequency Queries in SQL

My goal was just to create, test and use a relatively simple SQL query. Some complexity comes from aggregate functions and table self joins only.
I had 2 tables, article and view, where I store view count. I wanted to calculate a relative measure of read frequency, instead of absolute view counts. So recently published content is more comparable to older material.
To normalize this, we can calculate a views-per-day ratio and then compare all articles against the highest ratio one.

In this article, we’ll walk through:

  1. Showcasing the schema and the goal to achieve.
  2. Building the query that calculates relative read frequency.
  3. Investigating indexing strategies based on execution plans.
Continue reading Optimizing Relative Read Frequency Queries in SQL

Agile Challenges in Scale

Agile

Agile is about co-located smaller highly effective teams, which can focus and provide values in fast pace, driven by ownership and team spirit.
In Agile practices, team ceremonies (such as standups, sprint reviews, and retrospectives) are esential to improve communication, alignment, and efficiency. However, when Agile teams grow too large, these ceremonies can lose their effectiveness.
I like to highlight how large team sizes and poorly structured meetings can hinder productivity, communication, and decision-making, advocating for smaller team structures to preserve Agile’s core values.

Agile methodologies are built around small, cross-functional teams designed to work closely together, rapidly iterate, and adjust to changes. However, as teams grow in size, they often encounter communication bottlenecks and coordination challenges.

Continue reading Agile Challenges in Scale