SQLite Backend for Beginners - Create Quick Databases with Python and SQL

[@netol02]

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.

[@biggerterry]

Let me add that the video was carefully edited to move along quickly. You spent your time to save my time. Much appreciated.

[@toulasantha]

Your voice is tailored for teaching. Definitive and clear with authority. All the best.

[@seraphweathers5808]

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!!!

[@novicetech1]

Wow! This is the best SQLite tutorial I've ever seen. Clear, concise, and to the point. Thank you.

[@Re4perZer0]

it boggles my mind how my professor couldn't explain this so simply as you did.

[@veebxl]

where have you been all my life ? it is all so clear in my head when you explain ! 🌼thank you so much !

[@thearchibaldtuttle]

As a seasoned silverback gorilla in IT I love to listen to this enthusiastic and capable presenter!

[@cajunstrat]

That was fun...just created my first sqlite python script. You are a great teacher.

[@davidgodinez7146]

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!

[@Headlikeanorange84]

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).

[@abdusamadabdullakhanov6732]

you know what? my mind is focusing on your beauty!!!!!!!!! not to your lessons! no, i find your video is helpful so much!!

[@danielschwan3298]

You're helping me a lot with writing an Inventory and cash register system. This tutorial comes in very handy

[@mauricealgorithm7320]

The first beautiful programmer on KZbin

[@chaimaghemati8713]

So simplified Mariya love so much, I hope my uni teachers simplify the things like you ❤❤

[@nikluz3807]

you are very good at explaining the code simply. thanks!

[@PythonSimplified]

Thank you so much! 😊

[@ClayMurray8]

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.

[@theblindprogrammer]

SQLite is so great that they even convinced Apple to use for their DBs, Core Data uses SQLite

[@CurrentElectrical]

My favourite tutorial so far, I was wanting to learn the basics of local sql, thank you Mariya. And hello from Ontario! Play safe.

[@PythonSimplified]

Yeeeey! Super happy to hear! 😃😃😃 A new Sqlite tutorial is coming out in 2 days so stay tuned! (webscraping data directly into a database)

[@zxbbvnm]

thank you so much for this! I'm studying database this semester and this is very big help🤩

[@PythonSimplified]

Thank you Lemuel! 😃 I'm super happy to help!!

[@theblindprogrammer]

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

[@halbodb]

Thanks for your tutorials. You are truly a great teacher! Please keep on going with the Python stuff... ❤️ 🐍

[@PythonSimplified]

Thank you so much!! 😃😃😃

[@kamertonaudiophileplayer847]

Sqlite is my favorite database. Thank you to provide a description of it for Python.

[@PythonSimplified]

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! 😉

[@kamertonaudiophileplayer847]

@@PythonSimplified I bet you target data scientists as myself.

[@9876rabi123456789]

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

[@PythonSimplified]

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: kzbin.info/www/bejne/bKHPh6aVrtl8fpo

[@pip07200]

Thank you for the clear explanation, as a total beginner.

[@PythonSimplified]

You're welcome! I'm glad you liked my explanation! 😃

[@fabian_ftn6604]

Just Right in time, I'm learning Databases on college and I wanted to make a SQL database now I can thx!

[@PythonSimplified]

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)

[@fabian_ftn6604]

@@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!!!)

[@ahmedutuber]

we need more explames like this ! Python and SQL

[@findthetruth3021]

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. 👏👏👏

[@historian2]

I liked the exotic pronunciation of the word "cursor"!

[@ForTheForsaken]

The way you say cursor is just adorable.

[@ryuyasho4468]

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 💜

[@PythonSimplified]

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! 😊

[@alexandermuir8160]

Argh Mariya, you make everything look and sound so easy. 🦘👍😉

[@PythonSimplified]

Thank you so much Alexander! 😃 That's why I'm here! 😉

[@johnmahugu]

more particularly, this tutorial is the best ever.

[@shiroiookami424]

Thanks for the tutorial I really love using SQL and exploring data

[@rajith_kumara_piyadasa]

Thanks & superb condensed explanation. Keep it up! 👏👏👏

[@melchiah6603]

SQLite is simple, easy, efficient and beautiful, widely used in embedded technologies, and currently on Android. Very good tutorial, thanks for the nice explanation.

[@theblindprogrammer]

Apple also uses for their Core Data DB

[@melchiah6603]

@@theblindprogrammer i did not know that Apple also uses it. Thanks for the information.

[@andrewmcbride88]

Wow, didn't expect this to be the most efficient tutorial ever. Thank you

