🛑 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: • Web Scraping Databases...
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: app.wayscript.com
⭐ Clone the Complete Lesson Code ⭐
app.wayscript.com/lairs/536ee...
Learn more about my Wayscript X:
wsxdocs.wayscript.com/
Request an invitation to join Wayscript X:
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:
github.com/MariyaSha/sqliteBa...
🐱🏍 Sqlite3 Documentation:
docs.python.org/3/library/sql...
🐱🏍 Icons used in the video:
flaticon.com
2 июн 2024
