UseDatabase feature -- Build nitro with environment variable

[ClemenF]

Hello,

I have a small api project build on nitrojs. I use the exprirement feature database (db0) to connect to a postgresql database.
On my local env, i don't have any issue but i have some question about the deployment phase.

I run the build command and then the preview without any issue but once i call my API which do a call to database, it displayed an error Error: SASL: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string triggered in file : .output/server/node_modules/pg/lib/crypto/sasl.js:36:11

After some debugging, I found out that the config pass to the pg client is empty. In .output/server/chunks/nitro/nitro.mjs :

const connectionConfigs = {
  default: {
          connector: postgresqlConnector,
          options: {"ssl":false}
        }
};

I use the file nitro.config.ts to configure my database :

export default defineNitroConfig({
  runtimeConfig: {
    dbHost: '',
    dbPort: '',
    dbDatabase: '',
    dbUsername: '',
    dbPassword: '',
    dbUseSSL: '',
  },
  srcDir: "server",
  experimental: {
    database: true
  },
  database: {
    default: {
      connector: 'postgresql',
      options: {
        user: process.env.NITRO_DB_USER,
        password: process.env.NITRO_DB_PASSWORD,
        host: process.env.NITRO_DB_HOST,
        port: process.env.NITRO_DB_PORT,
        database: process.env.NITRO_DB_DATABASE,
        ssl: process.env.NITRO_DB_USESSL === 'true'
          ? { rejectUnauthorized: false }
          : false
      }
    }
  }
});

And I have a .env file next to it which define the variable.

I understood that when running the commande npm run build, it doesn't use any of the environment variable.
To have it work, i can use the following command :
node --env-file=.env ./node_modules/nitropack/dist/cli/index.mjs build and then, I have my nitro api working well.

Is there any other way to have my file built with variable environment well configured ?