[streblo]

Bound to be controversial hot take: serverless is the boring architecture you were looking for in the first place

[hot_gril]

Almost. It'd be boring if it'd handle these Postgres connections efficiently for me instead of making me rely on workarounds.

[hot_gril]

(As cool as Neon is. If you're already serverless for other reasons, they're providing a nice solution for Postgres.)

[icedchai]

I think serverless is fine as long as you don't lock yourself in to proprietary, vendor-specific APIs. For example, with AWS Lambda and Python, you could use Mangum (see https://mangum.io/ ) so you're deploying an ASGI app, based on say FastAPI or Starlette. For databases, stick with Postgres.