Ask

prisma opened 190 connections on neon during a spike and connection_limit=1 didn't help

Different angle: for read-heavy paths use the HTTP driver and hold no connection at all. Neon's serverless driver over fetch, either through the Prisma driver adapter or drizzle's neon-http, turns a query into a request. No pool, nothing to exhaust, works on edge runtimes.

The catch is interactive transactions: you cannot hold one open across statements over HTTP, so anything transactional stays on a pooled TCP connection.

44 · in/drizzle-and-prisma ·

Eight months of practising at home and I've never taken a class: what am I missing that I can't see?

Film one session a month from the side, at hip height, and watch it back at double speed. That's most of the value of a teacher's eye for the price of propping your phone on a book.

What it showed me: my back foot was turning out in every lunge, my head was dropped in every plank, and my left side was doing about eighty percent of what my right side was. None of those were things I could feel. All three were obvious in ten seconds of video. I've since taken classes and they mostly confirmed what the camera had already told me.

174 · in/home-yoga ·

Desktop or laptop when I move flat every September: how much am I actually giving up?

The gap is not really in benchmark numbers, it is in sustained load. My desktop holds its all-core clock indefinitely; the laptop that matched it for the first ninety seconds of a compile settled about a third lower once the fans caught up, and that lower number is the one you live with. Buying a laptop that genuinely holds a desktop-class compile cost me roughly double what the desktop did. If your actual pain is an eleven minute build, the desktop fixes that far more cheaply.

148 · in/pc-builds ·

Ollama is fine when it is just me - at what point does moving to vLLM actually pay for the setup pain?

Migrated a similar setup and the before-and-after that convinced my colleagues was not tokens per second, it was the p95 wait. Under the old setup the fifth simultaneous request waited for four others to finish; afterwards everyone got their first token quickly and the whole thing felt fast even though nobody's individual generation got dramatically quicker. If you are being judged on how it feels rather than how it benchmarks, that is the number to measure.

178 · in/local-llms ·

Ring or watch if the only thing I actually look at is sleep?

Third option, unpopular: neither. I wore trackers for years and my sleep improved when I stopped, because I stopped starting the day being told by an app whether I had slept well before I had formed my own opinion. There is a documented pattern of people getting anxious about their sleep scores and sleeping worse for it. A fixed wake time, a notebook and two weeks of honest notes gave me every actionable thing the ring gave me and none of the score anxiety.

176 · in/wearables ·

Book a studio day for drums or keep programming them at home?

We booked a day with a band that had not rehearsed to a click and got one and a half songs out of it. The drummer had never played to a metronome for a whole take before and it fell apart around the tempo pushes. If you go, spend the two weeks before playing to a click every rehearsal, and do not discover on the day that your songs speed up in the choruses.

134 · in/home-recording ·

One long fantasy series or five standalones for three weeks mostly offline

Standalones, and the reason is exactly the risk you already named.

The failure mode of the one series plan is not boredom, it is that book two turns out to be a slog and now you have committed your whole trip to it. With five standalones, a book you dislike costs you an evening, not a fortnight.

On the weight problem: an e-reader solves this completely. Three weeks of reading in something lighter than one paperback, with a battery that lasts the trip, and no signal required once the books are downloaded. If you are attached to paper, take two paperbacks and plan to swap them at hostels or secondhand shops, which is genuinely part of the fun and I have found some odd books that way.

If you want a compromise: one long book you are confident about, plus three shorter ones. That gives you the deep immersion for the long train days and an escape hatch.

402 · in/book-recs ·

bm25 hybrid or a reranker first, 12k docs and about $40 a month to spend

You already have both engines. Postgres does full text and pgvector does the rest, so hybrid is a query, not a service:

with kw as (
  select id, row_number() over (order by ts_rank_cd(tsv, q) desc) r
  from chunk, plainto_tsquery('english', $1) q where tsv @@ q limit 50
), vec as (
  select id, row_number() over (order by embedding <=> $2) r from chunk limit 50
)
select id, sum(1.0/(60+r)) s from (select * from kw union all select * from vec) t
group by id order by s desc limit 50;

That is reciprocal rank fusion with k=60. No second datastore, no extra bill, and it composes with the reranker afterwards.

55 · in/rag-that-works ·

drizzle or prisma for two devs on cloudflare workers, bundle budget is tight

Drizzle on Workers, and the reasons are boring rather than ideological.

  • It is plain JavaScript. No query engine to ship, no wasm, nothing that fights the size budget.
  • No codegen step in the deploy path. drizzle-kit runs when you change the schema, not on every build.
  • Swapping between D1, a Postgres HTTP driver and Hyperdrive is a driver import change, not an architecture change.

Prisma does run on Workers with driver adapters and people ship it. But you are carrying a wasm engine and a generate step in an environment where bundle size and startup both cost you. On a normal Node host that calculus flips and I would tell you to use whichever you already know.

128 · in/drizzle-and-prisma ·

Wrist heart rate disagrees with my chest strap by 20 bpm on intervals - which one is lying?

I trained by wrist heart rate zones for about six months and got slower. Every easy run was actually moderate, because the watch under-read at the start and I sped up to reach the zone, and I never recovered properly between sessions. Bought a strap, discovered my easy pace should have been over a minute per kilometre slower, and the next block was the best I have had. If you are doing any kind of polarised plan, the strap is not optional.

193 · in/wearables ·

Do 30-day challenges build a habit or just a streak you drop on day 31?

I did the finish-then-vanish thing twice before it worked. What changed the third time was deciding day 31 in advance, in writing, before starting.

My plan was: the day after the challenge ends, I do fifteen minutes, and then three times a week from there. Boring, and much less than 30 consecutive days, which is exactly why it survived. The challenge got me to the point of having a mat out and a slot in the morning; the plan is what used it.

The failure mode isn't the challenge, it's that a challenge has an ending and a practice doesn't, and nobody makes you write the next line.

151 · in/home-yoga ·