Reusing the Database connection in app

[PrathameshTM]

I am not sure how things work with this example.
How does the database connection object become available in the app?

More detailed question here.

[H4ad]

If you use Typeorm, you can connect to your database in one place and get the connection elsewhere using getConnection(), so you don't need to directly pass your connection to the app.

But, in this example, you can create whithin ./app a method to initialize your database, pass it to your express instance to build your routes, and then return your express instance to be used to create serverlessExpress({ app }).

Something like this:

async function setup (event, context) {
  const expressApp= await app.initializeExpressInstanceWithDatabase()

  serverlessExpressInstance = serverlessExpress({ app: expressApp })
  return serverlessExpressInstance(event, context)
}

[bneigher]

RDS proxy can be leveraged here as a secondary measure. It can help manage/reuse db connections.