Re: How insert and read Audio/Vedio/Image in MySQL

Hrishikesh Hemade wrote:
> Need help in instering and reading audio,vedio and image files in
> mysql database.Can any one help me on this?

See the examples. load_file and cgi_image do exactly what you're asking.

I can understand putting small images in a database, but *video*?  Are 
you sure you know what a database is designed for?  A typical digital 
video file is a multi-gigabyte block of unnormalized data.  Read any 
database design book if you don't know why that is bad.  Even if you 
don't care about that, how will you query it?  I guarantee you:

        mysqlpp::Row row = query.execute();

will blow up on almost any current machine when one of the fields holds 
a few gigabytes.

My company makes digital video servers, and we keep the videos in the 
regular filesystem, using the database server just to store information 
about the videos.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:    
http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@xxxxxxxxxxx