Can't open SQLite db file in VSCode

Question

Although I have installed SQLite extension on my VSCode, I can't open any db files. The app says 'the file is not displayed in the editor because it is either binary or uses an unsupported text encoding. Do you want to open it anyway?' I updated SQLite extension, reinstalled it and even reinstalled VSCode but nothing changed. I opened the file with SqliteStudio, there is no problem with the file. What's wrong with the app?

Answer 1

When you are using a linux distro (or WSL) you will have to install SQLite before you can use the Visual Studio Code extension. On a debian based OS you can use:

sudo apt install sqlite3

I had to restart Visual Studio Code before it worked.

Answer 2

I had the same problem. After you install SQLite extension, in order to open your database in VS you have to press CRTL+SHIFT+P, write "SQLite", select "SQLite: Open Database", and then you choose the database you want to open (ex: "./db/mydb.sqlite"). Finally, you click there to see your database.enter image description here