Multimedia Database 1

[masper]

Hi everyone. I'm new to Delphi and as part of a project I need to create a database. The database will server based and will store video clips (probably mpeg or AVI). I'm going to use Delphi and probably MySQL. Does anyone have any suggestions as to how I would go about this? Any tips would be greatly appreciated.

 

[svanels]

Maybe you find something usefull at:

http://delphi.about.com/cs/blob/index.htm

Steven van Els
SAvanEls@cq-link.sr

 

[NaniFra]

Hi

Perhaps you can just put into the DB the full parth of the file containing the clip. This can be a simple string, helping to save space. I think you don't really want to store the entire videoclip into the DB (the DB will soon become too big). But if this is the case, consider making BLOB fields and streaming data from the original file.

HTH Francesco Salvi

 

[GeppoDarkson]

Hi,
If you want to put a file into a Blob:

SalvaFileNelDb(EmailTbl.FieldByName('File'),'C:\Deleteme.eml');

****
Procedure TMailDownloaderFrm.SalvaFileNelDb(Campo:TField; NomeFile:TFileName);
Var Blob:TStream;
FS:TFileStream;
Begin
If Not (Campo.DataSet.State in dsEditModes)
Then Campo.DataSet.Edit;

Blob := Campo.DataSet.CreateBlobStream(Campo, bmWrite);
Try
blob.Seek(0, soFromBeginning);
FS:=TFileStream.Create(NomeFile, fmOpenRead or fmShareDenyWrite);
try
Blob.CopyFrom(fs, fs.Size)
finally
fs.Free
end;
finally
Blob.Free
end
End;
****

Ciao,
Geppo Darkson.