dbTalk Databases Forums  

How insert and read Audio/Vedio/Image in MySQL

mailing.database.mysql-plusplus mailing.database.mysql-plusplus


Discuss How insert and read Audio/Vedio/Image in MySQL in the mailing.database.mysql-plusplus forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default How insert and read Audio/Vedio/Image in MySQL - 06-22-2006 , 03:36 AM






--Next_1150780199---0-203.199.83.35-22676
Content-type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

=A0=0Ahi,=0ANeed help in instering and reading audio,vedio and image files=
in mysql database.Can any one help me on this?=0A=0AHrishi
--Next_1150780199---0-203.199.83.35-22676--


Reply With Quote
  #2  
Old   
AT
 
Posts: n/a

Default Re: How insert and read Audio/Vedio/Image in MySQL - 06-23-2006 , 12:08 AM






Hrishikesh Hemade wrote:
Quote:
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?unsu...ie.nctu.edu.tw



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.