Learn to Program 19 Python SQLite Tutorial

In this part of my Learn to Program series I will show how to use SQLite with Python. We'll cover connect(), cursor(), execute(), commit(), rollback(), fetchall(), fetchone(), Select, Data Types, Create, Insert, Update, Delete, Alter, Backing up the Database and more.

Thank you to Patreon supports like the following for helping me make this video

@kyleaisho
@thetwistedhat
vjFaLk

[PureWaterSolutions]

As a data analyst that does complex sql and is learning python. This is my favorite episode this far! Makes Python fun for me at least. Thank you Derek for the great work!

[Achooification]

You make the internet a nice place. That's really hard.

The way you used rowfactories was great. I had been using pandas to pull in the entire table, then working with the dataframe to accomplish the same thing. But, this is really how I should be doing it.

Always a pleasure watching your videos Derek. Thank you very much.

[Neceros]

Great series. I would highly suggest looking into SQLAlchemy or MongoDB after this. Working with raw SQL is tedious and can be hazardous to new people.

[rydohg]

It feels good being on a noncancerous part of YouTube again

[KaletheQuick]

Derek, my powers are growing! I have a job with a cybersecurity firm now. Thank you for the tutorials!

[SaurabhKrT]

You are an amazing human on earth... Thanks for being here... :)

[shivakonar]

Thank you Derek! I always await Wednesday and Saturday :) You should probably release one video on Monday, would make waking up for work a whole lot easier :P

[Ivilness]

REALLY GREAT JOB....please make more! I am super hungry, although there is a lot i don't understand sometimes, it is interesting, and therefore, motivating..

[MegaGodfather]

Thanks a lot Derek!!! Really love your videos... Is it possible for you to do on PL/SQL.. Including all those exception, trigger, procedure and cursor!!!

[omuromakori]

Good videos all the time Derek. Will you mind to create videos on how to use mongodb?

[nivethalakshmikanth]

Great videos!! Thank you very much for all the videos. Can you please explain how to do data analysis using Python?

[pranetamahawar]

Is this the correct full form and definition for blob :
A Binary Large OBject (BLOB) is a collection of binary data stored as a single entity in a database management system. Blobs are typically images, audio or other multimedia objects, though sometimes binary executable code is stored as a blob. Database support for blobs is not universal.

[kvba]

Hi Derek, can you tell me where is the best place to put the code that creates (instantiates?) tables? In the constructor of my custom class, for example? I dont want the tables to be created every time i run my code, that doesnt make sense :)

Edit:
Nevermind, I have tackled the problem placing the code in the constructor of my DBTools class and changed the query to 'CREATE TABLE IF NOT EXISTS' Thanks for all the tutorials!

[ihssancanmturk]

Me think: wonderful this video tutorial, thank you for presenting and sharing! ;)

[btcuong]

It seems that there's a glitch at 17:16, the Total Rows should be 1 as you already rollback the delete :).

[Knightpro]

Thank you Derek for your videos,   I really look forward to them, and because of now getting into programming.P.S   how many more Python videos are there to come?  roughly...

[nicholast]

Thanks, Derek.
Why does theCursor.fetchall() return an array with [(0, 0)] as an element in an array? Why not just [0]?

[mussacharles]

Derek Banas Thanks a lot for the tutorials :) I followed the link you gave for sqlite3 tutorials finished that video but there are other 3 more videos on your sqlite3 playlist, do I need to study java first so that I can proceed to the other videos on your sqlite3 playlist?

[adasjot]

Great content. Can't wait for one on GUI!
Also, any Dream Theater fans here? You sound so much like Jordan Rudess, their keyboardist! Just a few tutorials more and I bet I'll start thinking it's the other way around. :)

[_misterwhy]

Hello D.! Thanks again to show us the PATH ^^

I have again a question ^^

If I want to know how the math, or os module is made (from math import * etc) (the source code), how do I get to it ?

Infinite thanks !