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!

[@josikie]

I want it! Thank youuu, blockchain in web development please

[@JeffreyWigington]

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

[@SamuelChan]

Thank you! Yeah it’s exactly what I needed when I was looking for a SQLite tool at that time!

[@dehumanizer668]

Exactly what I needed. Thanks!!

[@davidrudpedersen5622]

This is super useful. Thank you

[@nbvdib2098]

Straight to the point ! thank you.

[@aaronflorespasos3240]

Wow, really Thanks. Because I was searching this video

[@deldridg]

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

[@SamuelChan]

Thank you Dave!

[@PamelaMaranta]

Your videos are extremely helpful, thank you

[@SamuelChan]

Such generous compliments 🥹 thank you!

[@Cj-jh2ud]

Thanks! Very helpful

[@AlbertLeonardo]

thanks. very helpful!

[@SamuelChan]

thank you!

[@mehmedkukavica8076]

This is super.Thank you!

[@SamuelChan]

You’re welcome! :)

[@carpnavigator]

Thank you Samuel

[@SamuelChan]

You’re welcome Vitalii :)

[@hajamohideenpackirrowther367]

Great 👍🏻 thanks Samuel

[@SamuelChan]

You’re welcome!

[@user-zh2zx2od9k]

thanks, very helpful

[@SamuelChan]

Thank you Lucas!

[@josikie]

This is nice, thank you

[@SamuelChan]

Thank you Josi!

[@michaeljudge5063]

thank you

[@adrianmaulanamuhammad7225]

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

[@SamuelChan]

Theory: SQLite gives you a database. Pandas help you manipulate data. You write pandas code in Python to clean, transform, visualize etc, but pandas itself is agnostic to what database you have at the back end since there are plenty of connectors.
Practice: Say you have a diary mobile app, you implement sqlite so users of the app have somewhere to store the data (log in, log out, activity logs, mood, diary). That's what a db do. A user can export that data from the db (sqlite or anything else you choose), and write pandas to run exploratory analysis on their own diary.

[@aivynguyen5911]

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 :(((

[@SamuelChan]

You can do the simplest thing by importing a CSV into SQL in 3 lines of code (using .import in sqlite). Here's the tutorial: ua-cam.com/video/GlyIpx_VDxo/v-deo.html (you can also watch it on my Facebook: facebook.com/100000114769079/videos/6015776788436087/). Hope it helps!

[@naveedbutt7718]

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");

[@SamuelChan]

Looks like there are some good answers here:
social.msdn.microsoft.com/Forums/en-US/242ac93e-53f0-4d85-a682-4d0adfcd6249/how-to-find-db-file-?forum=xamarinforms
You might also find it useful to configure your SQLite db path:
learn.microsoft.com/en-us/xamarin/ios/data-cloud/data/configuration

[@sathyamkakodkar5957]

Hi how to export the results in csv file

[@RinglisLuan]

Help!! need db file to study, pls!

[@SamuelChan]

You can create a SQLite db for study by converting it from a CSV! :)
Intro to SQLite: CSV to SQLite (Python for Bankers series)
ua-cam.com/video/GlyIpx_VDxo/v-deo.html
You can also get the files, data etc from my GitHub!

[@rachrach9871]

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

[@SamuelChan]

hey there isn't enough information in your comment for me to help / troubleshoot. Can you copy + paste some logs? Is it a sqlite file you downloaded off the internet and does switching to another sqlite file work? (trying to isolate the root cause)

[@rachrach9871]

@@SamuelChan I’m working on a django project and I’m trying to open database in VSCode but I keep getting “failed to open database” error. The sql explorer doesn’t even show up on the explorer pane.
I have SQLite extension installed. I’ve also installed sqlite3 on my computer and it works according the cmd prompt. But I’m still getting this error message.
I’m using a windows 10.
Any help would be appreciated. This is my first django project so I’m still learning.

[@SamuelChan]

OK going off the django comment, this sqlite file may not have existed until you did your first migration (python manage.py makemigrations && python manage.py migrate). Do you physically see it on your drive when you change directory to that django project and then do ls for lists (dir on Windows)?

[@rachrach9871]

@@SamuelChan yes I see it