Click here to Skip to main content
12,354,716 members (60,369 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB MySQL VB.NET
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 Smile | :)
Posted 11-Dec-12 11:27am

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

If the information is not sensitive then you could implement XML to persist your data inside a STRUCTURED xml document.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 13 Dec 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100