Python Intermediate Tutorial #8 - Database Programming

preview_player
Показать описание
In today's episode, we are talking about database programming in Python.

Subscribe and Like for more free content!
Рекомендации по теме
Комментарии
Автор

Definitively I love these tutorial series! <3

jrgomez
Автор

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]

hovardlee
Автор

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

juniorizcortes
Автор

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

fatemehkhalatbari
Автор

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

TechMarketer
Автор

why does cursor needs to be defined in class?

rohitdeosthale
Автор

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

qvtdiql
Автор

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!

Radical
Автор

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

alexw
Автор

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

adhilnovandri
Автор

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

emonymph
Автор

Thank you for leaving the mistakes in there.

Machtyn
Автор

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

sebastianquesada
Автор

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 )

therealchicken
Автор

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'

jhonreylabanon
Автор

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'

davidfalk
Автор

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" ?

therealchicken
Автор

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

vaishnavikhandare
Автор

Its a good video but
bro sometimes your video becomes blurr

jinayjain
Автор

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

annog
visit shbcf.ru