Reuse database connections

I am new in the n8n community,
but for my experience in other domains, I can already tell that @MayurVirkar globalConnectionStore can only be seen as a workaround and will lead to other issues in regards to connection management

A new managed n8n section, new types and API to define resources
and the lifecycle need to be managed by n8n itself.

This resources would need to be defined like node types and credential types.

n8n host can then warmup, tear down and share this instances with the workflows
and of course implement a backoff strategy.

Resource types:

  • singleton connections
  • session tokens
  • pooled connections
  • file handles
  • … many others