SQLite in VSCode (open db, run query, view results) demo

A simple demonstration of using only VSCode (Visual Studio Code) to open a connection to a SQLite db, perform database queries on a SQLite database, and view results of our SQL query all within VSCode!

[SamuelChan]

Hey if you find this content helpful! I’m starting to make full series of python / data science / blockchain (smart contracts) that is sorted in episodes. All of them are around hour long, HD, and have no ads. Please feel free to check out the channel or consider subscribing ❤️ Let me know if you have topics you’d like to see me cover!

[JeffreyWigington]

Thanks for making this quick walkthrough. It made it very easy to figure out how to open my database and run my queries!

[deldridg]

Many thanks Samuel - very helpful. Cheers from Australia - Dave

[PamelaMaranta]

Your videos are extremely helpful, thank you

[rachrach]

I keep getting failed to open database when I try to run a query. How to fix this? Thank you

[aaronflorespasos]

Wow, really Thanks. Because I was searching this video

[sathyamkakodkar]

Hi how to export the results in csv file

[adrianmaulanamuhammad]

Thanks, very clear. I want to ask something, when are we gonna use SQLite? I used to use pandas to manipulate data.

[naveedbutt]

This may not be very much related. But do you know where can I find the db3 file that I created from my Xamarin app.

Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "****.db3");

[aivynguyen]

Can you make a video of how to create a database? Because I can’t click “SQLite Open Database” when I don’t have one :(((