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.
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.