Cursors in sqlite3 python are objects that act as a pointer to the results of a query. They enable you to fetch, add, modify or delete data from a database. The cursor can also be used to traverse through the rows of a query result.
@souzafelix Жыл бұрын
Didn't know Walter white was so good at teaching sqlite! Great video!
@Ricocase4 жыл бұрын
He already created a time outline of specific concepts in the video = instant upvote! Down-to-earth explanations > boss move!
@redfordwilson50424 жыл бұрын
I didn't know Walter White was also skilled in programming. Cool!
@hellelo.58404 жыл бұрын
I am the danger, Walter said while talking to his wife about hacking
@zl72894 жыл бұрын
This comment deserves more likes! 😂
@ShaileshKumar-fk8cu4 жыл бұрын
Hahahahahahahaha
@ayushjadaun49644 жыл бұрын
Maybe he is planning to hack Pentagon. This time
@CavanLeeSears4 жыл бұрын
You'll notice that almost every skilled programmer is a bald be-speckled goatie (stubble too) wearing guy. Including myself. :)
@dexternepo4 жыл бұрын
At 37:21 he mispronounces tuple as "toople" and then corrects himself after immediately remembering the correct pronunciation. As a non-native speaker of English from India, this brings a smile to my face. Because this is exactly what we do at times. When we learn English from textbooks, we have our pronunciation for some words, and then after watching native speakers pronounce it differently we try to remember the correct pronunciation. But still end up pronuncing it the way we first learned it in spite of knowing the correct way. The word that immediately comes to my mind that I personally mispronounce is "environment".
@MrMoKhalaf9 ай бұрын
🤣🤣🤣
@WillNicholson Жыл бұрын
Thanks John, this was really helpful. Just want to note something I got hung up on; if you delete the last row in a table, that rowid will be REUSED when you add a new item to the table UNLESS you use the AUTOINCREMENT keyword. In other words, if the last rowid is 6, and you delete it (and all of that person's data)... then the last rowid is 5. But, if you add a new item, the new person's data will be added to a row that ALSO has the rowid of 6. This can cause issues when referencing data by rowid later on.
@GameKnightOTRT11 ай бұрын
This is an older video but i found it very helpful so thank you first off! Secondly, if any of you are using VS Code instead of sublime you will need to make sure you are physically inside of the folder through the explorer tab. Once inside select the sqlite folder then go to git bash and follow his steps from there!
@logeszz_0710 ай бұрын
Bro how to run vscode instead of sublime please give proper steps
@026maheshkumars7 Жыл бұрын
I have finished this course...I have enjoyed every second in this course and i have learned lot of details... thankyou very much..
@dimjim23652 жыл бұрын
Wow, just wow. This is one superb course for beginners like myself. I followed the whole instructions and created an employees db. I reached a little far trying to incorporate nulls and blobs which caused me probs at the end. Ha. Had to drop back to the text and email demos but everything worked the first time after I corrected my typos. Ha. Thank you for a marvelous tutorial!
@myriamt63403 жыл бұрын
WALTER WHITE teaching me SQLITE, what a time to be alive :D
@medimarsh23763 жыл бұрын
in spite of all unfair comments, I have to say perfect video. Thanks!!!
@jagadeeshkumar7724 Жыл бұрын
He is enjoying himself.. he doesn't want the output to be displayed... What a gamer!!!!!
@MahdeenSky4 жыл бұрын
this is very easy to understand, good job, very few sqlite3 tutorials actually show the syntax of the sql knowledge and doesn't assume we learned the sql language beforehand, and this is one of them. Fantastic!
@MahdeenSky4 жыл бұрын
may i ask how do i move on from this tutorial into more functional sql?
@atomic_cow2 жыл бұрын
@@MahdeenSky howd it go
@jimcallahan4482 жыл бұрын
Made sense to me, but that was because I already knew SQL and the SQLite command line. Might be easier to demonstrate SQLite command line and then ask what if we want to do this as part of a larger Python program? At the SQLite command line one can immediately demonstrate the newly created table with: SELECT customers *; If a student asks, why not do everything in SQL? Ask the student, "What if you want to graph the data?" SQL doesn't have matplotlib or even the tools to produce a formatted report. So, Python and SQL (SQLite) make a good team.
@Vhoover36094 жыл бұрын
Hint: the print function accepts multiple arguments where each one is separated by a space when printed. I.e. print( item[0], item[1]) will print Jon Elders to the screen.
@Lennardish2 жыл бұрын
Hello John, I worked on a program that asks the number of records to be inserted: import sqlite3 conn = sqlite3.connect('student.db') #create a cursor c = conn.cursor() vnaam = ' ' #Inserting records aant = int(input('Number of records to be inserted')) for x in range(aant): vnaam = input("First name? :") anaam = input("Surname? :") rek = input("Arithmetic score :") taal = int(input("Language score :")) studenten = [ (vnaam, anaam, rek, taal) ] c.executemany("INSERT INTO studenten VALUES (?,?,?,?)", studenten) print("Inserted") #Commando uitvoeren conn.commit() #afsluiten! conn.close() And it works :) (Thanks to your clear way of instructing us :)
@aidynskullz41394 жыл бұрын
What kind of witch sorcery is this channel? As soon as I need to learn something for a project, a new course is released on the topic. This is insane and might be the tenth time it's happening. Keep up the good work!!!
@freecodecamp4 жыл бұрын
When deciding what course to post, our first thought is always "What does Aidyn Skullz need to learn right now?" 😀
@aidynskullz41394 жыл бұрын
@@freecodecamp haha LOL. Thanks for replying though XD.
@euphoric-therapeuticmusic53743 жыл бұрын
@@freecodecamp so you guys have everything ready? why not post all of them.
@tzwacdastag82234 жыл бұрын
⭐️Course Contents ⭐️ ⌨️ (0:00:00) What Is A Database ⌨️ (0:03:39) Install Python ⌨️ (0:07:07) Install Git Bash Terminal ⌨️ (0:11:52) Connect to Database in Python ⌨️ (0:17:39) Create A Table ⌨️ (0:28:13) Insert One Record Into Table ⌨️ (0:31:25) Insert Many Records Into Table ⌨️ (0:34:41) Query and Fetchall ⌨️ (0:37:02) Format Your Results ⌨️ (0:44:39) Primary Key ⌨️ (0:47:51) Use The Where Clause ⌨️ (0:51:17) Update Records ⌨️ (0:56:42) Delete Records ⌨️ (0:58:27) Order Results ⌨️ (1:01:37) And/Or ⌨️ (1:04:57) Limiting Results ⌨️ (1:07:27) Delete (Drop) A Table And Backups ⌨️ (1:09:14) Unit 18 Our App - Show All Function ⌨️ (1:14:16) Unit 19 Our App - Add A Record Function ⌨️ (1:17:51) Unit 20 Our App - Delete a Record Function ⌨️ (1:21:23) Unit 21 Our App - Add Many Records Function ⌨️ (1:24:57) Unit 22 Our App - Where Clause Function
@ferax45982 жыл бұрын
nice job copying the description
@benwards73982 жыл бұрын
In the delete section: Don''t convert the id to string in the app.py file instead convert it into an iterable by c.execute("DELETE FROM customers WHERE rowid = (?)", [id]) or c.execute("DELETE FROM customers WHERE rowid = (?)", (id,)) Thanks for the good video.
@drewsaga6533 Жыл бұрын
THANK YOU! I was wondering... great advice
@kitten_with_bad_breath16 күн бұрын
great! thanks :)
@unvunb7157 Жыл бұрын
very good instructor, of course you will need to know some python before you watch this video
@marwanrabi5450 Жыл бұрын
What a CrashCourse man!! AWESOME!!
@uucea4 жыл бұрын
This is the type of channel that will mold the next Bill Gates Few of us watching will create something revolutionary
@marcus.the.younger4 жыл бұрын
hopefully :)
@davidt013 жыл бұрын
Not sure if we want another one of him though.
@kitten_with_bad_breath19 күн бұрын
How is it going Bill?
@buckbuck2773 Жыл бұрын
c.execute("INSERT INTO Customers VALUES (?,?,?)", (List)) sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 3, and there are 2 supplied. I've rewound the video like dozens of times now and watched it. Finally I noticed that I'm using execute() instead of executemany(). c.executemany("INSERT INTO Customers VALUES (?,?,?)", List) now it works.
@tymothylim65503 жыл бұрын
Thank you John for this video! I watched the whole thing and it was really a well-planned lesson! This really helps me grasp the basics for sqlite3!
@dragonarch04 жыл бұрын
Me thinking about learning python KZbin : I see you wanna learn python,here you go
@aspodermousstoplight1004 жыл бұрын
Dragonarch youtube just knows man
@theboiyoulove51244 жыл бұрын
bruh i recommend you to learn python before watching this video
@euphoric-therapeuticmusic53743 жыл бұрын
Neuralink in action
@pipedreamsnetwerk51102 жыл бұрын
This was awesome. I was trying to figure out sqlite3. Thanks!!!
@techsutra4917 Жыл бұрын
thanks alot that was such an awesome video to learn basics about sql lite with python
@pkavenger99904 жыл бұрын
i love his style of teaching: "So guys what is SQL? I don't know.....................
@johndoe-rq4gf3 жыл бұрын
Hi! just a remark: contrary to what you say in the first part, SublimeText is free for evaluation but if you do read the little popup window (or the website) you have to buy a license for continuous usage, it's not a donation, it's a license.
@ghitanovandenlangenbergh58822 жыл бұрын
Learnt a lot from this video. The only thing I didn't get is how to reset your rowid after you have deleted something
@junioradi65544 жыл бұрын
Super and simple course which permits to understand the use of database into an application written using Python. Thank you sir
@i_am_dumb10709 ай бұрын
Really easy to follow along course loved the simple explanation thankyou
@srinjoyghosh72733 жыл бұрын
I saw his TKinter playlist too. Amazing teacher !
@Lucaischz4 жыл бұрын
As far as I know, docstrings aren't the same as triple quote strings. Docstrings are indeed expressed on tripple quote strings, but it means something more specific, which is the on code documentation for classes and functions, actually working as source code comments, but the syntax accepts this particular case because it's industry standard. Edit: also, as far as I know, SQL is case INSENSITIVE, actually, but it's good practice to capitalize reserved words to distinguish it from context defined elements (names, parameters, etc).
@pepijnkrijnsen43 жыл бұрын
Six months later but you're absolutely right
@anzhelazenaishvili73804 жыл бұрын
Hello ,I am starting to learn Data science,so I am beginer and this course it's very good for beginers,thank you very much!!!
@Meta9103 жыл бұрын
AMAZING....#just got re-candled again😊
@FlowGrapher4 жыл бұрын
Just started a new project in React-Native this SQLite course will help a lot for mobile dev. Thanks 🙏
@OnDoitConnaitre4 жыл бұрын
This Course is really easy to follow and super useful for people who want to start using SQLite, but I wanted to understand 'JOIN' concept which is not explained neither mentioned here, so i guess I will look for some more content.
@utkarshrastogi87914 жыл бұрын
Massive respect for these guys
@franfurey2 жыл бұрын
Amazing course! such a big teacher and explanation method!
@miltondias66172 жыл бұрын
Very simple and straight forward. Congrats!
@amirmohammadyazdani69293 жыл бұрын
Teacher: Say my name We: Heisenberg Teacher: YOU GOT DAMN RIGHT !
@zainabbasmerchant96503 жыл бұрын
Better than my college professor thanks a lot ✌
@kgduder1231 Жыл бұрын
JESSIE WE NEED TO CREATE A METH CUSTOMER DATABASE
@splungedude4 жыл бұрын
1:29:36 if you use: id = str(id) in the delete_one function the input will be converted to an interger
@pleabargain3 жыл бұрын
I worked through all of the code examples. Thank you! I have learned a lot!
@TURKISTONIM22 жыл бұрын
The best video course i will enrol on 👍👍👍👍👍👍
@Lennardish2 жыл бұрын
Hello John, I followed closely your instructions in using tkinter and making a database. I changed your example a bit, in that I only ask for a first name and underneath that a number of entry boxes in which scores on some test can be filled in. Two questions: 1. How to get the results in some listbox or something like that 2. How can I send the results to a printer. This printer thing a a huge challenge for me :) Thank you for your fantastic video's !!
@BabaBoota-lg2pq Жыл бұрын
you can execute this query SELECT * FROM [table name] and then you can just use this method fetchall() on the cursor while assigning it to a variable and now your variable simply contains a list of tuples and each tuple contains values of each row corresponding to the column names.
@vasileantoniupop54762 жыл бұрын
First helpful tutorial on this topic
@sambidao882 жыл бұрын
Thank you! The author made me understand to use Python that do CRUD a database incredibly
@shrishailgharat19644 жыл бұрын
John hope you are eating well and are healthy. Really loved the course. Thanks for the video and keeping it simple and short.
@johannesperez95483 жыл бұрын
Thanks John! Super useful! I learned a lot!!!
@boa21453 жыл бұрын
Hi John, I watched all clips. Thx for your full course "Sqlite databases with Python". Well done!!!
@EpicGamer-ux1tu2 жыл бұрын
Great video mate, I learned SQL and sqlite3 from you, thanks
@draganmilinov74953 жыл бұрын
Thank you very much on this video! It helped me. I'm beginner in programming. Python is my first programming language.
@MullahJeelan Жыл бұрын
You are amazing and you are way of teaching is brilliant and time saving
@cloudtechhills2 жыл бұрын
I appreciate your work on this tutorial. Thanks mate!
@shivangivishwasrao19832 жыл бұрын
Simply loved how crisp and to the point this course was. Thank you so much!
@vanshatcode4 жыл бұрын
Thanks a lot for this, seriously you are an incredible teacher.
@sabilislam76294 жыл бұрын
You Rock I roll... Seriously, This guy's videos are most helpful in the entire KZbin!
@drendelousАй бұрын
1:21:03 it worked with '6' as 🐍 doesnt treat 6 as a sequence (and we need to pass a sequence for: .execute(..., here). '6' is iterable and it handled the issue
@aniruddhakulkarni7004 жыл бұрын
Thank you for this Walter!
@shedquality3 жыл бұрын
If you're having trouble with this part of deleting a query with a rowid over 9 then look below c.execute("DELETE from customers WHERE rowid = (?)", id) It's because when you call the function database.delete_one('10') You will get the error " Incorrect number of bindings supplied. The current statement uses 1, and there are 2 supplied." to fix this, change rowid = (?)", id) to rowid = (?)", [id]) allowing database.delete_one('10') to work with double digits and more You no longer need to pass the function argument as a string - database.delete_one(10) will now work WITH or WITHOUT converting the numbers to string
@DiscordCriminal3 жыл бұрын
thank you
3 жыл бұрын
thx
@le_moski4 жыл бұрын
1:02:43 Epic bruh moment Excelent video btw
@tomlynn1000 Жыл бұрын
Clicking the like button at the start of the video is like tipping before you get your food.
@gamesandstuff77242 жыл бұрын
Many thanks, great video!
@juanopenx2 жыл бұрын
It would be good to show readonly vs read+write connections to the sqlite3 database file, which comes in handy if you're creating a flask web app which will be used by multiple individuals at once.
@nepsetraderspro3 жыл бұрын
Everyboy making only user database in whole KZbin video nobody make table for math calculations like account application income expense project But i applicate your work ❤️
@outofahat93632 жыл бұрын
Just discovered SQLite (Im already familiar with Maria/MySQL, Oracle, PostgreSQL) and im really digging it. Only one very easily portable .db file THATS IT thats the whole database. I love how little and compact and cute it is
@KingdomCre8tive2 жыл бұрын
You'll never get a job in it
@outofahat93632 жыл бұрын
@@KingdomCre8tive I don't need to, I'm a junior DBA i mostly deal with oracle, MySQL and postgres but in my spare time i like to experiment with other stuff and I found SQLite really neat.
@OlivierSuire4 жыл бұрын
17:44 it seems to me that databases really start making sense when they are comprised of MULTIPLE tables. I wish you would have touched this subject. Other than that : fantastic video ; it really helped.
@gabrielade7752 жыл бұрын
Great hands on course, thank you John
@tridevjha255 Жыл бұрын
Really helpful Video Made the bridge of knowledge which I needed from a long time One more time thank you
@espressobuzz12533 жыл бұрын
Surprised that value passed to query has to be a tuple. This does not work: cursor.execute("SELECT * FROM customers WHERE firstname=?", customer_first_name)
@mr.dineshlee4 жыл бұрын
Very Easy to Understand this one...🙏🏻
@shivomsrivastava65404 жыл бұрын
Nice tutorial, Mr. Anupam Kher
@vectoralphaSec10 ай бұрын
I dont know if you would answer any questions here on this specific video, most likely not, but ill ask anyway. I was wondering if SQLite would be ok to use in production as the default database for a small project? Im building a small web app in Django as a reference/ educational site and have a database of at most 50 records. I dont have the option for users or allowing user data so the database wont grow, it will stay at 50 rows. Is this ok for SQLite as my main database for my django project or should it only be used for development and instead use MySQL/ PostgreSQL?
@girishjain93302 жыл бұрын
Good explanation sir Thnks a lot 😊😊😊😊
@noir3713 жыл бұрын
Really appreciate everything this channel does!
4 жыл бұрын
Great tutorial You really dont need a college just KZbin is enough✌
@Deathwisher0694 жыл бұрын
Or maybe just the channels like freecodecamp 👍
@usamanadeem85044 жыл бұрын
damn true but youtube don't gives degree. hahaha
@dearstats61004 жыл бұрын
@@usamanadeem8504 with a degree if you can't do anything that is worst than not having a degree but skill
@usamanadeem85044 жыл бұрын
@@dearstats6100 and i am thinking what kind of the education system would be of a person if he/she got degree but don't have skills.
@rushikesh81324 жыл бұрын
@@usamanadeem8504 Well If that degree is gonna cost thousands of dollars . I am better of only with the skills !
@a_b_c_wan_2_333 жыл бұрын
This video is incredible.
@espressoshot214 жыл бұрын
Thank you for this super helpful video! Keep up the awesome work. I've been really enjoying your courses on KZbin. You're such an awesome instructor!
@ariansoltani6079 Жыл бұрын
Thank you for publishing this video and teaching smoothly .....very practical and useful 👌
@franklecky6570 Жыл бұрын
Really easy to understand course. Some very useful bits in there. Thanks John!
@YilmazDurmaz4 жыл бұрын
at 1:26:15 took me half a day to understand that little "quirk" of comma in "(email,)" and found out that it is also possible to write "[email]" as both cases returns an iterable.
@tonyfremont4 жыл бұрын
I'm really scratching my head 9n passing rowid as a string, and then it "just works". Stuff like this drives me crazy. I guess it's no worse than perl and the way it used the context of what it was seeing in the code instead of following a strict syntax grammar. perl can produce incredible results, but things written in it are pretty much unmaintainable. A write-only language. ;)
@YilmazDurmaz4 жыл бұрын
@@tonyfremont I am not sure if your comment should be under mine. but It seems what you mentioned is about parameter type of sqlite's execute function. I find it interesting and tried 2 changes, one is the I mentioned in my comment: send an integer rowid, as we normally would do, into delete function use it inside as either "(id,)" or "str(id)" in execute function.
@larslover6559 Жыл бұрын
Thank you so much John for the lesson! Your calm natural way of teaching is great!
@rahulgovindkumar31053 жыл бұрын
Thank you for this super helpful video!
@usmantariq56152 жыл бұрын
Excellent dude.. Very good course for beginners.
@melselvagem4 ай бұрын
Thank you so much, such a good explanation 😊
@Ishaan_Garud4 жыл бұрын
I am only 10 years old , but Understood everything easily
@spodarman38234 жыл бұрын
oh wow! i started coding at 12 ur lucky u got started early
@spodarman38234 жыл бұрын
im 15 rn
@captainpenny2122 Жыл бұрын
Thank you so much for this video, it was well planned and really helped me!!!
@Samiullahjaved-y2z Жыл бұрын
Thank you for this great course...
@ilyastrojnov76274 жыл бұрын
Thx for video! I think that best way for use database functions is optional args connection, we just create one connection and use it in all functions
@brianburch80623 жыл бұрын
Ah, thank you. This video cleared up a lot of things I was confused about.
@razredge073 жыл бұрын
Used 64 bit version of Python and world did not implode. So, hopefully everything will continue to be ok.
@husrad693 жыл бұрын
Thank you for this super helpful video! just one thing, normally you do not work with the Rowid!!! first, you have to search it! Second, you cannot delete Record with two digits in this way (like Record 10 or 15). the (?) takes only one number ('n').
@xgx67573 жыл бұрын
9 months later but use a dictionary key instead of (?) tuple
@George-hj6qm2 жыл бұрын
or use ...rowid=(?)", (id,))
@inan525510 ай бұрын
thank you for upload this video, very educational.
@waqarfk4 жыл бұрын
Awesome content Guyz....🔥
@avijitdebnath20664 жыл бұрын
You are amazing . Doing such a great job. I don't know how could I express my opinion to you! I don't know you believe in god or not. But I wish that god bless you. I feel like you are giving food to the poor hungry learners without asking money. Thank you again.
@RC-qi6hs4 жыл бұрын
Thanks to KZbin, im gonna complete my bachelor's before end of my 2nd semester of college 😂😂✌️