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

Python Simplified November 22, 2021
Video Thumbnail
Python Simplified Logo

Python Simplified

@pythonsimplified

About

Hi everyone! My name is Mariya and I'm a software developer from Sofia, Bulgaria. I film programming tutorials about Computer Science Concepts, GUI Applications, Machine Learning and Artificial Intelligence, Automation and Web Scraping, Data Science and even Math! 🤓 I'm here to help you with your programming journey (in particular - your Python programming journey 😉) and show you how many beautiful and powerful things we can do with code! 💪💪💪

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

You May Also Like

Essential Stove Making Kit

AI-recommended products based on this video

Loading...
AlloyMove Cordless Vacuum Cleaner, 550W 50KPA 70Mins Powerful Vacuum Cleaners for Home, with Anti-Tangle, LED Display Screen, Self-Standing Stick Vacuum for Hardwood Floors/Pet Hair/Carpet, A01

AlloyMove Cordless Vacuum Cleaner, 550W 50KPA 70Mins Powerful Vacuum Cleaners for Home, with Anti-Tangle, LED Display Screen, Self-Standing Stick Vacuum for Hardwood Floors/Pet Hair/Carpet, A01

(73)
$129.99
FREE delivery Fri, Feb 27
Loading...
limerencia Limerencia Small Hoop Earrings for Women, Hypoallergenic Titanium Huggie Hoop G23 Piercings Cartilage Earrings Set for Women Sensitive Ears(White CZ Silver, 8mm)

limerencia Limerencia Small Hoop Earrings for Women, Hypoallergenic Titanium Huggie Hoop G23 Piercings Cartilage Earrings Set for Women Sensitive Ears(White CZ Silver, 8mm)

(68)
$18.99
Loading...
Ultra-Slim Bidet Attachment, Posterior&Feminine Wash-(Retractable Dual Nozzles), Non-Electric Bidet Attachment for Toilet Seat, Adjustable Fresh Cold Water Pressure, Stainless Steel Inlet (White)

Ultra-Slim Bidet Attachment, Posterior&Feminine Wash-(Retractable Dual Nozzles), Non-Electric Bidet Attachment for Toilet Seat, Adjustable Fresh Cold Water Pressure, Stainless Steel Inlet (White)

(222)
$40.99
FREE delivery Sat, Apr 11
Loading...
Multi-Functional Vegetable Peeler for Kitchen,Vegetable Peeler Wooden Handle,2-in-1 Stainless Steel Fruit & Vegetable Peelers with Bottle Opener for Potato Pineapple (2PC)

Multi-Functional Vegetable Peeler for Kitchen,Vegetable Peeler Wooden Handle,2-in-1 Stainless Steel Fruit & Vegetable Peelers with Bottle Opener for Potato Pineapple (2PC)

(3)
$22.99
FREE delivery Apr 20 - 24
Loading...
Ultra-Slim Bidet Attachment, Posterior&Feminine Wash-(Retractable Dual Nozzles), Non-Electric Bidet Attachment for Toilet Seat, Adjustable Fresh Cold Water Pressure, Stainless Steel Inlet (White)

Ultra-Slim Bidet Attachment, Posterior&Feminine Wash-(Retractable Dual Nozzles), Non-Electric Bidet Attachment for Toilet Seat, Adjustable Fresh Cold Water Pressure, Stainless Steel Inlet (White)

(234)
$69.99
FREE delivery Fri, Mar 13
1K+ bought in past month
Loading...
Custom Graduation Tumbler Gifts for Him Her, Personalized Skinny Tumbler with Lid and Straws, Class of 2026 Gifts for Women Men, Graduation Cups Gift for Son Daughter, 20 oz Stainless Steel Tumbler

Custom Graduation Tumbler Gifts for Him Her, Personalized Skinny Tumbler with Lid and Straws, Class of 2026 Gifts for Women Men, Graduation Cups Gift for Son Daughter, 20 oz Stainless Steel Tumbler

(16)
$19.99
$10.99 delivery Feb 26 - Mar 10
Loading...
Philips Multigroom 3000 Series All-in-One 13-Piece Trimmer - Shaver and Clipper for Face, Head & Details, Self-sharpening Metal Blades, 8 Length Settings, Model MG3939/18

Philips Multigroom 3000 Series All-in-One 13-Piece Trimmer - Shaver and Clipper for Face, Head & Details, Self-sharpening Metal Blades, 8 Length Settings, Model MG3939/18

(2,623)
$29.95
FREE delivery Sun, Mar 29 on your first order
500+ bought in past month
Loading...
Philips All-in-One 20-Piece Trimmer 5000 Series - Shaver and Clipper for Face, Hair & Body, Self-sharpening Full Metal Blades, 12 Length Settings (0.5-16 mm), Precision Comb, MG5975/28

Philips All-in-One 20-Piece Trimmer 5000 Series - Shaver and Clipper for Face, Hair & Body, Self-sharpening Full Metal Blades, 12 Length Settings (0.5-16 mm), Precision Comb, MG5975/28

(2,609)
$49.95
FREE delivery Tue, Mar 24
1K+ bought in past month
Loading...
Ultra-Slim Bidet Attachment, Posterior&Feminine Wash-(Retractable Dual Nozzles), Non-Electric Bidet Attachment for Toilet Seat, Adjustable Fresh Cold Water Pressure, Stainless Steel Inlet (White)

Ultra-Slim Bidet Attachment, Posterior&Feminine Wash-(Retractable Dual Nozzles), Non-Electric Bidet Attachment for Toilet Seat, Adjustable Fresh Cold Water Pressure, Stainless Steel Inlet (White)

(222)
$40.99
FREE delivery Sat, Apr 11
Loading...
Multi-Functional Vegetable Peeler for Kitchen,Vegetable Peeler Wooden Handle,2-in-1 Stainless Steel Fruit & Vegetable Peelers with Bottle Opener for Potato Pineapple (2PC)

Multi-Functional Vegetable Peeler for Kitchen,Vegetable Peeler Wooden Handle,2-in-1 Stainless Steel Fruit & Vegetable Peelers with Bottle Opener for Potato Pineapple (2PC)

(3)
$22.99
FREE delivery Apr 20 - 24
Loading...
Ultra-Slim Bidet Attachment, Posterior&Feminine Wash-(Retractable Dual Nozzles), Non-Electric Bidet Attachment for Toilet Seat, Adjustable Fresh Cold Water Pressure, Stainless Steel Inlet (White)

Ultra-Slim Bidet Attachment, Posterior&Feminine Wash-(Retractable Dual Nozzles), Non-Electric Bidet Attachment for Toilet Seat, Adjustable Fresh Cold Water Pressure, Stainless Steel Inlet (White)

(234)
$69.99
FREE delivery Fri, Mar 13
1K+ bought in past month
Loading...
Custom Graduation Tumbler Gifts for Him Her, Personalized Skinny Tumbler with Lid and Straws, Class of 2026 Gifts for Women Men, Graduation Cups Gift for Son Daughter, 20 oz Stainless Steel Tumbler

Custom Graduation Tumbler Gifts for Him Her, Personalized Skinny Tumbler with Lid and Straws, Class of 2026 Gifts for Women Men, Graduation Cups Gift for Son Daughter, 20 oz Stainless Steel Tumbler

(16)
$19.99
$10.99 delivery Feb 26 - Mar 10