What a fantastic tutorial! Worth every minute. As a mostly self-taught beginner programmer, I feel like I learned some really good coding practices too! Thank you so much
I'm a latecomer to the party, but this was a very good tutorial. I learned a lot. I will review this code carefully and try to implement this approach any time I need a database. Excellent stuff. Thanks.
Very good, thank you for your content! I had to put the video speed to 0.75 while working on my project, to clearly understand everything, and it worked out.
Thank you so much for this course. Apart from SQLITE. I also learnt more about how to call the function and arguments. It was so crisp and easy to understand . Thank you much for this video
This is an awesome video lesson (not coffee bean). Brief and simple but clear and easy to understand. Thanks. Will put this code into GUI as a tkinter project. Gracias.
Thanks my brother man, I have a task to submit for bookstore which will allow to update delete search an add using sqlite3 with menu to display with the input using function, u help me a lot by following this video
Thanks for a great tutorial. The only problems I had was the interface device between the chair I was sitting on and the computer keyboard. I do not think the 3 beers and a large vodka tonic had anything to do with it!. I got the whole thing done in less than 2 hours, including my errors. Thanks again.
Thx for this great tutorial. At 23:54 "...fetchone()", Would fetchall() instead work as well because the SQL command (LIMIT1) already limited the result to 1? just wondering
wow you are just so amazing! You explain so well and make your code very readable. you do have great coding practices I hope to pick up. Just one question though, I noticed you did not use the "cursor" is that something that is optional? some other tutorials I watched used cursor.connection and at the end cursor.close, connection.close. I would love if you can explain a bit about these use cases.
Hey, Jose! It's awesome video, but how about database and OOP classes? Did you think to create new video how to modify your program for getting data from database and recreating class?
or maybe just make a course on problem solving based on different topics and data structures like array , linkedlist , and greedy maybe. I think people will be interested in watching it . I'll buy for sure
Great tutorial. I got a question on the data model: shouldn't the name of the table (that is of the entity-type) be something like "coffee experiments"? Than the ill-named column "name" would be "bean". After all, we can imagine using "awesome arabica" once with a perlocator und once with the espresso method.
Walrus operator (:=) is the feature that was added in the Python 3.8 You've raised error because probably your python version is below 3.8. Update your python version will fix it.
Hey Abhas, we've got the Microblog video which uses Flask. Check out our channel! We're thinking about Django content, but we don't use it, so it's a bit tricker...
Sure thing ! You can use the SQL UPDATE statement to do that. For example: UPDATE beans SET method = "Filter" WHERE name = "My Bean"; Just don't forget the WHERE, as if you do you'll change every bean in your table. More info: pysql.tecladocode.com/section04/lectures/06_updating_data/
I wonder if replying 1 year later is late, but... if u are literally typing "import database", its wrong, u r meant to import the name of your database file.
Hi Oogie I understand that you posted this 9 months ago, but may I suggest that you copy the code from the screen. That is how I do it (see my post above). I am able to remember more of the code that way. Try it, and if that does not work for you, let me know and I will get the code to you somehow. Later mate
what if we didnt use sqlite3 module? we can still store the details in lets say dictionary and still access all the queries right? what is advantage of using SQL here ?
Using SQLite will let you store the data permanently, whereas leaving it in a dictionary means the data will be lost when the application ends. Also, the SQL language is very powerful and lets you query the data in ways that a normal dictionary doesn't (not as easily, at least).
Sir your speed is fast again screen is dark so we could not see list of beans, for query 2 and 3 it shows null. I could not hear and video does not show code
I am stuck with a coursework question and wasted 4 hours to solve it..if anyone could help me i would be very grateful.. so i got a list with composer names, place of publication, year etc and the question asks to
You talk and type very quick, hard to follow you sometimes, and then you even paste a lot of code .. at the end you said not to worry because the code would be available, but where to find the code?
I watched many tutorials about Sqlite, but the way you teach this, is really the best.
Thank you very much! Glad you liked it 😁
I've view many many tutorials on sqlite3 with python. None of them compare to this. Thank you so much. Subbed!
Thank you Dane! For both the comment and the sub!
Totally Agree! 100%100!
What a fantastic tutorial! Worth every minute. As a mostly self-taught beginner programmer, I feel like I learned some really good coding practices too! Thank you so much
After seeing a tons of videos on SQL I say this is the BEST tutorial of all times about SQL. Subscribed and liked.
As a coffee and coding lover, i had the BEST 37 minutes for today
I'm a latecomer to the party, but this was a very good tutorial. I learned a lot. I will review this code carefully and try to implement this approach any time I need a database. Excellent stuff. Thanks.
Very good, thank you for your content! I had to put the video speed to 0.75 while working on my project, to clearly understand everything, and it worked out.
That's awesome to hear, Alexander! Glad the video was helpful!
thanks for this Teclado, very helpful in the context of my internship at a start up!
Absolutely, a Beauty of a Video Honestly!
Really Appreciated Your Knowledge & Support on this!
Liked & Subscribed!
Thank you so much. This was the only helpful resource I could find.
Thank you so much for this course. Apart from SQLITE. I also learnt more about how to call the function and arguments.
It was so crisp and easy to understand . Thank you much for this video
hello sir, i am an student , i want to ask one question
@@harshtomar1475 what's your question?
Wooooww. It's amazing course for me. I enjoyed and learned much. Thanks for all!
Great video! One of the best about python and sqlite!Thank you so much!
This is an awesome video lesson (not coffee bean). Brief and simple but clear and easy to understand. Thanks. Will put this code into GUI as a tkinter project. Gracias.
This video is excellent! All very well explained. Thanks for sharing!
Thanks for clear and understandable explanations!
Very well thought out. 👏
Thanks my brother man, I have a task to submit for bookstore which will allow to update delete search an add using sqlite3 with menu to display with the input using function, u help me a lot by following this video
Glad it helped. Thanks for the comment and the kind words!
Excellent video. Muchisimas gracias José!
Hi! I'm just a beginner and just asking why you didn't use the commit() and the cursor in this program?
Bro you are so underrated keep foing great job ❤
I will! Thank you 💪
I have an error in the (user_input := input(MENU_PROMPT)) 25:40 help me please!
Thanks for a great tutorial.
The only problems I had was the interface device between the chair I was sitting on and the computer keyboard.
I do not think the 3 beers and a large vodka tonic had anything to do with it!.
I got the whole thing done in less than 2 hours, including my errors.
Thanks again.
Perfectly explained!!!
Thx for this great tutorial. At 23:54 "...fetchone()", Would fetchall() instead work as well because the SQL command (LIMIT1) already limited the result to 1? just wondering
It would, but you’d get a Cursor of one element instead of just the element directly.
This was awesome!
Thanks a lot!
Subbed!
Solid work, thanks!
Great tutorial !!.
Both on udemy and TH-cam you're a rockstar.
You’re the rock star Abhas Jha! 🔥
He sincerely is. The mode of presentation and above all, he always answers when you call with your challenge.
Thanks. SQliteStudio also provides access to the database.
wow you are just so amazing! You explain so well and make your code very readable. you do have great coding practices I hope to pick up.
Just one question though, I noticed you did not use the "cursor" is that something that is optional? some other tutorials I watched used cursor.connection and at the end cursor.close, connection.close. I would love if you can explain a bit about these use cases.
Hi I have a quick question...what about cursor in sql?
don't we need it?
I had the same question and found the answer in the Python sqlite documentation.
It is explained in the section Using sqlite3 efficiently
how can i do this with a greater existing database scraped from a website and saved as csv/json file?
Hey, Jose! It's awesome video, but how about database and OOP classes? Did you think to create new video how to modify your program for getting data from database and recreating class?
Your teaching is awesome by the way, please make a course on complete DSA with python !!
or maybe just make a course on problem solving based on different topics and data structures like array , linkedlist , and greedy maybe. I think people will be interested in watching it . I'll buy for sure
Great tutorial. I got a question on the data model: shouldn't the name of the table (that is of the entity-type) be something like "coffee experiments"? Than the ill-named column "name" would be "bean". After all, we can imagine using "awesome arabica" once with a perlocator und once with the espresso method.
That was great! THX
Great video! Liked & Subbed. But can't find the code/project link.
Thank you for awesome video clip
Great video! Is the example code available online?
Can we see multi line text (text box widget) in such program with sqlite 3.
For me the line while(user_input := input(MENU_PROMPT)) is giving syntax error. Can u tell y
Walrus operator (:=) is the feature that was added in the Python 3.8
You've raised error because probably your python version is below 3.8. Update your python version will fix it.
got stuck in minute 26 my terminal says File "/Users/orlandoortega/Desktop/datasbases/app.py", line 22, in
AttributeError: __enter__
I'm getting this error while running
def create_table(connection):
with connection:
Any Idea?
you need to add this at the end
connection.execute(CREATE_BEANS_TABLE )
Hey Jose, please do make a video on python flask /django app deployment
Hey Abhas, we've got the Microblog video which uses Flask. Check out our channel!
We're thinking about Django content, but we don't use it, so it's a bit tricker...
@@tecladocode Ah thanks
It's fine with flask I work with flask too
is there a way to update the record using user input???
ive been trying to find the answer for hours but i still havent found the solution
anyhelp???
I am unable to "import database"
Is there a download I am missing?
Would there be a way to set up a function that edits the method or the rating of a bean? If so what would it look like
Sure thing ! You can use the SQL UPDATE statement to do that. For example: UPDATE beans SET method = "Filter" WHERE name = "My Bean";
Just don't forget the WHERE, as if you do you'll change every bean in your table.
More info: pysql.tecladocode.com/section04/lectures/06_updating_data/
hi, "import database" actually doesn't work for me any ideas?
I am also having this problem!
I wonder if replying 1 year later is late, but...
if u are literally typing "import database", its wrong, u r meant to import the name of your database file.
@@BM-vq5rp how??
Is the final code any place we can download it and run it?
Hi Oogie
I understand that you posted this 9 months ago, but may I suggest that you copy the code from the screen.
That is how I do it (see my post above).
I am able to remember more of the code that way.
Try it, and if that does not work for you, let me know and I will get the code to you somehow.
Later mate
Bro, i become fan to your videos
Thank you so much 😀 Glad you're enjoying the videos!
Halo are you available to help someone struggling with tkinter n sqlite
OK, how we can run it, how we can see the result, interesting
Thank you so much! :)
When I run app.py I get an error sating No module named 'database'. Anyone have any ideas?
Figured it out
how?
very good tutorial I can get PowerPoint presentation file
any chans to get your code?
what if we didnt use sqlite3 module? we can still store the details in lets say dictionary and still access all the queries right? what is advantage of using SQL here ?
Using SQLite will let you store the data permanently, whereas leaving it in a dictionary means the data will be lost when the application ends. Also, the SQL language is very powerful and lets you query the data in ways that a normal dictionary doesn't (not as easily, at least).
@@tecladocode thanks!
Hi can you please show us how to do the insert query in this data base hope you'll notice me 🙏🥺
Nice!
Sir your speed is fast again screen is dark so we could not see list of beans, for query 2 and 3 it shows null. I could not hear and video does not show code
I am stuck with a coursework question and wasted 4 hours to solve it..if anyone could help me i would be very grateful.. so i got a list with composer names, place of publication, year etc and the question asks to
You have to divide your class in parts, with it's own introduction. Just to be more organized and understandable. Even thou, good video.
Thankyou sir
Thanks!!!
No problem!
I wanted to make a comment section for a ratings website.
elif user_input == '5':
connection.close()
print('Tanks for use this system')
break
Code?
You talk and type very quick, hard to follow you sometimes, and then you even paste a lot of code .. at the end you said not to worry because the code would be available, but where to find the code?
hi need you urgent help
Tbh he sounds like the male version of sypha from CastleVania
need internship
Terrible why where you speeing through it like someone put you in fast mode
I'm getting a "TypeError: "NoneType" object is not iterable", how can I fix this?