Update better-sqlite3 package to the latest version

[101sam]

Fix

Update better-sqlite3 package to the latest version

From:
"better-sqlite3": "9.6.0",

TO:
"better-sqlite3": "^11.3.0",

We are using version 11.3.0, although a newer version is available because the “Getting Started” script in Strapi specifies this version. See Strapi’s package.json line 26.

Describe your request

Error install using latest versions of any of those packages manager: Yarn berry or pnpm or npm

Steps to reproduce the behavior

1. clone the rep
2. yarn install (using yarn v2) or any other package manager
3. See error

  strapi git:(main) yarn install
! The local project doesn't define a 'packageManager' field. Corepack will now add one referencing [email protected]+sha512.341db9396b6e289fecc30cd7ab3af65060e05ebff4b3b47547b278b9e67b08f485ecd8c79006b405446262142c7a38154445ef7f17c1d5d1de7d90bf9ce7054d.
! For more details about this field, consult the documentation at https://nodejs.org/api/packages.html#packagemanager

➤ YN0087: Migrated your project to the latest Yarn version 🚀

➤ YN0000: · Yarn 4.5.1
➤ YN0000: ┌ Resolution step
➤ YN0085: │ + @strapi/plugin-cloud@npm:5.3.0, @strapi/plugin-seo@npm:2.0.4, and 1455 more.
➤ YN0000: └ Completed in 1s 671ms
➤ YN0000: ┌ Post-resolution validation
➤ YN0086: │ Some peer dependencies are incorrectly met by dependencies; run yarn explain peer-requirements for details.
➤ YN0000: └ Completed
➤ YN0000: ┌ Fetch step
➤ YN0000: └ Completed in 0s 491ms
➤ YN0000: ┌ Link step
➤ YN0007: │ better-sqlite3@npm:9.4.3 must be built because it never has been before or the last one failed
➤ YN0007: │ esbuild@npm:0.21.3 must be built because it never has been before or the last one failed
➤ YN0007: │ esbuild@npm:0.20.2 must be built because it never has been before or the last one failed
➤ YN0007: │ msw@npm:1.3.0 [d92c2] must be built because it never has been before or the last one failed
➤ YN0007: │ esbuild@npm:0.16.17 must be built because it never has been before or the last one failed
➤ YN0007: │ @swc/core@npm:1.7.24 [613fc] must be built because it never has been before or the last one failed
➤ YN0007: │ core-js-pure@npm:3.38.1 must be built because it never has been before or the last one failed
➤ YN0007: │ sharp@npm:0.32.6 must be built because it never has been before or the last one failed
➤ YN0009: │ better-sqlite3@npm:9.4.3 couldn't be built successfully (exit code 1, logs can be found here: /private/var/folders/cn/zskkwyp57s9ftbjl21dghw_m0000gn/T/xfs-b3080b8c/build.log)
➤ YN0007: │ strapi@workspace:. must be built because it never has been before or the last one failed
➤ YN0000: └ Completed in 8s 389ms
➤ YN0000: · Failed with errors in 10s 645ms

After update

➜  strapi git:(main) ✗ nano package.json
➜  strapi git:(main) ✗ yarn install
➤ YN0000: · Yarn 4.5.1
➤ YN0000: ┌ Resolution step
➤ YN0085: │ + better-sqlite3@npm:11.5.0
➤ YN0085: │ - better-sqlite3@npm:9.4.3
➤ YN0000: └ Completed in 0s 566ms
➤ YN0000: ┌ Post-resolution validation
➤ YN0086: │ Some peer dependencies are incorrectly met by dependencies; run yarn explain peer-requirements for details.
➤ YN0000: └ Completed
➤ YN0000: ┌ Fetch step
➤ YN0013: │ A package was added to the project (+ 9.64 MiB).
➤ YN0000: └ Completed in 0s 730ms
➤ YN0000: ┌ Link step
➤ YN0007: │ better-sqlite3@npm:11.5.0 must be built because it never has been before or the last one failed
➤ YN0008: │ strapi@workspace:. must be rebuilt because its dependency tree changed
➤ YN0000: └ Completed in 0s 968ms
➤ YN0000: · Done with warnings in 2s 358ms
➜  strapi git:(main) ✗ yarn develop

Expected behavior

A clear and concise description of what you expected to happen.

Screenshots

If applicable, add screenshots to help explain your request.

Additional context

Tested Environment

========================================================
Date..............: 2024-11-13 07:07:42 PST

Installed Global Packages:
nvm       : 0.40.1
node      : v22.11.0
npm       : 10.9.0
yarn      : 4.5.1
Node.js   : v22.11.0
pnpm      : 9.13.0
bun       : Not installed
corepack  : 0.29.4
pm2       : Not installed

=== System Information ===
OS: Darwin
Kernel Version: 24.1.0
Processor: arm
========================================================