Does it make sense to host movies from a home LAMP server SQL database?

Question

First off, my apologies if the concept of this question makes no sense, as I am attempting to create my first SQL database.

-Does it make sense to host movies from a home LAMP server SQL database? -If I decide to host videos from an SQL database via my Ubuntu 12.04 LAMP server, will I have advantages in performance? -Will that include wireless/wired streaming over an Airport Extreme router (or in other words, over a network)?

The alternative would be a file share. I am aiming to learn some basic SQL setup and administration; I thought this might be an interesting and educational way to do it.

Answer 1

Start by researching how various home media solutions solve this problem. Each has differing upsides and downsides. Some focus on indexing and adding metadata to shared network drives then provide a browsing interface to it. Others wholly encapsulate the media store and provide the media directly--sometimes by faking a file share which in reality is backed by the database.

Answer 2

The performance of video over network depends on the performance of your main server. Now if you want to host the videos your server should be very fast and reliable.

It's advisable to use LAMP Server if used on LAN Network.

But if you are planning for later modification in terms of users then I would suggest that you go with the alternative.