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.
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
12:50 Failed to open database 'c:\Users\vim\Desktop\Database_sqlite\test.db': Parse error near line 4: no such column: "table" - should this be a string literal in single-quotes? aster WHERE (type="table" OR type="view") error here ---^
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!
do have a video showing how to use this with PHP ruclips.net/video/YqRvFS97hwo/видео.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 :)
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.
I apologize for the confusion. There are many tutorial videos on RUclips that will teach you how to install and run visual studio code on your device if you need help.
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.
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.
I was stressed because some videos didn't teach how this extension worked, you saved me man! Thanks!
Love you way you teach bit by bit, step by step, covering all of it!
Thank you! Glad it helped
Great video! glad I could be your 100th subscriber.
Thank you!
exactly what i was looking for, thanks!
Dude, great job. I'm gonna start following from now on!
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.
thank you , vs code is much better than using the sqlite software
Thank you so much. It is really an interesting tutorial and easy to understand.
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.
Good info, thank you !!!
12:50 Failed to open database 'c:\Users\vim\Desktop\Database_sqlite\test.db': Parse error near line 4: no such column: "table" - should this be a string literal in single-quotes?
aster WHERE (type="table" OR type="view")
error here ---^
Whery nice explanaining, thank you.
Glad it was helpful!
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!
This video is Very helpful,
Thanks
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 ruclips.net/video/YqRvFS97hwo/видео.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
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.
Is there any difference in syntax between Oracle SQL and SQLite?
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 u advice someone to use sqlite for an android app like uber?
I keep getting "Code language not supported or defined." and can't run it.
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 RUclips that will teach you how to install and run visual studio code on your device if you need help.
helpful video
Glad to hear that!
thanks its helpful
Hi Mike, thanks for your good video.
anyways, How can i import .csv file into sqlite vscode ?
.mode csv
How to use this SQLite database with javascript?
I have a video on that. Node JS SQLite Crash Course (2022)
ruclips.net/video/ZRYn6tgnEgM/видео.html
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
in case it helps = im a noob and got frustrated lost at about 14 mins. This might be above me though.
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.