Fix @vscode-sqlite3 error message

[OlivierCavadenti]

• Fix the error message when sqlite3 driver don't exist.
• Relates Knex Throwing SQLITE3 error when SQLITE3 Is Installed,  #5002
• If I remove my vscode/sqlite3 install, I have the error. If I reinstall it via "npm install @vscode/sqlite3 --save" it's ok for me. I miss something ?

[kibertoad]

I would suggest more generic solution of driverName override map or, even better, make Client instances aware of their driverName

[OlivierCavadenti]

I introduce an alias driver name in sqlite3 index.js, I can't change the driver name by the way (is used by all tests that use testSql...).
By the way, I retest to delete the package, and run the command "npm install @vscode/sqlite3 --save" and I don't have any problem. I can't see more to do here to fix the problem in the related issue.

[kibertoad]

I think current solution is perfect

[tompsherman]

I've just spent a day or so chasing this bug in my code... and this thread as well as Knex Throwing SQLITE Error helped me fix it. I found two solutions that seem to work:

either the error message needs to be changed to npm install @vscode/sqlite3 --save because this fixes the issue but currently the error message reads npm install sqlite3 --save which does not fix the issue no matter how many times you install sqlite3
--OR--
the driver on line 32 knex/lib/dialects/sqlite3/index needs to be changed from return require('@vscode/sqlite3'); to return require('sqlite3');

[daniellockyer]

@OlivierCavadenti / @kibertoad: Any indication when this will be released? 🙂 The error message is tripping people up when @vscode/sqlite3 fails to compile

[kibertoad]

Released in 1.0.5

[daniellockyer]

Thank you!

[thefonso]

I have a small crazy question....Why is Knex dependent on @vscode/sqlite3 ?

I'm currently working a postgres project....no sqlite on my system...at all. Sooo.

Why is Knex dependent on @vscode/sqlite3 ?

[kibertoad]

@thefonso Do you mean migration creation or something else?

[mrondin1]

@kibertoad Similar to @thefonso comment above, I'm getting the @vscode/sqlite3 error when I'm creating migrations on an exclusively postgres project. Is that expected?

[kibertoad]

No. See #5106
1.0.6 should help in some cases, #5106 should help with the rest.