Python SQLite Adding Photos (BLOB) to a Digital Memory | #51 (SQLite #4)

In this video, we'll be using Python and SQLite for adding photos to a digital memory. We'll be hard coding a photo into our memory database, but in the next video we'll be selecting any photo from a normal file explorer. Photos are incredibly important to recognizing memories and remembering them. So adding photos to a digital memory was a priority for me.
Python SQLite Playlist: • SQLite

[@amirilifee]

Great, only this video helped video between all that ones i saw on youtube. THanks much brooo))))

[@BrandonJacobson]

I missed this comment. Thank you so much for the positive feedback!

[@davidgmos]

Nice tutorial and very interesting project, nowadays we use more and more technology but often for entertainment or unimportant things and not for things that really matter.

[@sf2998]

Thanks for the great tutorial. Two questions:
1. Is it necessary to first convert the file into a binary format before the BLOB insert??
2. When we insert a text file or a photo, do we always insert the content of the file, and not the file itself?? By 'file itself' i mean the entire file which gets displayed as the file name or file path.

[@BrandonJacobson]

Those are good questions that I don't know the answer to. Sorry.

[@Choudermouse]

Thank you for this tutorial.

[@BrandonJacobson]

You're welcome. I'm glad it helped!

[@arnaldoramirez4279]

man part of your code made work my project lol subscribed 👍

[@BrandonJacobson]

Yes! I'm glad to hear that.

[@granollabar4604]

May be a bit late on this cause this is the first video im watching of yours but your father is in my prayers and im sorry you had to go through something like that.

[@romanhar4151]

Thank you very much for this good explanation which make me understand BLOB.

[@BrandonJacobson]

Awesome! I'm glad it helped.

[@sergeysemkin6570]

Очень круто рассказал. Спасибо большое!!! )))

[@javiermanjarresbaldovino2394]

hi! Can you share Code in FLASK Or How to create Model of database in Flask ?..please!!!

[@BrandonJacobson]

I have a couple videos on using Flask, but not connected to a database or integrated with SQL. th-cam.com/play/PLT8WeU5lHsiR3AoLgOfIyOFr6KYNji8aW.html

[@javiermanjarresbaldovino2394]

@@BrandonJacobson then please share this Code to study it please...

[@hossambarakat]

Thanks, Waiting for Part #5

[@BrandonJacobson]

That's the next video in the queue! Thanks for the comment.

[@hossambarakat]

@@BrandonJacobson thanks, waiting....

[@hossambarakat]

and how to fetch it on Pyqt5 design

[@BrandonJacobson]

@@hossambarakat I try to publish on Tuesdays and Saturdays. I appreciate the enthusiasm and the comment love.

[@BrandonJacobson]

@@hossambarakat I don't have plans on using Pyqt5 for fetching data as of yet. The next video is about fetching more data though.

[@muhamedqasim5390]

how i can add default blob ?

[@WellingtonSilvaf1]

Great video, but I'm having a sqlite3.OperationalError: unrecognized token: "\" and I'm pretty sure it's because the converted foto has some '\' in it. So I have no idea how to fix it.

[@BrandonJacobson]

Can you copy and paste the whole error please?

[@WellingtonSilvaf1]

@@BrandonJacobson Sure
Traceback (most recent call last):
File "C:/Users/Wellington/PycharmProjects/fun/image_in_database.py", line 33, in
inserir_dados()
File "C:/Users/Wellington/PycharmProjects/fun/image_in_database.py", line 28, in inserir_dados
cursor.execute(f"INSERT INTO pessoa_imagem (nome, imagem) VALUES ('Iron Man', '{picture}')")
sqlite3.OperationalError: unrecognized token: "\"

[@WellingtonSilvaf1]

@@BrandonJacobson I fixed it already, thank you!

[@BrandonJacobson]

@@WellingtonSilvaf1 sorry for no response. I didn't get the reply notification. I'm glad you got it fixed. Sorry about that.

[@generalpinochet9821]

@@WellingtonSilvaf1 could to please tell me how to fix it?

[@danielramirez1022]

How i can get a image from a db?

[@BrandonJacobson]

These SQLite videos don't do that well on my channel so I haven't been updating it. Getting and displaying the image was next in the queue for this playlist. I've starred this message and will work on that code in the next couple of weeks.

[@santoshsinghdhami1751]

@@BrandonJacobson Thank you. I have been stuck with the same problem as I am trying to display the blob image into a template. Really excited about the upcoming tutorial.

[@tyswenson7542]

Concise instructions. Genuine person. Like, subscribe, save playlists

[@Technokidzo]

but when i tried to implement in app of pyqt5 then it shows:- 'str' object is not callable
reply fast as possible

[@devashishshriwas7328]

Thanks bro.....

[@BrandonJacobson]

I'm glad it helped!

[@Technokidzo]

Thanks

[@BrandonJacobson]

I'm glad it helped!

[@Technokidzo]

Also subscribed and I'm smaller than you I am just 9
I was trying to make an software but I was thinking about storing image in database either storing in folder

[@Technokidzo]

@@BrandonJacobson but when i tried to implement in app of pyqt5 then it shows:- 'str' object is not callable
reply fast as possible

[@forestriver437]

This seem like the same idea I wrote down years ago. Get ready 🎩. haha

[@BrandonJacobson]

Great minds think alike I guess.

[@forestriver437]

@@BrandonJacobson Guess so. So what are you going with Django or flask?

[@amra.haleem5175]

My condolences about your father. But, I like to tell you this. In Islam we believe that Allah decides a lifespan for each person by deciding his death time before he or she is created. So, no matter he is healthy or not healthy. Nor he commits suicide not. He or she dies at that predetermined instant. In Islam, we find that Allah encourages medicine and therapy. But when death comes, medicine and therapy stop taking place as destiny takes it place. My condolences again about your father. And I shall wish you be a good memory of him.

[@BrandonJacobson]

Thank you for those words!