Python SQLite Basics

This video demonstrates the basics of using SQLite in Python with the sqlite3 library. I cover how to set up a connection to a database, creating tables, inserting rows, getting rows and commits/rollbacks.

🐍 In this video I use Python 3.5.
👍🏼 Feel free to comment with any issues.

[CanvasMC]

the simplicity of your examples is where the brilliance lies.... so good!

[probablyalive]

Before I watched this video I literally had no clue of SQLite, after I watched it I feel confident that I know enough for my purposes, thank you :)

[Smell-O-Vision-Citrus]

This channel saves my ass multiple times per month, I don't know how we've learned python in such similar trajectories, but I'm glad we have, cause this is always top notch quality content.

[zzzanon]

Great video. Straight to the point, no funny business, plain English explanations. Thank you

[deadlock]

Lots of useful information in minutes, thanks!

[elhamaryanpur]

anyone else think this channel is under rated?

[AkOsIrAnUto]

Bro, I've learned a lot more than my 3-hour class with SQL in Python. Thank you, :)

[isaac]

I like your way of teaching! Thank you so much :)

[mujeebishaque]

This guy teaches everything better than my professors having 20+years experience.

[vivins]

It's amazing to learn from u
Could u teach us how to get specific information from a database table and use it in programming
Eg:
If we create a data table of name and salary and basic pay
I need to take information of a basic pay and salary of a person and use it in computation total salary=salary- basic pay


Teach more about sqlite in python it's function, usage etc

[dgbene]

Thank you. This was very helpful.
Does using row object instead of tuples (connection.row_factory = sqlite3.Row) affect performance? Is there any trade off for the convenience?

[okuamaneyi]

Good work dude, keep it!
I just have a question. Which fonts did u use on idle?
Thank you.

[kevinmouyard]

Great video, to the point. At 4:24 connection.row_factor. Trying to make graphs in matplotlib and need all the values in the Index 1 & 2 for X and Y that is returned in the SQLite query. This method provides only the last record. Any ideas?

[dekito]

Can you write it shortly, how sqlite pick up username if i enter it(example)?

[todayslottery]

Is there any way to store the data securely to sqlite3, so that the data can be accessed only by a password and username?

[diegoazpee]

It gives me an error:
Traceback (most recent call last):
File "C:\Users\Propietario\Desktop\sqlite3.py", line 1, in <module>
import sqlite3
File "C:\Users\Propietario\Desktop\sqlite3.py", line 2, in <module>
connection = sqlite3.connect('example.db')
AttributeError: module 'sqlite3' has no attribute 'connect'
>>>
please help!!!

[mcklyrenium]

pls combine it with tkinter please thank youu!!

[jk]

Contents aren't visible enough to understand.