Blog - Software Engineering Eastern Switzerland & Zurich

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

May 08, 2026 | 10 min read |django postgresql architecture

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 |django postgresql architecture

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 |django postgresql architecture

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 |architecture technical-leadership case-study

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

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

October 05, 2025 | 19 min read |refactoring cronjob sql

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

The Case of the Missing Seconds: A Performance Detective Story

September 14, 2025 | 6 min read |observability case-study database

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 »

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

September 07, 2025 | 7 min read |development uwsgi devops

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 |development jekyll docker

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