01

Overview

You can live side by side for years without ever getting to know each other.

In French-speaking Switzerland, you can live on the same street, take the same train, shop in the same places — and never really talk. Circles form early and close quickly. For a newcomer, an expat or a cross-border commuter, fitting in can feel like an obstacle course.

Fayza, the founder, saw this first-hand. She wanted to create a place where people from the same region can finally meet, go out and bring their canton to life together — long-time residents and newcomers alike. The idea, the name and the vision are hers: a warm, human-scale local community.

She came up with the project. I designed and developed its application with the assistance of Claude Code, and I moderate it day to day — so that the community stays a healthy, safe space where everyone feels they belong.

02

Context

A project with two founders, in production as of 15 November 2026.

03

Challenge

Keeping the community a healthy, safe space: protecting members' data, backing up and being able to restore, monitoring, moderating day to day.

04

Objectives

  • Data protected table by table
  • Verified backups
  • Continuous monitoring
  • Control over sensitive operations

05

Technical decisions

Ubuntu 24.04 server at OVH, with Caddy, TLS, UFW, Fail2ban, PM2, systemd and a local PostgreSQL database for internal services. React / Vite / Capacitor application on Supabase (PostgreSQL, PostgREST, RPC, Realtime, Storage). Security: RLS, SECURITY DEFINER functions, SSL, key rotation, network restrictions. GPG-encrypted backups to Cloudflare R2, verified by SHA-256 checksum; Better Stack monitoring.

06

Architecture

React / Vite / Capacitor application → Supabase (PostgreSQL, PostgREST, Realtime, Storage, edge functions); Ubuntu server with Caddy for internal services (CRM, local PostgreSQL); encrypted backups → Cloudflare R2; Better Stack monitoring.

07

Technologies

  • React
  • Vite
  • Capacitor
  • Supabase (PostgreSQL, PostgREST, RPC, Realtime, Storage, edge functions)
  • Ubuntu 24.04
  • Caddy
  • UFW
  • Fail2ban
  • PM2
  • systemd
  • PostgreSQL
  • GPG
  • Cloudflare R2
  • Better Stack

08

Implementation

15 edge functions and 403 reconciled migrations. The application code, migrations, scripts, audits and documentation were produced with Claude Code, under my direction.

09

Results

As of 15 November 2026: RLS enabled on 79 of 79 application tables (enabled, not an exhaustive policy audit); 40 monitoring checks every 5 minutes; 3 of 3 successful restores (CRM, database, storage).

10

Limits

RLS is enabled on every table; not every policy has been exhaustively audited.

11

My part

I designed and developed the application with the assistance of Claude Code. I handle technical and product direction, priorities and batching, trade-offs, approval of sensitive operations, applying production migrations, merging branches, managing consoles, deployments, testing on phones and in the CRM, approving backups and security measures, and moderation.

12

Lessons learned

A local community also takes shape over time, by making sure people can feel they belong.

Contact

Let's build something reliable.

Available immediately for a systems administrator role, and always up for making a system reliable or talking through a product.

Get in touch