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

Рет қаралды 133,389

Күн бұрын

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.
⭐ Kite is a free AI-powered coding assistant that will help you code faster and smarter. The Kite plugin integrates with all the top editors and IDEs to give you smart completions and documentation while you’re typing. We made this KZfaq channel and Kite to help you be more productive: kite.com/download/?...
JOIN our online community of people who want to level up their developer skills ►
/ 505658083720291
Subscribe ► kzfaq.info?sub_...
***************************************
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 ►
• Python Tutorial - How ...
Web Scraping Baby Yoda ►
• WEB SCRAPING Baby Yoda...
Best IDEs for Python ►
• Best IDEs for Python
***************************************
Be sure to subscribe for tutorials, project breakdowns and more!
kzfaq.info?sub_...
STAY TUNED:
Kite ► kite.com/
KZfaq ► / @kitehq
Twitter ► / kitehq
***************************************
Keywords
postgresql python sqlite python python mysql sqlite3 python python mysql database connection tutorial

Пікірлер: 60

@arthurmiller5276 3 жыл бұрын

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.

@samuelstephens992 3 жыл бұрын

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.

@RocketFriday 3 жыл бұрын

Thank you! Exactly what I was looking for!

@MauricioSalazare 6 ай бұрын

That is the most helpful comment! Thanks!

@erictrautmiller1154 4 жыл бұрын

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

@it_is_ni 3 жыл бұрын

To be precise: it’s not built in. Python has code in its standard library to interact with SQLite databases and since they’re just files that works.

@lavienguyen8768 2 жыл бұрын

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

@nicholasyoa86 3 жыл бұрын

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.

@dwaynefong 11 ай бұрын

thank you simple concise and easy to follow

@KiteHQ 4 жыл бұрын

Like this tutorial? Join the Kite Developer Community on Facebook for access to more resources + support from fellow Python developers. Time to level up! facebook.com/groups/505658083720291

@prajwalshetty646 10 ай бұрын

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

@ihssancanmturk3842 4 жыл бұрын

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

@ahmedw5 Жыл бұрын

Fantastic tutorial, thank you.

@erin3670 Жыл бұрын

Great video, thanks.

@diusia 3 жыл бұрын

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

@DARKULTRAMADNESS 4 ай бұрын

I love this guy

@KiteHQ 4 жыл бұрын

Let us know what other topics we should cover! Thanks for watching [:

@davidbarrow 4 жыл бұрын

django + vue.js full stack apps would be good to see ;-)

@RahulMishra-np7fw 4 жыл бұрын

Django, kivy, machine learning

@martiangnome573 4 жыл бұрын

Can you teach Java in 1 sec?

@basavarajpatil9821 4 жыл бұрын

flask tutorials

@DJxSGGxNeo 3 жыл бұрын

Library dictionary tips? For C#? Things that could help boost workflow would be awesome.

@navneetyadav8869 3 жыл бұрын

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

@vitalijsawizki6816 3 жыл бұрын

thx is very helpfull for a beginner

@GaugingGadgets Жыл бұрын

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

@Neilcourtwalker 3 жыл бұрын

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

@Jason-de3oo 4 жыл бұрын

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?

@sottiesteve4559 2 жыл бұрын

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

@Agung-yk7hr Жыл бұрын

thanks man

@Leo-qf3ui 3 жыл бұрын

How to remove column header of output in SQLITE 3.28 ?

@SH-th4wy 4 ай бұрын

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

@kesukesu8453 3 жыл бұрын

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)

@VASSER574 3 жыл бұрын

two years later after learning this and I still don't get how this works exactly

@RahilPoladiya_B 2 жыл бұрын

Why do some people tripple qoute create command , some double qoute it and some single qoute it? Whats the difference between that

@maxxxiejazz 2 жыл бұрын

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.

@sakinetipallivenkatesh5309 4 жыл бұрын

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 cursor.execute("INSERT INTO stores values (11, 'sanath nagar, SN')") sqlite3.OperationalError: database is locked

@augurelite 2 жыл бұрын

THANKS

@mehdizahmatkesh1470 3 жыл бұрын

goooood

@joehilinski7008 3 жыл бұрын

Do you have the source code available?

@ryano699 7 ай бұрын

this just isnt working for me and I don't know why, when I click on the database on vs it just says the file is wrong and I get loads of red text saying null

@leonardkabasa1902 2 жыл бұрын

Halo are you available to help someone struggling with tkinter n sqlite

@VarghesePhilipKavungal 3 жыл бұрын

Tried to download kite. "Kite is currently unavailable."

@bxrbloxx2952 Жыл бұрын

why do i get this error sqlite3.OperationalError: near "EXIST": syntax error

@rayharper3268 Жыл бұрын

i'm having error which is database is locked how to remove this error

@Halahamante 4 жыл бұрын

the ad ends at 4:00

@Speed-tk4yk 3 жыл бұрын

haha you're so funny man

@rbfreitas 3 жыл бұрын

Great video. Btw, where is the database file located?

@evolade4044 3 жыл бұрын

same with the python file

@satyamanisrivastava7818 4 жыл бұрын

Can you make a video on kivy ( python library)

@KiteHQ 4 жыл бұрын

we'll take a look [:

@satyamanisrivastava7818 4 жыл бұрын

@twessels1234 3 жыл бұрын

how do you select the data in a table from the last 24 hours?

@danrosemon9084 Жыл бұрын

You would need to have created a column that specifies the time and date. Then, you would need to insert the current time upon creation of the row. Then your select statement will be asking when time:date between x and y.

@immeyouareu2633 7 ай бұрын

I’m going to use this. I went through hell programming a database in Java on a cloud server. Java is for punks. C# is a way better alternative if you share my opinion.

@vietdinh-van8018 4 жыл бұрын

I know this. This is the first experiment

@Altair19979752S 3 жыл бұрын

Well done video, but code would be nice

@magicmedia7950 2 жыл бұрын

Great tutorial but too fast

@ihebbibani7122 3 жыл бұрын

smart idea to do advertisment in the middle of the video to get our attention however this is not very welcomed for a viewer....The tradeoff is up to you now ; Is it more interesting to earn money from viewers or from your product ?