Raspberry Pi 4: Error: Cannot find module 'sqlite3'

Question

Status of sqlite3 installation on my Raspberry Pi 4 B when queried from the terminal:

pi@raspberrypi:~ $ sqlite3 --version
3.27.2 2019-02-25 16:06:06 bd49a8271d650fa89e446b42e513b595a717b9212c91dd384aab871fc1d0alt1
pi@raspberrypi:~ $ sqlite3
SQLite version 3.27.2 2019-02-25 16:06:06
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> 

For me it is confirmation that installation is complete. Also, I did not do any thing like creating a table or etc. I just installed it. Now I am trying to access it.

My code:

const sqlite3 = require('sqlite3').verbose();

Response:

internal/modules/cjs/loader.js:638
    throw err;
    ^
Error: Cannot find module 'sqlite3'
    at Function.Module._resolveFilename (internal/modules/cjs/loader.js:636:15)

Don't know why it says cannot find sqlite3 when terminal clearly shows its installation and ability to access sqlite3?

Answer 1

The binary executable named sqlite3 and the Node.js module named sqlite3 are not the same thing.

You need to install the Node.js module to use the Node.js module.