Missing documentation for Node SQLite in-memory `:memory:`

[TotomInc]

Is your feature request related to a problem? Please describe

I recently had to integrate Nuxt + Nuxt Content in SSR for a production website hosted with k8s and helm.

Due to very restrictive helm + k8s for security reasons, it was not possible to SQLite as intended:

Failed to execute SQL INSERT INTO ...
H3Error: unable to open database file

Describe the solution you'd like

Using Node v24 with native Node SQLite adapter and in-memory database.

Had to dig into the Nitro generated code from nuxt build inside .output/server/chunks/nitro.mjs to discover that we can use a SQLite content.database.filename: ':memory:' to create an in-memory database and thus, not having issues related to strict fs permissions in the container/pod.

Would it be possible to add documentation for :memory: SQLite filename in the database section of the website?

Describe alternatives you've considered

None.

Additional context

I can work on it and do a PR if you want.

[farnabaz]

Thanks for flagging this, @TotomInc—your contribution is more than welcome!