Add Video file to database

[Irwin Raja]

I would like to create a database where i can store my video files.. After creation, i want to upload and download these video files from my database from a jsp page... How do i implement this procedure?

[Devaka Cooray]

Why not placing your videos as files somewhere so each video file has a unique URL and you can store these URLs in the database?

[Irwin Raja]

if i consider storing url's, then wen a user uploads a file i wont be able to access it as my database would have only url nd not the actual file..

[Devaka Cooray]

Does that mean you are not able to access the URLs given in the database?

[Irwin Raja]

I can access the url's.. but wen a user uploads a file from his system i would be having the path of the file defined in his system rather than the actual file in my databse..

[Tim Moores]

Maybe the term "URL" threw you off a bit. What Devaka meant was that you'd store the videos in the file system, and keep only the path to each file in the DB, along with any other metadata about the video in question. Storing actual video data in the DB is probably not the right way to do it.

[William Brogden]

Anyway, databases don't store huge objects such as video files inside the database table structure, that would render table manipulation very very very slow - instead, large objects are stored as separate files with references in the actual database tables.

Bill

[Jack Numen]

Its as simple as this:
Step 1: The end-user submits his file to your system (for how to upload a file in Java you can find lots of examples on Google).
Step 2: You can use your File Api to store/refer/delete that file on your server at the same time store the path of the file in your database column.

and when the user want to retrieve it you are now referring to the file in your server not in the end user machine.

As Tim and William said it is not advisable to store entire file in the database.

[Irwin Raja]

thanks a lot..