Update better-sqlite3 to >= 11.5.0

[MikeMcC399]

• Supersedes yarn install better-sqlite3 build fails under Node.js 23.6.0 #591

What would you like?

1. Update better-sqlite3 to >= [email protected]. Latest version is currently [email protected]
2. Drop support for Node.js 21 (package.json engines and ci.yml)
3. Add CI testing in Node.js 23 (ci.yml)

Why is this needed?

1. Node.js 23 was released on Oct 15, 2024 and is the "current" version. It should be tested in CI. Node.js v23.6.0 documentation includes it in the corepack section of the documentation.
2. better-sqlite3 support for Node.js 23 was introduced in [email protected]. This is the minimum version required to run yarn install successfully with Node.js 23. yarn install is a prerequisite to run yarn build and yarn test.
3. [email protected] dropped support for Node.js 21
4. There is no version of better-sqlite3 which supports both Node.js 21 and 23 (see also comments in chore: bump better-sqlite3 to 10.x #513 from @wojtekmaj).
5. Node.js 21 entered end-of-life on Jun 6, 2024. It should no longer be tested in CI since it is now unsupported.

Other

PRs

1. Drop Node.js 21 support
2. Update better-sqlite3 to >= 11.5.0

[MikeMcC399]

• See chore!: remove Node.js 21.x from the range of supported versions #594