I'm new to Django
and try to see a SQLite3
file. I'm looking for a way to open and view a database content with visual studio code
like Pycharm can do (see picture)
Does an extension could do that? Is it possible to achieve this in VSC?
Open a command prompt (cmd.exe) and 'cd' to the folder location of the SQL_SAFI. sqlite database file. run the command 'sqlite3' This should open the SQLite shell and present a screen similar to that below.
Connect to your database In Visual Studio Code, press Ctrl+Shift+P (or F1) to open the Command Palette. Select MS SQL:Connect and choose Enter. Select Create Connection Profile.
I published an extension to query and explore sqlite3 databases
vscode-sqlite
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With