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

Video Description

🛑 PLEASE NOTE 🛑 we need to add connection.commit() after each data insertion command!!! This will store all the rows permanently inside "gta.db", otherwise you might have trouble selecting from external files!! Find out exactly how to do it in my follow-up SQLite tutorial: https://youtu.be/MkGQmZoMuRM 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!) If you're curious about my IDE - I'm using Wayscript which is now available for the wide public! you no longer need an invitation, you can simply sign up with the following link: https://app.wayscript.com ⭐ Clone the Complete Lesson Code ⭐ https://app.wayscript.com/lairs/536eeab2-7b37-43d4-a604-12373397680b/public/ Learn more about my Wayscript X: https://wsxdocs.wayscript.com/ Request an invitation to join Wayscript X: https://wayscript.com/wsx 📝 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: https://github.com/MariyaSha/sqliteBasics 🐱‍🏍 Sqlite3 Documentation: https://docs.python.org/3/library/sqlite3.html 🐱‍🏍 Icons used in the video: flaticon.com