01

Overview

MeilleurAppart gathers rental listings from six French-speaking cantons and sends a daily digest around 6 pm, filtered to each subscriber's criteria. A paid option, the "Real-time Pass", sends alerts immediately. The service does not apply on your behalf and collects no application file.

02

Context

Looking for a home in French-speaking Switzerland means watching several portals and dozens of property managers' websites. I was looking for a flat myself.

The original promise was to send applications on behalf of house-hunters. I dropped it in favour of a product that says what it does: the service sticks to finding and flagging listings.

03

Challenge

Collecting listings from dozens of sources without overloading or circumventing the sites, sending each listing only once, and alerting subscribers in time.

All of this with a small server, a free 500 MB database, and portals that block server addresses.

04

Objectives

  • Each listing only once
  • Reliable email
  • Respect for source sites
  • One-click unsubscribe

05

Technical decisions

Large portals are read through their email alerts rather than by collecting their pages. For property managers, seven generic connectors cover 26 sites (12.11.2026). Collection is rate-limited, spaces requests at random, honours Crawl-delay and excludes sites that refuse it; anti-bot protections are never circumvented. In the database, row-level security is enabled with no policy at all: the public reaches data only through RPC functions.

06

Architecture

Collector (container, production server) → Supabase (PostgreSQL 17, pg_cron, edge functions) → Resend (email) and Stripe (payments); static site served by Caddy.

The collection container runs a serialised loop, one browser at a time, and feeds the managed PostgreSQL database. De-duplication happens in the database, by grouping. pg_cron triggers edge functions that send one daily email in batches, with a lock, resume and idempotency. SEO pages are regenerated every night.

07

Technologies

  • Node 22
  • TypeScript
  • Playwright / Chromium
  • IMAP
  • Supabase / PostgreSQL 17 (functions, triggers)
  • 9 Deno edge functions
  • pg_cron
  • Resend
  • Stripe
  • Static HTML/CSS/JS site, no framework
  • Docker
  • Caddy
  • Bash
  • Umami

Database as surveyed in November 2026: 95 migrations, 18 tables, 76 SQL functions.

08

Implementation

Sign-up and preferences via token link, search criteria, de-duplication, batched email with resume and idempotency, real-time alerts, Stripe payments, one-click unsubscribe, signed re-subscription, SEO pages generated nightly, French and English versions.

The difficulties: portals blocking access; limited memory; silent failures (16 hours without ingestion one day in September, a send interrupted by a timeout); a flaw in the sign-up function; secrets visible in the process list.

The answers: rate limits written into the code (one request per second, random delays, honouring the delays sites ask for, excluding sites that refuse); a 650-line health check that sends one email per incident, plus an external dead man's switch; a disposable test database and a rule that no migration is tested in production; the flaw fixed in one night; wrappers so that secrets are no longer passed as arguments; an encrypted backup actually restored.

09

Results

  • 190 subscribers as of 12 November 2026.
  • 149 emails sent in 10.8 seconds, without error, on 12 November 2026.
  • About 1,735 unique listings per week, as of 11 November 2026.
  • 70 SEO pages for 44 towns, as of 15 November 2026.
  • Real database restore: 18 tables out of 18, on 13 November 2026.
  • 270 passing tests, per the log of 13 November 2026.
  • Website and emails in two languages.

10

Limits

Not a commercially proven product yet. No continuous integration yet (15.11.2026).

11

My role

I define the product and its ethical limits, add property managers one by one, apply migrations, rebuild the image, check twenty listings by hand every week, proofread the French and English copy and answer subscribers. The code is largely written with Claude Code: 92 % of 236 commits are co-signed as of 15 November 2026. A flaw in the sign-up function was found during a test run by the agent, fixed with it, then applied and verified by me.

12

Lessons learned

A product earns credibility when its promises match what it actually does.

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