Fastify Plugin for spinning Node Child Process

[Easy-Cloud-in]

Can any one help to create a Fastify plugin for spinning Node Child process and hook it to each HTTPS methods.

Edit:
I am writing a multitenant app, where each tenant has their own database. So, I want to spawn a node child process for each client to access their database. whether to write a plugin or a middleware and hook it to preHandler.

[Uzlopak]

As I wrote you in discord, you need to elaborate more. With this description you get nowhere.

[Easy-Cloud-in]

I am writing a multitenant app, where each tenant has their own database. So, I want to spawn a node child process for each client to access their database. whether to write a plugin or a middleware and hook it to preHandler.

[metcoder95]

Why a child_process and not just a new connection or a proxy that sits in-front of the database?

[Easy-Cloud-in]

Yes after, doing some reach, I planned to use bgBouncer for connection pooling. I hope this will take care of horizontal scaling in AWS Fargate, where I am planning to run my app. Thank you for your time.

[Eomm]

I would start from here: https://github.com/piscinajs/piscina

It seems you need a fastify-piscina plugin

[Easy-Cloud-in]

Can you please explain what this plugin piscina does? Can you explain how it works for my use case?