vscode-sqlite: Failed to open database

I got the same error here, and when browsing to find a fix i found this issue https://github.com/AlexCovizzi/vscode-sqlite/issues/83, so the problem is that some linux (ubuntu 20.04 here) cant run sqlite3 explorer without sqlite3 packages installed, so you need to install it, run:

 sudo apt install sqlite

and i think it will fix it (worked for me)

Edit: check https://github.com/AlexCovizzi/vscode-sqlite/issues/119#issuecomment-639948097 for fix without installing any package

Guys, u don’t need this. If u enabled “sqlite.logLevel”:“DEBUG” on VsCode JSON Settings, look for the file like “/home/wendel/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64”

Go to terminal and type “chmod +x /home/wendel/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64”

And the issue is resolved without installing anything else.

I think that this will happen only on unix SO’s.

I got the same error here, and when browsing to find a fix i found this issue #83, so the problem is that some linux (ubuntu 20.04 here) cant run sqlite3 explorer without sqlite3 packages installed, so you need to install it, run:

 sudo apt install sqlite

and i think it will fix it (worked for me)

Just remember to restar your VSCode after doing that 😉 But totally solved my problem!

VSCode with Remote-WSL Ubuntu:

[12:22:04 PM][vscode-sqlite][INFO] Activating extension vscode-sqlite v0.8.2… [12:22:04 PM][vscode-sqlite][ERROR] Unable to find a valid SQLite command. Fallback binary is not valid. [12:22:04 PM][vscode-sqlite][INFO] Extension activated.

Had to install sqlite (sqlite3) as mentioned by @Henriquepb22 here

I’ll investigate the issue this weekend. @LeuAlmeida It’s interesting that it worked with version 0.7.1, i’ll look into it, maybe at some point I revereted a fix. @Henriquepb22 @LeuAlmeida @IceHower @joaozarate Are you all on Ubuntu 20.04?