Straight to the point, clear, no fuzz. Stuck trying to figure out how to create a new sqlite db file and not even 5 minutes in and I'm already up and running! Thank you very much for your content and how detailed and clearly explained your tutorials are.
BLESS YOU!!!! ILY!!! I had spent hours learning SQL just so that i wouldn't have to pull data from .txt files like a caveman, and i was getting a bit frustrated while trying to impliment it in Python. Ran into this tutorial and you taught me in less than 15 minutes... All those other sql tutorials were a waste of time for what I was trying to do! Yet you're straight to the point, BAM this is how its done, and I love it!! Thank you!!!
Really great video! I'm going through all of these and learning a ton! I think the only suggestion I would give is to include a line for `connection.commit()` to save the data in the database. This is helpful is you want to have another script or do more with the data and don't have to deal with running this script every single time. Great work!
You're absolutely welcome! 😁 I'm posting an additional Sqlite tutorial in a few days! (web scraping an entire database with mechanical soup and sqlite3) so stay tuned! 😉
SQLite is one of my favorite things. The C API is so easy to use for it and makes it easy to embed into desktop applications. I use it for my game, level data, asset data, save data all SQLite databases. A huge advantage is: You can do migrations! So many games update and change their save format and now you can't open old saves in the new version of the game. Using SQLite as your save file it's not hard to write queries that will update and save file from the previous format.
SQLite is simple, easy, efficient and beautiful, widely used in embedded technologies, and currently on Android. Very good tutorial, thanks for the nice explanation.
Yeeeeeeey! what a perfect timing! I'm super happy I'm able to help!!! 😃 What DB management system are you learning about? (BTW, I'm also a student and I'm also taking databases in this semester hahahaha)
@@PythonSimplified We just started with databases and they are showing us the basics , I think we are going to use Microsoft Access at first and then move on to MySQL Lol. (Thank for your videos they are helpful keep it up!!!)
Gorgeous Mariya, good morning 😘 Just wanted to thank you for the Roadmap Learning video. After I watched it, couple of blocks I had got cleared out and now I can see better. I will follow that map to victory 💜
I'm so happy to hear that Ryuya! 😃 Everything is better with a game plan! 💪💪💪 Hopefully I'll be able to complete my Python for Beginners series soon, but in the meanwhile - I recommend checking out some introduction to Python courses on platforms like Udacity, Udemy, Coursera, Idx. They are always offering some beginners courses for free, so if you know what you want to learn - these online academies are a very valuable resource! 😊
Dear madam, your Python OOP videos helped me soo much to understand the complex concept of OOP. Thank you madam for helping me. I have a request to you that if you could come with a complete Django course...
Hi Rabi Roy! 😃 Thank you so much for the lovely comment, I'm so happy I was able to help! 😊 Django is certainly on my "to do" list and a complete tutorial is coming soon! I'm running a bit behind schedule as I got a new exciting project in the making, but I'm aiming to post a Django video in the next few weeks... hopefully, it will help you with your project! 😁 In the meanwhile, you can check out a similar framework to Django (called Flask) in this tutorial of mine: ruclips.net/video/6plVs_ytIH8/видео.html
Thank you so much! Super happy you liked it! 😃 Did you notice my code correction in the description with connection.commit() ??? Please add it after your insert commands to update the database file... otherwise it won't be saved 🙃
Thank you Mikolaj! 😃 Please don't forget to add connection.commit() after you insert the data, I missed it in this tutorial but mentioned it in the next one: ruclips.net/video/MkGQmZoMuRM/видео.html
I used to use PHP for creating websites for fun. You persuade me to try Python in order to learn this bright technology and learn some things on a different way.
It is really easy and loved the video, but I have the following questions. 1- how to upload data from CSV or Excel or Google sheets instead of the release list. 2- how to connect or import the created database with other platforms such us R language or Jupiter notebook. I will appreciate that if you can answer these questions above. Thanks in advance. 👏👏👏
some people doesn't think. Before they write. What is that video tutorial about? What people complain about are examples. It doesn't matter that examples are correct. It's about the code isn't it? thank you !. Python & sqllite basic understanding now checked.😊
When creating a table include this logic: cursor.execute("create table if not exists gta (release_year integer, release_name text, city text)") if not exists will stop the computer from trying to create a table again and crashing. FYI
Great Video Mariya, is very important for snake coders and data scientists to know libraries for SQL and also to know key sql language.. Brava as usual 😊
Thank you so much! I'm super glad you liked this tutorial! 😀 I think that anyone who uses frameworks like Flask and Django must have at least a bit of background with the backend side of things! And since Sqlite is super intuitive and easy to set up - I really wanted to start from it 😉 I'll be covering other management systems like MySql and No-SQL shortly (MongoDB, for example, is super interesting to me! I'd love to give it a try and present it on this channel... hopefully we'll get to it quickly 😊)
If office folks were more familiar with sqlite3 they could pass around structured data more effectively than they do using spreadsheets. I’m a big fan of spreading sqlite3 as an everyday productivity format. Versus spreadsheets.
The for-loop could be replaced by a INNER JOIN statement which might make it easier for beginners to understand. This is still a good introduction to basic SQL with Python. Hope your computer science studies are going well.
nice introduction 👍 i used and use sqlite alot for quick & dirty stuff or simple demos. for anything else, tortoise orm is my way to go - once one worked with dataclasses it's hard to go back 😉 perhaps you do a video about that some time, could be an eye opener for a lot of people 😘
If anyone else thought that the last part updated the database, just to be clear it doesn't, it fetches the data in a list and changes the values there, the original table remains the same.
cursor.execute("create table gta (release_year integer, release_name text, city text)") sqlite3.OperationalError: table gta already exists I had to turn the line that creates the database into a comment to avoid this error. I am not sure if I missed that in your video but as a beginner it's not going to be my first guess to do that. That oversight throws a spanner in the whole program too.
You would usually create the database separately from the flow of your program. sqlite3.connect("gta.db") in the context of this tutorial is used to create the dataset, however - if this dataset already exists in this directory, then it is used to read from it 😉 So in a stand alone file - you can create the dataset in advance and fill it with all the records you require. So that within the program itself - you don't need to add new tables. You can add or remove records from existing tables, but generally - the database with all its tables should already exist before your program begins its execution. I hope it helps! 😃 (Please note: you'll also need a connection.commit() command after you insert values to the table, I missed it in the tutorial, but you can find it in the Github repo) Cheers! :)
@@PythonSimplified thank you for taking the to respond with so much information, I realise my comment may have read a little bluntly once I read it back but and so it was extra kind of you to politely reply.
@ForTheForsaken hahahaha I don't think you were blunt, but even if you were - it's perfectly OK to be blunt on this channel! 😉 If something doesn't work or holds you back from understanding - please keep sharing it in the comments! I am learning a lot from viewer feedback helping whenever possible, and then using it to produce better tutorials 🙂
Hey sorry for being too late to the party :) just a quick question. On 12:26 you manually traced the indexes of where the fictional city is as to what real city it correspond to in the Db and you hardcoded the indexes for the condition. Just curious how can you dynamically have the condition check let's say all 4 fictional cities and their corresponding real cities? Assuming we populated all 4 cities in the new table. Instead of saying search_cities [0][1] if search_cities [0][0] I would like to do the evaluation using text. My brain stopped working, how would you approach that? I hope my question is clear.
thank you very much for kind teaching. Because we get 3 columns from "select * from gta", and there are 3 columns in a row of gta_search, so I want to know how value is 'city'. cursor.execute("create table gta (release_year integer, release_name text, city text)") cursor.execute("select * from gta where city=:c", {"c": "Liberty City"}) gta_search = cursor.fetchall() for i in gta_search: print(["New York" if value == "Liberty City" else value for value in i])
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Your voice is tailored for teaching. Definitive and clear with authority. All the best.
Straight to the point, clear, no fuzz. Stuck trying to figure out how to create a new sqlite db file and not even 5 minutes in and I'm already up and running! Thank you very much for your content and how detailed and clearly explained your tutorials are.
Let me add that the video was carefully edited to move along quickly. You spent your time to save my time. Much appreciated.
BLESS YOU!!!! ILY!!! I had spent hours learning SQL just so that i wouldn't have to pull data from .txt files like a caveman, and i was getting a bit frustrated while trying to impliment it in Python. Ran into this tutorial and you taught me in less than 15 minutes... All those other sql tutorials were a waste of time for what I was trying to do! Yet you're straight to the point, BAM this is how its done, and I love it!! Thank you!!!
Wow! This is the best SQLite tutorial I've ever seen. Clear, concise, and to the point. Thank you.
where have you been all my life ? it is all so clear in my head when you explain ! 🌼thank you so much !
As a seasoned silverback gorilla in IT I love to listen to this enthusiastic and capable presenter!
you know what? my mind is focusing on your beauty!!!!!!!!! not to your lessons! no, i find your video is helpful so much!!
That was fun...just created my first sqlite python script. You are a great teacher.
The way you say cursor is just adorable.
The first beautiful programmer on RUclips
Really great video! I'm going through all of these and learning a ton! I think the only suggestion I would give is to include a line for `connection.commit()` to save the data in the database. This is helpful is you want to have another script or do more with the data and don't have to deal with running this script every single time. Great work!
Thanks a bunch! I was wondering why I got an empty database message when doing the Basic Guide to Pandas (in which this database is loaded).
it boggles my mind how my professor couldn't explain this so simply as you did.
So simplified Mariya love so much, I hope my uni teachers simplify the things like you ❤❤
You're helping me a lot with writing an Inventory and cash register system. This tutorial comes in very handy
Sqlite is my favorite database. Thank you to provide a description of it for Python.
You're absolutely welcome! 😁
I'm posting an additional Sqlite tutorial in a few days! (web scraping an entire database with mechanical soup and sqlite3) so stay tuned! 😉
@@PythonSimplified I bet you target data scientists as myself.
thank you so much for this! I'm studying database this semester and this is very big help🤩
Thank you Lemuel! 😃 I'm super happy to help!!
Have you learned Core Data yet? that is the DB system Apple uses for their products. It is awesome if you want to save data in iphones/ipads
SQLite is one of my favorite things. The C API is so easy to use for it and makes it easy to embed into desktop applications. I use it for my game, level data, asset data, save data all SQLite databases. A huge advantage is: You can do migrations! So many games update and change their save format and now you can't open old saves in the new version of the game. Using SQLite as your save file it's not hard to write queries that will update and save file from the previous format.
SQLite is so great that they even convinced Apple to use for their DBs, Core Data uses SQLite
My favourite tutorial so far, I was wanting to learn the basics of local sql, thank you Mariya. And hello from Ontario!
Play safe.
Yeeeey! Super happy to hear! 😃😃😃
A new Sqlite tutorial is coming out in 2 days so stay tuned! (webscraping data directly into a database)
that what i called Python simplified
ps : if you're new to python ! this channel will make your life a lot easier
Thank you so much for your lovely comment Youcef! 😃😃😃
I really appreciate your support! 😊
Wow, didn't expect this to be the most efficient tutorial ever. Thank you
SQLite is simple, easy, efficient and beautiful, widely used in embedded technologies, and currently on Android. Very good tutorial, thanks for the nice explanation.
Apple also uses for their Core Data DB
@@theblindprogrammer i did not know that Apple also uses it. Thanks for the information.
I liked the exotic pronunciation of the word "cursor"!
Thanks for your tutorials. You are truly a great teacher! Please keep on going with the Python stuff... ❤️ 🐍
Thank you so much!! 😃😃😃
Thank you for the clear explanation, as a total beginner.
You're welcome! I'm glad you liked my explanation! 😃
Just Right in time, I'm learning Databases on college and I wanted to make a SQL database now I can thx!
Yeeeeeeey! what a perfect timing! I'm super happy I'm able to help!!! 😃
What DB management system are you learning about? (BTW, I'm also a student and I'm also taking databases in this semester hahahaha)
@@PythonSimplified We just started with databases and they are showing us the basics , I think we are going to use Microsoft Access at first and then move on to MySQL Lol.
(Thank for your videos they are helpful keep it up!!!)
we need more explames like this ! Python and SQL
Thanks & superb condensed explanation. Keep it up! 👏👏👏
Thanks for free course ❤️❤️🇳🇵
Thank you for the comment and the hearts! 😀
Argh Mariya, you make everything look and sound so easy. 🦘👍😉
Thank you so much Alexander! 😃 That's why I'm here! 😉
Thanks!
Gorgeous Mariya, good morning 😘 Just wanted to thank you for the Roadmap Learning video. After I watched it, couple of blocks I had got cleared out and now I can see better. I will follow that map to victory 💜
I'm so happy to hear that Ryuya! 😃 Everything is better with a game plan! 💪💪💪
Hopefully I'll be able to complete my Python for Beginners series soon, but in the meanwhile - I recommend checking out some introduction to Python courses on platforms like Udacity, Udemy, Coursera, Idx. They are always offering some beginners courses for free, so if you know what you want to learn - these online academies are a very valuable resource! 😊
Thank very much for this very structured, easy to understand and nice presented tutorial. 👍🙂🙂
I love your style, content and the way you teach! #KeepUpTheGoodWork
I really enjoyed from the tutorial because it was clear to understand. Thanks so much 😊.
you are very good at explaining the code simply. thanks!
Thank you so much! 😊
more particularly, this tutorial is the best ever.
Thank you for this very useful video!
Your explanations are so good. Thank You
amazing ....such a clear and perfect explanation of concepts.....love your videos!!!
Great stuff, thank you.
Your explanations are very very good
That's great! Very clear and simple!
Thanks for the tutorial I really love using SQL and exploring data
Perfectly explained as always! Can’t wait for the next step 🥇🙏✌️
I loved it, excellent all very clear, so it makes you want to go to classes every day of the year. Gracias Totales XD
Dear madam, your Python OOP videos helped me soo much to understand the complex concept of OOP. Thank you madam for helping me.
I have a request to you that if you could come with a complete Django course...
Hi Rabi Roy! 😃
Thank you so much for the lovely comment, I'm so happy I was able to help! 😊
Django is certainly on my "to do" list and a complete tutorial is coming soon! I'm running a bit behind schedule as I got a new exciting project in the making, but I'm aiming to post a Django video in the next few weeks... hopefully, it will help you with your project! 😁
In the meanwhile, you can check out a similar framework to Django (called Flask) in this tutorial of mine:
ruclips.net/video/6plVs_ytIH8/видео.html
your voice is so great to understand
When I saw you I thought to myself "I'm in love" but I'm no simp...then I saw the GTA example,well I really am in love😂
Thank you so much I understood it very easily because of your presentation.
Increible, nunca había visto una programadora tan hermosa.
Love the thumbnail 😘
Excelente, you are my dreamed teacher saludos desde Latinoamerica
This is amazing. Thank you for making the video!!
Thank you so much! Super happy you liked it! 😃
Did you notice my code correction in the description with connection.commit() ??? Please add it after your insert commands to update the database file... otherwise it won't be saved 🙃
noooooooo i went to bed right before the premiere! great video as always though!
This is excellent material and relatable data. Thanks 🎉🎉🎉
Thank you very match. it's really so easy I mean we dont need any server to use a data base. (thanks again from Tunisia)
Great explanation ! Thanks 🤓
Thank you Mikolaj! 😃
Please don't forget to add connection.commit() after you insert the data, I missed it in this tutorial but mentioned it in the next one:
ruclips.net/video/MkGQmZoMuRM/видео.html
I used to use PHP for creating websites for fun. You persuade me to try Python in order to learn this bright technology and learn some things on a different way.
I've used PHP and it is total trash if it wasn't for all the legacy systems no one would use it imho
It is really easy and loved the video, but I have the following questions.
1- how to upload data from CSV or Excel or Google sheets instead of the release list.
2- how to connect or import the created database with other platforms such us R language or Jupiter notebook.
I will appreciate that if you can answer these questions above. Thanks in advance. 👏👏👏
good work king, love you
Its very useful for my project well explained and easy code thanks mam❤️
ok lest try this :) is working you are the best ...now i have to try with flask
Cool, thanks!
some people doesn't think.
Before they write. What is that video tutorial about? What people complain about are examples. It doesn't matter that examples are correct. It's about the code isn't it?
thank you !. Python & sqllite basic understanding now checked.😊
I love you, thank you for your content😜
Thank you so much for the lovely comment! 😃
thank you very much! very clearly explained!
Another great video!
Simply irresistible tutorial, thnx*
Thanks for the wonderful explanation.
Solid video, thanks for the great detail!
When creating a table include this logic: cursor.execute("create table if not exists gta (release_year integer, release_name text, city text)") if not exists will stop the computer from trying to create a table again and crashing. FYI
Very helpful, thank you for taking the time to make this.
Thanks Python Lady, another great video 👍
Thank you. I love your channel
Excellent video "thumbs up"
Great Video Mariya, is very important for snake coders and data scientists to know libraries for SQL and also to know key sql language.. Brava as usual 😊
Thank you so much! I'm super glad you liked this tutorial! 😀
I think that anyone who uses frameworks like Flask and Django must have at least a bit of background with the backend side of things! And since Sqlite is super intuitive and easy to set up - I really wanted to start from it 😉
I'll be covering other management systems like MySql and No-SQL shortly (MongoDB, for example, is super interesting to me! I'd love to give it a try and present it on this channel... hopefully we'll get to it quickly 😊)
@@PythonSimplified perfect, you read my mind with Mongo Di 😀.. thankssssse!!!
@@marcellodichiera great minds think alike 😉
Impresionante Maryia !!!
Thank you for this tutorial 🤩
Beautifull and smart, you're the dream of any man
Ok, that looked simple. Thank you.
That's awesome! I'm happy to hear! 😃
Thanks so much. Really easy to follow!
If office folks were more familiar with sqlite3 they could pass around structured data more effectively than they do using spreadsheets. I’m a big fan of spreading sqlite3 as an everyday productivity format. Versus spreadsheets.
Great explanation!
Thank you! 😊
This Helps me On a Current Project SO MUCH ~
You Are As Resourceful As you Are Lovely, Sweetie ~
That's awesome trtlphnx! I'm super happy to help!! 😃
What kind of project are you working on??? something exciting?? 😊
The for-loop could be replaced by a INNER JOIN statement which might make it easier for beginners to understand. This is still a good introduction to basic SQL with Python. Hope your computer science studies are going well.
She needs a foreign key for that
@@johng5261 true which is another reason a JOIN should have been demonstrated.
@@0x007A yeah the second table didn't really add any value if it doesn't have a relation
@@johng5261 I presumed the foreign key requirement was implied in my original comment. I should have been explicit. :-)
@@0x007A explicit better than implicit
Thank you. This cristal clean.
This video is awesome.
Your explain is slow and easy to understand
Thank you! glad you found it easy! 😃
Thank you, it helps a lot!
nice introduction 👍
i used and use sqlite alot for quick & dirty stuff or simple demos.
for anything else, tortoise orm is my way to go - once one worked with dataclasses it's hard to go back 😉
perhaps you do a video about that some time, could be an eye opener for a lot of people 😘
I never heard that, what is that? do you have vids about it?
Great video!
Excellent 👑
I love sqlite on python, it just fits so well, and sqlite works perfectly for integrated tests in python.
If anyone else thought that the last part updated the database, just to be clear it doesn't, it fetches the data in a list and changes the values there, the original table remains the same.
Great introduction THANKs Leonardo
I have never ever seen such amazing presentation.
you are awesome girl thank you for sharing this tutorial
beautiful 💖💖❣❣💔💯
Thanks that was helpful. What playlist is this video part of? Do you have a video using Pandas, data. frame and SQLite?
cursor.execute("create table gta (release_year integer, release_name text, city text)")
sqlite3.OperationalError: table gta already exists
I had to turn the line that creates the database into a comment to avoid this error. I am not sure if I missed that in your video but as a beginner it's not going to be my first guess to do that. That oversight throws a spanner in the whole program too.
You would usually create the database separately from the flow of your program.
sqlite3.connect("gta.db") in the context of this tutorial is used to create the dataset, however - if this dataset already exists in this directory, then it is used to read from it 😉
So in a stand alone file - you can create the dataset in advance and fill it with all the records you require. So that within the program itself - you don't need to add new tables. You can add or remove records from existing tables, but generally - the database with all its tables should already exist before your program begins its execution.
I hope it helps! 😃
(Please note: you'll also need a connection.commit() command after you insert values to the table, I missed it in the tutorial, but you can find it in the Github repo)
Cheers! :)
@@PythonSimplified thank you for taking the to respond with so much information, I realise my comment may have read a little bluntly once I read it back but and so it was extra kind of you to politely reply.
@ForTheForsaken hahahaha I don't think you were blunt, but even if you were - it's perfectly OK to be blunt on this channel! 😉
If something doesn't work or holds you back from understanding - please keep sharing it in the comments! I am learning a lot from viewer feedback helping whenever possible, and then using it to produce better tutorials 🙂
@@PythonSimplified Do not give a british man free reign to complain about things... That's just asking for trouble :D
Hey sorry for being too late to the party :) just a quick question. On 12:26 you manually traced the indexes of where the fictional city is as to what real city it correspond to in the Db and you hardcoded the indexes for the condition. Just curious how can you dynamically have the condition check let's say all 4 fictional cities and their corresponding real cities? Assuming we populated all 4 cities in the new table. Instead of saying search_cities [0][1] if search_cities [0][0] I would like to do the evaluation using text. My brain stopped working, how would you approach that? I hope my question is clear.
Time to learn some SQL :)
thank you very much for kind teaching.
Because we get 3 columns from "select * from gta",
and there are 3 columns in a row of gta_search, so I want to know how value is 'city'.
cursor.execute("create table gta (release_year integer, release_name text, city text)")
cursor.execute("select * from gta where city=:c", {"c": "Liberty City"})
gta_search = cursor.fetchall()
for i in gta_search:
print(["New York" if value == "Liberty City" else value for value in i])