how to properly re-open a closed instance?

[sandros94]

Currently I globally cache my pglite instance on my node server and close it only when I close the server.

But lets say I want to close pglite after each server response and re-open it once a new request comes in WITHOUT recreating a new instance, would it be possible to add a connect or open function like close?

So far in a Nitro project I have:

• utils/pglite.ts:

  import type { PGliteOptions } from '@electric-sql/pglite'
  import { PGlite } from '@electric-sql/pglite'
  
  let pglite: PGlite | undefined
  export function usePGlite(options?: PGliteOptions) {
    if (!pglite) {
      pglite = new PGlite(options)
    }
  
    return pglite
  }

• plugins/pglite.ts:

  import { defineNitroPlugin, usePGlite } from '#imports'
  
  export default defineNitroPlugin((nitro) => {
    nitro.hooks.hookOnce('close', async () => {
      const pg = usePGlite()
  
      if (pg) {
        console.log('`Nitro`: closing PGlite...')
        await pg.close()
  
        if (pg.closed) {
          console.success('`Nitro`: PGlite closed successfully.')
        }
      }
      else console.log('`Nitro`: no PGlite instance found. Nitro Shuting down.')
    })
  })