Blog Tags - Software Engineering Eastern Switzerland & Zurich

architecture

Scaffolding a Multi-Site Shop in Django: Three Pragmatic Patterns

May 08, 2026 | 10 min read

3 DB patterns: materialized paths, discriminator-column partitioning, and correlated subqueries as your low-cost foundation for read-heavy multi-site shops Read more »

Scaffolding a Multi-Site Shop in Django: Correlated Subqueries

May 08, 2026 | 8 min read

How correlated subqueries replace N+1 queries and overfetching when you need exactly one related object per row, with full Django ORM implementation. Read more »

Scaffolding a Multi-Site Shop in Django: Materialized Paths for Category Trees

May 08, 2026 | 20 min read

How materialized paths make subtree queries cheap, what moves actually cost in Postgres, and how django-treebeard handles the implementation details. Read more »

Ship Fast, Fix Forever: The Real Cost of Skipping Architecture

October 19, 2025 | 11 min read

Case study: shipping without architecture fundamentals created years of technical debt. The real cost of 'move fast, fix later.' Read more »

case-study

Ship Fast, Fix Forever: The Real Cost of Skipping Architecture

October 19, 2025 | 11 min read

Case study: shipping without architecture fundamentals created years of technical debt. The real cost of 'move fast, fix later.' Read more »

The Case of the Missing Seconds: A Performance Detective Story

September 14, 2025 | 6 min read

When disputes escalate to litigation threats, data beats blame. How I resolved a heated conflict by tracking down the real cause of performance issues. Read more »

cronjob

From Fragile to Reliable: Database-Backed Job Processing for Legacy Stacks

October 05, 2025 | 19 min read

How a two-week refactor eliminated months of downtime and manual restarts in a live production system — without adding any new infrastructure. Read more »

database

The Case of the Missing Seconds: A Performance Detective Story

September 14, 2025 | 6 min read

When disputes escalate to litigation threats, data beats blame. How I resolved a heated conflict by tracking down the real cause of performance issues. Read more »

development

uWSGI Emperor Mode: High-Performance Routing and Static File Serving in Production

September 07, 2025 | 7 min read

Why uWSGI remains an excellent choice for demanding production environments despite newer alternatives—proven performance, features, and stability. Read more »

Welcome to My Development Blog

August 31, 2025 | 3 min read

Insights on software development, project experiences, and technical discoveries. Learn how this site was built and follow my engineering journey. Read more »

devops

uWSGI Emperor Mode: High-Performance Routing and Static File Serving in Production

September 07, 2025 | 7 min read

Why uWSGI remains an excellent choice for demanding production environments despite newer alternatives—proven performance, features, and stability. Read more »

django

Scaffolding a Multi-Site Shop in Django: Three Pragmatic Patterns

May 08, 2026 | 10 min read

3 DB patterns: materialized paths, discriminator-column partitioning, and correlated subqueries as your low-cost foundation for read-heavy multi-site shops Read more »

Scaffolding a Multi-Site Shop in Django: Correlated Subqueries

May 08, 2026 | 8 min read

How correlated subqueries replace N+1 queries and overfetching when you need exactly one related object per row, with full Django ORM implementation. Read more »

Scaffolding a Multi-Site Shop in Django: Materialized Paths for Category Trees

May 08, 2026 | 20 min read

How materialized paths make subtree queries cheap, what moves actually cost in Postgres, and how django-treebeard handles the implementation details. Read more »

docker

Welcome to My Development Blog

August 31, 2025 | 3 min read

Insights on software development, project experiences, and technical discoveries. Learn how this site was built and follow my engineering journey. Read more »

jekyll

Welcome to My Development Blog

August 31, 2025 | 3 min read

Insights on software development, project experiences, and technical discoveries. Learn how this site was built and follow my engineering journey. Read more »

observability

The Case of the Missing Seconds: A Performance Detective Story

September 14, 2025 | 6 min read

When disputes escalate to litigation threats, data beats blame. How I resolved a heated conflict by tracking down the real cause of performance issues. Read more »

postgresql

Scaffolding a Multi-Site Shop in Django: Three Pragmatic Patterns

May 08, 2026 | 10 min read

3 DB patterns: materialized paths, discriminator-column partitioning, and correlated subqueries as your low-cost foundation for read-heavy multi-site shops Read more »

Scaffolding a Multi-Site Shop in Django: Correlated Subqueries

May 08, 2026 | 8 min read

How correlated subqueries replace N+1 queries and overfetching when you need exactly one related object per row, with full Django ORM implementation. Read more »

Scaffolding a Multi-Site Shop in Django: Materialized Paths for Category Trees

May 08, 2026 | 20 min read

How materialized paths make subtree queries cheap, what moves actually cost in Postgres, and how django-treebeard handles the implementation details. Read more »

refactoring

From Fragile to Reliable: Database-Backed Job Processing for Legacy Stacks

October 05, 2025 | 19 min read

How a two-week refactor eliminated months of downtime and manual restarts in a live production system — without adding any new infrastructure. Read more »

sql

From Fragile to Reliable: Database-Backed Job Processing for Legacy Stacks

October 05, 2025 | 19 min read

How a two-week refactor eliminated months of downtime and manual restarts in a live production system — without adding any new infrastructure. Read more »

technical-leadership

Ship Fast, Fix Forever: The Real Cost of Skipping Architecture

October 19, 2025 | 11 min read

Case study: shipping without architecture fundamentals created years of technical debt. The real cost of 'move fast, fix later.' Read more »

uwsgi

uWSGI Emperor Mode: High-Performance Routing and Static File Serving in Production

September 07, 2025 | 7 min read

Why uWSGI remains an excellent choice for demanding production environments despite newer alternatives—proven performance, features, and stability. Read more »