I am programming a music streaming service and am currently using ftp servers for everything including login, register and holding database objects. I know this isn't a very good way of managing things and is a very slow way to go about things. At the moment the only way I can hold information about a song for example in one single file on the server is by creating a file like something called 'Songname!!songartist!!songalbum' and so on, then download directory info and splitting the string. This is a very ugly way of coding such a feature.
I want to use MySQL to hold data such as users and song information, so I need to create two tables, one to hold user info such as username, email, password etc, and another one to hold a list of song with info like song name, artist, album, year genre and so on. I also want each user to have their on playlists, so would it be possible to create some sort of system where each user has their own table for their playlists. I have no idea where to even start with MySQL, I can create tables on my server and create a VERY simple login system but am having trouble thinking how I would even start something like this.
To simplify the question I basically want to make some sort of user database like Spotify or Rdio.
Thanks for any help :)
Submit an article or tip