Movie in database

Anon

Hi,

I would like to make a website where other people kan upload litlle movie's with the extension .avi , .wmv , .mov , .mpeg , or .swf . But I don't know if it is possible to have a database witch can store that kind of data.

Can anybody help me?

Bram

Anon

All new databases are capable of doing this. The appropriate datatype is called blob (binary large object).

The Limit for Oracle e.g. is 4GB an for Filepointers the OS limit.

MySQL is also a got deal with it.

[deleted]

More to the point: storing binary data in a database is not a good idea, especially if you just want to build an archive.

Instead, save the movie to disk and store it's name and location in the database.

Then you can search for a movie in the database, find it's location on disk, and give that location to the user so he can download it directly from disk. This saves you a lot of work, time and bugs.

Anon

yes it is possible to store binary data in a db. What kind of DBS will you use?

Anon

Oracle supports kind of filepointers, where not the whole blob is saved but it's location. This could be useful also.

[deleted]

blobspace. allmost the same as saving the file, but you can still only access the data through the database.
so if your database craches 'bigtime', all your binary data is lost too.

PLus the sh*tload of backup problems.. yuk..