Sqlite Database is in 'binary' format in Visual Studio Code

Asked

Viewed 482 times

-4

Hello, I’m inexperienced with VS Code yet, and I’m creating a web application, but I’m having a problem and I haven’t found the solution on any other site...(I’m using knex db). I’ve tried to erase and create again, but it always stays that way...

esta é a mensagem que aparece... se eu clico em "Do you want to open it anyway, ele fica todo binário."

javascript database sqlite visual-studio-code

1 answer

0


Vscode by default cannot open this type of file.

In fact, several other extensions and even languages are not recognized by it, for that it is necessary to install extensions in the same.

There are specific programs to open a Sqlite file, but if you want to open it in Vscode itself, one possibility is to install the Sqlite extension:

https://marketplace.visualstudio.com/items?itemName=alexcvzz.vscode-sqlite

  • I installed the extension, thank you. I gave some commands that spoke in the documentation, delete db and created again, but the file remains 'format-free'... Have any other suggestions?

  • I only know this extension, probably there are others, you need to tell the extension which file you want to open and it will give you some options regarding the open file, including displaying the tables present in the file. You can also choose to use a specific program for this, such as sqlitestudio.

Browser other questions tagged javascript database sqlite visual-studio-code

You are not signed in. Login or sign up in order to post.