Problem deploying on Vercel and better-sqlite3

[ValentinOsvaldo]

I'm using @nuxt/content version 3.6.0, and deploying my Nuxt app to Vercel.
I configured the content.database to use PostgreSQL hosted on Neon.

However, during deployment I encounter the following error:

Here is my relevant nuxt.config.ts snippet:

export default defineNuxtConfig({
  content: {
    database: {
      type: 'postgres',
      url: process.env.POSTGRES_URL!,
    },
    preview: {
      api: 'https://api.nuxt.studio',
      dev: true,
      gitInfo: {
        name: 'valen.vue',
        owner: 'ValentinOsvaldo',
        url: 'https://github.com/ValentinOsvaldo/valen.vue.git',
      },
    },
    renderer: {
      anchorLinks: false,
    },
  }
})

I try to create a new deploy but the error persists

[edimitchel]

Hi,

When you install locally, it should ask you this too. Which version of Node do you have ?

[ValentinOsvaldo]

Hi,

When you install locally, it should ask you this too. Which version of Node do you have ?

I'm currently using Node.js version v22.14.0 on my local machine, and Vercel runs 22.x. I'm also using Bun as my package manager, and my Nuxt version is "nuxt": "^3.17.5".

Even when I run the build locally, it still generates the .data/ folder, and I encounter the same issue when deploying to Netlify.

[farnabaz]

Thanks for the report, this should be fixed in #3425
I appreciate if you check with pr-release and verify the fix

https://pkg.pr.new/@nuxt/content@3425

[ValentinOsvaldo]

Thanks for the report, this should be fixed in #3425 I appreciate if you check with pr-release and verify the fix

https://pkg.pr.new/@nuxt/content@3425

I appreciate your help, but my problem persists.

I can share you my repo with you
https://github.com/ValentinOsvaldo/valen.vue

[farnabaz]

I see, thanks for the repo.
What is your development environment?
Content module requires a SQL connector in order to parse/cache and generate the database dump. Try enabling native sqlite, it will solve your issue in Vercel.

https://content.nuxt.com/docs/getting-started/configuration#experimentalnativesqlite

[ValentinOsvaldo]

I see, thanks for the repo. What is your development environment? Content module requires a SQL connector in order to parse/cache and generate the database dump. Try enabling native sqlite, it will solve your issue in Vercel.

https://content.nuxt.com/docs/getting-started/configuration#experimentalnativesqlite

Thanks, it works.

I added these lines to nuxt.config

experimental: {
  sqliteConnector: 'native',
},

[farnabaz]

@ValentinOsvaldo I still wonder, what is your development environment?
Content module should prompt for installing better-sqlite pacakge on development.

[ValentinOsvaldo]

@ValentinOsvaldo I still wonder, what is your development environment? Content module should prompt for installing better-sqlite pacakge on development.

Hi! I'm using Windows 11 as my development environment. I initially created the project using:

bun create nuxt <project-name>

Then I installed @nuxt/content. However, I later switched from Bun to pnpm as my package manager.

The project uses Nuxt 3 ("nuxt": "^3.17.5") and @nuxt/content (version 3.6.1). I've configured it to use PostgreSQL hosted on Neon, and I'm explicitly setting the database option in my nuxt.config.ts:

export default defineNuxtConfig({
  content: {
    database: {
      type: 'postgres',
      url: process.env.POSTGRES_URL,
    },
    preview: {
      dev: true,
      api: 'https://api.nuxt.studio',
    },
  },
})

In development, I was never prompted to install better-sqlite3, which is fine.
However, the .data/content folder is still being generated after running pnpm build (previously bun run build), even though I'm not using SQLite at all.

[farnabaz]

Thanks for the info

However, the .data/content folder is still being generated after running pnpm build (previously bun run build), even though I'm not using SQLite at all.

Just to mention, Content module always uses sqlite database in development to cache parsed contents and improve restart performance.