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

Today we will talk about Sqlite, which is a library known for its quick and simple databases.
It is a database engine using the SQL language, which is probably even more intuitive and closer to plain English than Python (can you believe I'm saying that??? 😱😱😱)
With the help of Python, we will cover all the basics of creating databases, tables, inserting data into those tables, selecting and fetching database rows, searching data within the database and manipulating this data inside our code. All this - in less than 15 minutes!!! 🤩
(no wonder Sqlite is considered to be an incredibly easy library!)

⭐ Clone the Complete Lesson Code ⭐

Learn more about my Wayscript X:

Request an invitation to join Wayscript X:

📝 Starter Code 📝
**************************
release_list = [
(1997, "Grand Theft Auto", "state of New Guernsey"),
(1999, "Grand Theft Auto 2", "Anywhere, USA"),
(2001, "Grand Theft Auto III", "Liberty City"),
(2002, "Grand Theft Auto: Vice City", "Vice City"),
(2004, "Grand Theft Auto: San Andreas", "state of San Andreas"),
(2008, "Grand Theft Auto IV", "Liberty City"),
(2013, "Grand Theft Auto V", "Los Santos")
]

⏰ TIMESTAMPS ⏰
**************************
00:00 - Intro
00:27 - Starter Code Overview
00:51 - Create Empty Sqlite Database with Python
02:37 - SQL Cursor Object
03:02 - Create Database Table
03:42 - Sqlite Data Types
04:14 - Insert Multiple Rows of Data Into a Table
06:03 - Select and Print All Database Rows
06:47 - Select Specific Rows with Specific Values
08:29 - Combine Multiple Database Tables
11:06 - Manipulate Data Fetched from Database
13:04 - Coming Soon and Thanks for Watching! :)

🔔 Important Links 🔔
**************************
🐱‍🏍 Complete Code on Github:
🐱‍🏍 Sqlite3 Documentation:
🐱‍🏍 Icons used in the video:

[toulasantha]

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

[novicetech]

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

[netol]

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.

[seraphweathers]

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

[arijanrahimic]

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

[veebxl]

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

[cajunstrat]

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

[andrewmcbride]

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

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

[romanhar]

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

[danielschwan]

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

[rajith_kumara_piyadasa]

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

[paolotagliente]

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

[behzodhoshimov]

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

[halbodb]

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

[gfuzlqd]

That's great! Very clear and simple!

[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

[zaanmorningstar]

Solid video, thanks for the great detail!

[davidgodinez]

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!