ERROR: “Please install sqlite3 package manually” when I execute “sequelize db:migrate”

Question

I'm trying to create a sample app, using this article:

https://arjunphp.com/restful-api-using-async-await-node-express-sequelize/

But when a try to execute database migration with sequenze-cli on sqlite, a have always the same error:

C:\WORKING\todo\todos-manager>sequelize db:migrate

Sequelize CLI [Node: 10.16.0, CLI: 5.5.0, ORM: 5.8.12]

Loaded configuration file "config\config.json".
Using environment "development".

ERROR: Please install sqlite3 package manually

I've already tried to rebuild, with no success.

Any ideas?

Answer 1

UPDATE:

the error does not occur if I use the statement:

npx sequelize-cli db:migrate

instead of

sequelize db:migrate

and migration completes successful!

I hope it's useful to someone.

Thanks to all!

Answer 2

First install sequelize-cli globally

sudo npm install -g sequelize-cli

Then use the following command to execute migrations.

sequelize db:migrate

Answer 3

in my case both:
npx sequelize-cli db:migrate
and
sequelize db:migrate
didn't work.
I don't know if its a bad practice but only global installation:
npm i -g sqlite3
solve the issue for me

Answer 4

In my case sqllite3 was not installed due to node version mismatch . I switched my node version to v9.11.1 and the error is gone afterwards.

Answer 5

Might be bit late but writing this for since there is no accepted answer yet :)

I tried with Node10.x , your installed sqlite3 version might not be matching with Node-version, so please switch your version to Node8.x or 9.x.

Use NVM to switch between versions and try avoid installing packages globally.