Python Forum
Python and SQL BLOB Streaming
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Python and SQL BLOB Streaming
#1
Hello, I have some videos I am storing on an SQL BLOB column. Is there a way I could read from the columns in byte chunks to create a stream in python?

Any help on this would be greatly, greatly appreciated.
Reply
#2
this looks to be about reading blob data in chunks, (SQL Server): https://stackoverflow.com/questions/1377...le_rich_qa
Reply
#3
Ok so I can get the bytes, is there a way I can convert them to a image using PIL or something and feed them to a video player?

Thanks
Reply
#4
Please refer to: https://code-maven.com/create-images-wit...pil-pillow
as there are several writing modes, including text.
Reply
#5
Read through that, still not sure how I can shove bytes in there to create an image. If I have the bytes there has to be a way to get frames out of them right? How else are streams created? I tried this

image.open(io.BytesIO(values[0][0]))

my values[0][0] contains a portion of my video file in bytes

I get this error cannot identify image file <_io.BytesIO object at 0x0000025D891FF200>.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Create zip file from the BLOB column in ORACLE DB nnsatpute 2 1,879 Dec-31-2021, 11:00 AM
Last Post: ibreeden
  How to decrease latency while recording streaming video. unicorn2019 0 1,232 Nov-15-2021, 02:12 PM
Last Post: unicorn2019
  Reading blob data from database by python and store it in .zip format Adityasi 2 6,444 Nov-18-2019, 05:22 PM
Last Post: ibreeden
  Playing music from streaming ebolisa 1 1,842 Oct-08-2019, 06:50 PM
Last Post: snippsat
  Python 3.5 streaming output to the same log file that I write to cbj0517 2 2,708 Apr-23-2019, 04:38 PM
Last Post: cbj0517
  Streaming to website instead of Window OpenCV SDGRIFFUSW 1 1,893 Apr-19-2019, 09:59 PM
Last Post: SheeppOSU
  Video Streaming Python 3 adaptation failling maimonid 8 8,478 Dec-28-2016, 09:20 AM
Last Post: maimonid

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020