Add to favorites
Today, we’re going to cover how to create and edit tables within a database using SQLite in Python. In this tutorial, we’ll create a database to manage data about a retail business with a few different locations. We’ll be storing information about each of our retail stores that are located across three different cities. We’ll also create a way to log data about purchases from these stores.
Download Kite free:
JOIN our online community of people who want to level up their developer skills ►
Subscribe ►
***************************************
Timestamps:
0:20 – What is SQLite?
0:45 – What uses SQLite
1:10 – Connection to db
2:00 – Create table query
3:00 – Select query
4:05 – Update and Delete
#sqlite #pythontutorials #python
***************************************
Additional Python Resources
Read and Write to CSV with Python ►
Web Scraping Baby Yoda ►
Best IDEs for Python ►
***************************************
Be sure to subscribe for tutorials, project breakdowns and more!
STAY TUNED:
Kite ►
YouTube ►
Twitter ►
***************************************
Keywords
postgresql python sqlite python python mysql sqlite3 python python mysql database connection tutorial
source
Like this tutorial? Join the Kite Developer Community on Facebook for access to more resources + support from fellow Python developers. Time to level up! https://www.facebook.com/groups/505658083720291
I've been using Python for over a year and I never realized it had a built in database. Thanks for posting this!
I know this. This is the first experiment
Can you make a video on kivy ( python library)
Let us know what other topics we should cover! Thanks for watching [: