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
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.
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.
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
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?
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.
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.
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
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
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
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/
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?