Issues creating custom nodes

Describe the problem/error/question

It’s close to impossible to create custom nodes.
As described here, the official documentaiton is wrong: https://www.youtube.com/watch?v=nX_8OVhUVSY&ab_channel=BenYoungAI

Additionnally, it seems impossible to fully install n8n with pnpm, as pnpm n8n gives me:
Initializing n8n process
There was an error initializing DB
SQLite package has not been found installed. Try to install it: npm install sqlite3 --save

I have tried to install n8n with npm using:
npm cache clean --force
pnpm store prune
rm -rf ~/.n8n

pnpm install n8n -g

What is the error message (if any)?

Initializing n8n process
There was an error initializing DB
SQLite package has not been found installed. Try to install it: npm install sqlite3 --save

Information on your n8n setup

  • n8n version: n8n 1.79.3
  • Database (default: SQLite): sqlite3
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Pnpm
  • Operating system: Ubuntu in WSL2