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
If the information is not sensitive then you could implement XML to persist your data inside a STRUCTURED xml document.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)