Python Intermediate Tutorial #8 - Database Programming

In today's episode, we are talking about database programming in Python.

Subscribe and Like for more free content!

[jrgomez]

Definitively I love these tutorial series! <3

[hovardlee]

I think the best option to use database is using within context manager. It solves a lot of issues like closing connection:
def count_table():
with sqlite3.connect(DB_NAME) as db:
num_of_rows =
return num_of_rows[0]

[juniorizcortes]

Do we have the same process in creating database tables in oracle and sql?

[fatemehkhalatbari]

Hi .l have question. I go to the third step, but it gives me an error(error=databbase is locked).pleas help me🙏🏻

[TechMarketer]

Hi Bro, could you tell us more about DB and OOP relations?

[rohitdeosthale]

why does cursor needs to be defined in class?

[qvtdiql]

The sqlite3 script is very very nice. Could you tell me where to find it in the description. Your video scripts are cool

[Radical]

Great use of combining sql with python however if i was a beginner to coding i may be confused by the different syntaxes maybe explain that a bit better we all ought to learn otherwise awesome video!

[alexw]

you should make a discordpy DB tutorial for like warnings and or levels and etc

[adhilnovandri]

hi bro.
if you open connection database in __init__ function, how to close the connection?

[emonymph]

The tutorial was so good I will forgive you for using notepad as an IDE.

[Machtyn]

Thank you for leaving the mistakes in there.

[sebastianquesada]

thanks so much my teacher failed to let me know that sql and pyhton have two different syntaxs i was very confused...

[therealchicken]

Bro I love you I am learning java in school and python myself private cause I prefer it by far and here I learn something for both nice ( I focus on python )

[jhonreylabanon]

i kept getting this type of error, can anybody help me with this?
line 25, in <module>

p1.load_person(1)
AttributeError: 'Person' object has no attribute 'load_person'

[davidfalk]

I get this error. Can you help? line 15, in load_person
self.cursor.execute("SELECT * FROM persons WHERE id = {}".format(id_number))
AttributeError: 'Person' object has no attribute 'cursor'

[therealchicken]

19:50 couldnt we just pass one tuple instead of 4 placeholders? also cant we instead of person make an class above which takes a name and puts it in the corresponding "person" ?

[vaishnavikhandare]

look at text cursor on 1:56
did you notice something?

[jinayjain]

Its a good video but
bro sometimes your video becomes blurr

[annog]

You too think in a functional way in an objective world; my friend.