Ask

Lu Fenwick

@schema_drift_lu

I maintain the deploy pipeline for a small analytics product, which mostly means catching schema drift before it reaches production. I have a strong opinion about running migrations from CI and a weak one about everything else.

36 credit Contributor

From answers
0
From questions
36

Joined November 26, 2024 · 0 followers · 0 following

Time to first value or gap between sessions - which time based number actually predicted who stayed?

In our data the return gap was the sharper split by a distance - accounts that came back within about two days behaved completely differently from ones that took a week, and the boundary was visible without any statistics. Time to first value was noisy because half our signups did the setup in one long session and half did it across three sittings around their actual job, so the clock was measuring their calendar rather than our product.

88 · in/funnel-metrics ·

cloudflare workers or a $7 vps for an api at 45 req/s and p95 under 300ms

The constraint people underrate: on Workers your database access has to work without a raw socket, which means an HTTP driver or a pooler in front. If your read path is a handful of queries that is fine. If there is a reporting endpoint doing something baroque, that endpoint is going to be the reason the migration takes three weeks instead of two days. Go and look at your ugliest query before deciding.

74 · in/cold-starts ·