Streaming video BLOBs from MySQL

From: Date: Thu, 14 Apr 2005 19:40:05 +0000
Subject: Streaming video BLOBs from MySQL
Groups: php.general 
Request: Send a blank email to php-general+get-213113@lists.php.net to get a copy of this message
I have a case where video files (mov, flv, etc) have been stored in a MySQL database as blobs. I'm loading them into a flash video player and everything works fine except it takes longer it seems and it doesn't allow streaming the actual video. If I load the same videos with a direct link to the http:// file system (/videos/file.flv) it loads in super-fast and allows streaming. I'm guessing mysql and/or php doesn't actually release the BLOB until it's loaded it completely. So, is there a way to actually have PHP read the BLOB and stream it as it's loading? Is there an fstream() option like the fread()? Wishful thinking? __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail

« previous php.general (#213113) next »