SQLite beginner crash course in Visual Studio Code - 2022
Вставка
- Опубліковано 31 лип 2024
- Full SQLite crash course! Come learn how to use SQLite inside of vs code and crush the crash course with this tutorial! Learn how to Create, Select, Update, Delete, Insert Into, and much more in this tutorial!
Timestamps
00:00 Intro
00:50 Slides
08:00 VS Code Setup
09:35 Creating a table
11:15 Inserting data into a table
13:30 Querying data from a database
15:30 Where
23:00 Updating a row
24:45 Deleting a row
#sqlite
#vscode
#database
I m following your course. But i had an error : Parse error near line 4: no such column: mike
RT INTO users (username, password, email) VALUES ("mike", "mypassword", "mike@....
To fixe that issue i went to the web. And I found the reason. I must use the simple quote for a TEXT and not a double quote.
I don't know why with the same software and syntax, we don't have the same result
I hope it will be helpfull for those who will have this problem.
Mine is allowing double quotes. It has been several years since I used SQL and do recall some versions (including the ANSI std, IIRC, called for single quotes). I have no idea why this version allows double quotes and why yours is not working with them. Maybe there is a VS Code setting or a setting in the SQLite extension?
Yes, double quotes are supposed to be used for identifiers (i.e. names) only. Strings of characters must use single quotes. This is written in the SQL standard commonly referred to as "ANSI standard". Regardless of which SQL implementation you use, always enclose your table names and column names in double quotes, and your string values in single quotes.
Love you way you teach bit by bit, step by step, covering all of it!
Thank you! Glad it helped
Dude, great job. I'm gonna start following from now on!
exactly what i was looking for, thanks!
Good info, thank you !!!
Great video! glad I could be your 100th subscriber.
Thank you!
Thank you so much. It is really an interesting tutorial and easy to understand.
This video is Very helpful,
Thanks
thank you , vs code is much better than using the sqlite software
Is there any difference in syntax between Oracle SQL and SQLite?
7:33 Regarding username, it’s actually a 1:n relation, not 1:1. The same username can show up /n/ times in the videos table.
SQLite and Python are a potent combination. For example, I wrote a simple generator function called db_iter that, given an SQL query, returns an iterator over the query results. Saves continual messing about with cursors.
Another handy technique is using dict+zip on tuples of field names and returned field values, to produce a dictionary mapping the names to the values.
Hi @Lawrence, I'm looking for information something like this for my job interviews. (I have been trying to build simple ELT pipeline using SQLite and python )if possible could you please example links. thank you
@@swarupsudulaganti4821 You can see this function in action in one of my “Python Topics Notebooks” on Git
Hub.
thanks its helpful
strange, it dowsn´t work, perhabs i try to find a vid which shows, how to create folders with the name sqlite and connect with the database.
Can't create a table. Popup says I neeed to choose a connection profile from a list below. Then it offers to search for a connection. Apparently, VS Code has been modified to make this code impossible to execute. I burned up hours looking for an answer, but found nothing on the web so far.
Hi Mike, there is a problem with the SQLite extension V0.14.1 in VSC when trying to open database test.db file with right click. However, the test.db file ist ok when opened with sqlite3.exe. Unfortunately I did not find any solution to this issue. The training video by itself worked greate. Thank you very much!
can u advice someone to use sqlite for an android app like uber?
Whery nice explanaining, thank you.
Glad it was helpful!
Great info and you explain things very well, thank you! Do you have a tutorial on the next step of using php to display sqlite data on a webpage?
do have a video showing how to use this with PHP ua-cam.com/video/YqRvFS97hwo/v-deo.html. I have not made a specific video for web pages yet, but I plan to. If you want to get a head start, the basic idea is that a web form will be used to dynamically load data into the database. Reading data will work the exact same it will just be displayed in html instead of logged to the console. Please let me know if you have any questions :)
bro just use mysql for web pages, way easier
I keep getting "Code language not supported or defined." and can't run it.
Hi Mike, thanks for your good video.
anyways, How can i import .csv file into sqlite vscode ?
.mode csv
Don't we need to install sqlite locally in our pc .or is it ok to work in the vs code with extension .
You do not need to install it locally. This video covers everything
helpful video
Glad to hear that!
How to use this SQLite database with javascript?
I have a video on that. Node JS SQLite Crash Course (2022)
ua-cam.com/video/ZRYn6tgnEgM/v-deo.html
in case it helps = im a noob and got frustrated lost at about 14 mins. This might be above me though.
Missing so much detail how is this beginning. Vs code doesn't magically start up
I apologize for the confusion. There are many tutorial videos on UA-cam that will teach you how to install and run visual studio code on your device if you need help.
need db file to study
I get extremely frustrated watching someone train beginners like me and they are using studio interface features that have not been explained to the beginners. For example, at 11:05, I hear clickety-clack and it seems like the mouse points at line 1, and then magically two lines of code are commented out. How did those comment markers get placed there? The viewers get zero explanation on this. Likewise for other parts of the video. It's a challenge to follow without explanations being offered.
By the way, I have decades of experience in various languages and shells and studios, so it is not like I am stupid. This video is simply assuming users understand the VS Code Studio and also assumes viewers understand how and why the VS Studio Code is configured the way the video is using it. Those are invalid assumptions. I am disappointed. The expectation users have this VS Code knowledge and skill set just makes this harder than it has to be, and probably impossible for some people.