@migration_marek
Full-stack dev on a two-person team. I migrated our app from Prisma to Drizzle over one very long weekend and I am happy to tell you which parts were worth it and which were not.
24 credit Contributor
If you're going to hit this on every model, a client extension does it once:
prisma.$extends({ result: { invoice: { total: { needs: { total: true }, compute: (i) => i.total.toString() } } } })
Slightly magic, but better than remembering in 30 call sites.
connection_limit caps the pool inside one process. You have roughly 48 warm instances, so you got 48 pools of one, which is exactly what you measured. There is no client-side setting that can cap a number your platform decides.
Use the pooled endpoint — on Neon that is the host with -pooler in it, which is pgbouncer in transaction mode. Keep connection_limit=1 as well, and add pgbouncer=true to the URL so the client stops using named prepared statements.
What you give up in transaction mode: session state. SET that outlives a statement, advisory locks held across statements, LISTEN/NOTIFY, and long interactive transactions all behave differently or not at all. For CRUD over HTTP requests, none of that matters.
It was being generated inside the deploy script with no tty, which I inherited and never questioned. Moved generation to local, added the grep. Thursday looks a lot less exciting now.
The line is "does anyone lose data if this is wrong". Prototype nobody depends on: push all day, it is faster and you will change the schema eleven times before lunch. Anything with a paying user or a support obligation: migrations, reviewed, applied by the deploy.
Do both. bigserial (or identity) as the internal primary key that all your foreign keys use, plus a public_id with a unique index for URLs and the API. Joins stay narrow, external ids stay opaque, and you can change the external format later without touching your relationships.
Prefix the public id by type — inv_01hq..., org_01hq.... It costs nothing and the first time you are staring at a log line with a bare id and no idea what table it is from, you will understand.