Sqlite 3 Python Tutorial in 5 minutes - Creating Database, Tables and Querying [2020]

Показать описание

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.

JOIN our online community of people who want to level up their developer skills ►

***************************************
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:

***************************************
Keywords

postgresql python sqlite python python mysql sqlite3 python python mysql database connection tutorial

Рекомендации по теме

Комментарии

The tutorials are great! But please leave more than a tenth of a millisecond after typing a line of code to switch away from the screen or jump to a different section of code so it's easy to follow along.

arthurmiller

Thanks a bunch, this helps SOOO much! Really happy that I’ve found such an easy way to write to databases, so easy and nice. Thanks for the recommendation of the tool Kite also, as ...let’s just say I’m one of those programmers who die that while programming, sometimes while typing don’t auto fill themselves/have an option to. Kite makes it easier which is great. I’ll try it out when I can! From the looks of things it looks amazing.

nicholasyoa

You may want to note that in order to update the *.db file that is generated that a connection.commit() statement would be required or the data will not persist once the script exit.

samuelstephens

Thank you very much for this overview of SQLite3 and demonstration of Kite.

lavienguyen

I've been using Python for over a year and I never realized it had a built in database. Thanks for posting this!

erictrautmiller

thankyou for this tutorial, was about to start a project and this solved my doubts

prajwalshetty

really like your voice n information, keep the good work sire :)

navneetyadav

thank you simple concise and easy to follow

dwaynefong

Wonderful this super wonderful that video tutorial me think, thanks for presenting and sharing! ;)

ihssancanmturk

Thanks a lot for the video. When will you make more videos on sqlite?

Neilcourtwalker

whenever i comment one of the insert statement it leaves my database how do i make the info i put into my database not remove?

Jason-deoo

This was amazingly helpful! Thank you so much. Is Kite still available?

GaugingGadgets

Thanks a lot! Straight to the point and clear, perfect.

diusia

Great job there! How to I connect already stored data(in the server) into a database (with all the field intact)?
Thanks

sottiesteve

Thank you. At the end you've said you will do more db tutorials for Python. Is there something I'm missing? Cause I've been searching for that next video and I could'nt find it. This one dates 18 months ago.

maxxxiejazz

Thia is problem of my python script please help meAttributeError: partially initialized module 'sqlite3' has no attribute 'connect' (most likely due to a circular import)

kesukesu

Hello Kite,

when i execute through cmd getting error like ::
sqlite3.operational error: Database is locked
how can i resolve that. ???
ERROR::

C:\Users\home1\Documents>py data1.py
Traceback (most recent call last):
File "data1.py", line 18, in <module>
cursor.execute("INSERT INTO stores values (11, 'sanath nagar, SN')")
sqlite3.OperationalError: database is locked

sakinetipallivenkatesh

How do you know what your working directory is? Also, how do you save this?

SH-thwy

How to remove column header of output in SQLITE 3.28 ?

Leo-qfui

Do you have the source code available?

joehilinski

Sqlite 3 Python Tutorial in 5 minutes - Creating Database, Tables and Querying [2020]

Sqlite 3 Python Tutorial in 5 minutes - Creating Database, Tables and Querying [2020]

Python SQLite Tutorial: Complete Overview - Creating a Database, Table, and Running Queries

SQLite in Python || Python Tutorial || Learn Python Programming

SQLite Databases With Python - Full Course

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

Python | SQLite Datenbank Einstieg |

Python SQLite Tutorial: Build a Python project with a SQLite database

This SQLite Database Model is Easy and Ready for your Python Projects!

SQL For Data Analytics - By Victor Omondi

How to connect SQLite datbase with Visual Studio Code?

How to create Databases in Python with SQLite

SQLite Database With Python - #24

Python SQLite Data Entry Form with Tkinter tutorial for beginners - Python GUI project

Flask SQLite Web Application Step by Step Tutorial - HTML, Jinja, CSS, JavaScript, Python

How to Insert Into a SQLite Database in Python - Python Tutorial

Create GUI App with Tkinter and SQLite - Step by Step Python Tutorial for Beginners

Creating an Interactive SQLite Database in Python Tutorial for Beginners (2021)

Python SQLite Tutorial: Create , Insert and Retrieve data

SQLite 3 & Python Tutorials : #1 Creating DB & Establish Connection

Python Sqlite3 Tutorial | Sqlite3 Tutorial | How To Use SELECT Query In SQLite #sqlite3 #sqlite #new

Python Basics Tutorial Sqlite Working With Two Tables

Python SQLite Tutorial I LOVE json_extract() 😍

SQLite In Python: All CRUD Operations In SQLite & Python

Python Tutorial #11 - SQLite