Hey all ran into an issue I posted in github: https://github.com/serverless-stack/serverless-stack/issues/93

@thdxr I'm taking a look at this now.

Thanks - I was curious to see how you thought about this issue

Yeah let me talk to the team about it.

Feel like it supporting it would require a large change where instead of spawning a node process for every invocation, it gets spawned once per function and then messaged when there's an invocation - similar to how lambda in production works

hmm.. so in Prisma, does each Lambda opens one connection outside of the handler function, and holds onto that 1 connection until the end of the Lambda lifecycle?

It's not just one connection, it opens up a global connection pool. Every invocation of a lambda function will borrow a connection and return it once done

Oh... the global connection pool is managed by one Lambda?

Not exactly let me draw up a contrived example:

let count = 0

export const handler = function() {
  count++
  return {
    statusCode: 200,
    body: count.toString()
  }
}

Let me know if it'd be easier to explain over a quick Zoom chat.

similarly, "count" is usually where we put the prisma connections. On cold boot it'll have to establish a connection to the database but on following invocations they get to reuse the connection.

Right, would it work if count is always 0 (ie. connection always needs to be re-established) on every invocation?

Yeah that's the workaround I'm doing now, manually disconnecting the connection at the end of every function. That works for local development but not ideal for production

Right

Larger point being global state definitely a bad thing in lambda functions but in a few cases like this it's valid to have it and would be cool if SST supported it

Agreed🙌 Adding that to the roadmap.

Yeah right now I have it manually killing in dev and not in prod. It's a fine work around but requires my to wrap all my handlers

I just merged the fix to master. It's late here, we will cut a release tmr (Friday).

amazing! I'll give it a shot asap