[@diwakar_tsn]

Thanks for free course ❤️❤️🇳🇵

[@PythonSimplified]

Thank you for the comment and the hearts! 😀

[@behzodhoshimov3792]

I really enjoyed from the tutorial because it was clear to understand. Thanks so much 😊.

[@mtmanalyst]

Great stuff, thank you. Your explanations are very very good

[@arijanrahimic3210]

Perfectly explained as always! Can’t wait for the next step 🥇🙏✌️

[@AdamWeeksJ]

I love your style, content and the way you teach! #KeepUpTheGoodWork

[@romanhar4151]

Thank very much for this very structured, easy to understand and nice presented tutorial. 👍🙂🙂

[@flowi84]

Your explanations are so good. Thank You

[@Lemmy13]

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.😊

[@paolotagliente5786]

amazing ....such a clear and perfect explanation of concepts.....love your videos!!!

[@youcefmerah5707]

that what i called Python simplified ps : if you're new to python ! this channel will make your life a lot easier

[@PythonSimplified]

Thank you so much for your lovely comment Youcef! 😃😃😃 I really appreciate your support! 😊

[@user-gf7uz6lq4d]

That's great! Very clear and simple!

[@higiniofuentes2551]

Thank you for this very useful video!

[@nashenas1950]

Thank you so much I understood it very easily because of your presentation.

[@ce6872]

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😂

[@0x007A]

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.

[@johng5261]

She needs a foreign key for that

[@0x007A]

@@johng5261 true which is another reason a JOIN should have been demonstrated.

[@johng5261]

@@0x007A yeah the second table didn't really add any value if it doesn't have a relation

[@0x007A]

@@johng5261 I presumed the foreign key requirement was implied in my original comment. I should have been explicit. :-)

[@johng5261]

@@0x007A explicit better than implicit

[@dancomlex2012]

Increible, nunca había visto una programadora tan hermosa.

[@wexleyyt5931]

noooooooo i went to bed right before the premiere! great video as always though!

[@2Calam]

Wow, this was so good! I have been working with a few sql databases that were created by my teachers and I was trying to learn how to create my own. Yours was about the 10th video I tried and you were the first one to actually explain what the commands meant. I had no idea why people were typing connection or cursor. Thankyou! When we ran our search command: cursor.execute("select * from gta where city = :c", {"c": "Anywhere, USA"}) Could you please explain what the syntax city = :c does? Thanks again!

[@PythonSimplified]

Thank you so much! Super happy you found this tutorial helpful! 😃 With "city":c we assign a dictionary key named "c" to the column name "city". So "c" doesn't have to be "c" it could be anything you choose! It's best practice to avoid passing the actual values in an SQL query string (mostly for security reasons, from what I understand) So instead of passing the city name into the SQL command directly - we pass it as an attribute. So similar to where we used (?,?,?) As placeholders - "c" is also a placeholder for "liberty city". I hope it helps! 😊

[@2Calam]

@@PythonSimplified wonderful. Thankyou!

[@andrewthought3350]

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.

[@abdultheseekerofknowledge4453]

I've used PHP and it is total trash if it wasn't for all the legacy systems no one would use it imho

[@kirbyurner]

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.

[@PerseyNyasha]

I love you, thank you for your content😜

[@PythonSimplified]

Thank you so much for the lovely comment! 😃

[@sofiene4622]

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)

[@minhnguyenhainhat234]

your voice is so great to understand

[@sid_blr]

This is amazing. Thank you for making the video!!

[@PythonSimplified]

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 🙃

[@alliedatheistalliance6776]

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.

[@Jenko022]

This is excellent material and relatable data. Thanks 🎉🎉🎉

[@MrTaquiones]

Excelente, you are my dreamed teacher saludos desde Latinoamerica

[@CaribouDataScience]

Thanks that was helpful. What playlist is this video part of? Do you have a video using Pandas, data. frame and SQLite?

[@sirnatre]

I loved it, excellent all very clear, so it makes you want to go to classes every day of the year. Gracias Totales XD

[@Dylan_Miller]

Very helpful, thank you for taking the time to make this.

[@FritsvanDoorn]

Ok, that looked simple. Thank you.

[@PythonSimplified]

That's awesome! I'm happy to hear! 😃

[@nigelpallatt]

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

[@semtex2987]

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 😘

[@theblindprogrammer]

I never heard that, what is that? do you have vids about it?

[@majki5900]

Great explanation ! Thanks 🤓

[@PythonSimplified]

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: kzbin.info/www/bejne/g5yqgqCQpLKoiK8

[@noufalns8045]

Its very useful for my project well explained and easy code thanks mam❤️

[@destinedtocode666]

thank you very much! very clearly explained!

[@mbtv942]

Thanks for the wonderful explanation.

[@freezoulou]

ok lest try this :) is working you are the best ...now i have to try with flask

[@trtlphnx]

This Helps me On a Current Project SO MUCH ~ You Are As Resourceful As you Are Lovely, Sweetie ~

[@PythonSimplified]

That's awesome trtlphnx! I'm super happy to help!! 😃 What kind of project are you working on??? something exciting?? 😊

[@lycan2494]

Love the thumbnail 😘

[@lesteraxelballadareslopez5850]

Excellent video "thumbs up"

[@wildgorilla1205]

Cool, thanks!

[@DRAGON_FullPower]

Beautifull and smart, you're the dream of any man

[@groomy88]

Thanks so much. Really easy to follow!

[@marcellodichiera]

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 😊

[@PythonSimplified]

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 😊)

[@marcellodichiera]

@@PythonSimplified perfect, you read my mind with Mongo Di 😀.. thankssssse!!!

[@PythonSimplified]

@@marcellodichiera great minds think alike 😉

[@Tobs_]

Thanks Python Lady, another great video 👍

[@kamilaknapova8557]

Simply irresistible tutorial, thnx*

[@ferrari748]

Great explanation!

[@PythonSimplified]

Thank you! 😊

[@William593-n6x]

Thank you very much for your contribution! Please can you show us how to implement this database with flask? I try to do this but I get confused when entering the data through a form.

[@PythonSimplified]

Absolutley! We'll do this in the upcoming Flask + Sqlite tutorial! 😃 If you're really curious, I've already loaded the code to Github, you can find it here: github.com/MariyaSha/groceriesList I hope it helps you with your project! good luck! 😁

[@zaanmorningstar]

Solid video, thanks for the great detail!

[@ygjt76v0-----]

Your explain is slow and easy to understand

[@PythonSimplified]

Thank you! glad you found it easy! 😃

[@nescorrosete4830]

good work king, love you

[@kcoppa]

I love when the way she says. Cursor. "Core Sore"

[@the-game]

Thank you for this tutorial 🤩

[@joywins2dois2be43]

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])

[@adriannowik]

Impresionante Maryia !!!

[@marcusmorasalas5436]

I love your tutorials. Do you have some video about using json in python?

[@tigreonice2339]

Thank you. I love your channel

[@kennethstephani692]

Another great video!

[@patocuchara01]

I love sqlite on python, it just fits so well, and sqlite works perfectly for integrated tests in python.

[@andromydous]

If I was writing my own code, then I would test it multiple times as I go along. However, I just followed your lead (minus the constant testing). I wish I hadn't. I made so many typos.

[@Leonardo_A1]

Great introduction THANKs Leonardo

[@princeanirah]

Hello, I would like to know if you know of a way to convert SQLite Database to MS SQL. If so, can you walk me through it? Can you show multiple processes on what to do? and multiple tools that can be used to automate the database conversion.

[@JorgeEscobarMX]

This is really good tutorial. Python gives me anxiety (AWS Lambdas) but it seems like a very fun language when I see it on tutorials.

[@theblindprogrammer]

Python is easier to write unlike Java or C++ where you have to declare everything before you use them.

[@JorgeEscobarMX]

@@theblindprogrammer I would argue that's an advantage. You would be amazed how unpredictable a property becomes when you don't "enforce" a type on it.

[@theblindprogrammer]

@@JorgeEscobarMX I absolutely agree. At least in the beginner stage data type has to be enforced.

[@Optimusjf]

Thank you. This cristal clean.

[@asthmatic2455]

Hi, great video. Technical only - if you look at the contents of the sqlite database in any editor (even text), the data stored in it is freely readable, not encoded in any way.

[@serenadenphoto]

I love your videos but… Maryia, what you showed here wasn't exactly the sql way of joining two tables as I expected to learn more about.

[@PythonSimplified]

Hi Lars! 😃 You're right, this one is more of an introduction video which doesn't dive into too many details. If you already know the SQL command you'd like to use (I'm assuming it's the inner join one?) You can place it inside a cursor.executescript("my sql command") object 😃 If you need some more guidance on the inner join commands, checkout this tutorial: www.sqlitetutorial.net/sqlite-inner-join/ I couldn't check it myself as I'm away from my computer at the moment, but I hope it helps! 😊