VB.NET（Advnaced MySQL）？ [英] VB.NET (Advnaced MySQL)?

问题描述

我正在编写音乐流媒体服务，目前我正在使用ftp服务器来处理所有内容，包括登录，注册和保存数据库对象。我知道这不是管理事物的好方法，而且是一种非常缓慢的事情。目前，我可以在服务器上的一个文件中保存有关歌曲信息的唯一方法是创建一个名为Songname !! songartist !! songalbum等的文件，然后下载目录信息和分裂字符串。这是编写这样一个功能的一种非常难看的方式。



我想使用MySQL来保存用户和歌曲信息等数据，所以我需要创建两个表一个用于保存用户信息，如用户名，电子邮件，密码等，另一个用于保存歌曲列表，包括歌曲名称，艺术家，专辑，年份类型等信息。我还希望每个用户都有自己的播放列表，因此可以创建某种系统，其中每个用户都有自己的播放列表表。我不知道从哪里开始使用MySQL，我可以在我的服务器上创建表格并创建一个非常简单的登录系统，但我很难想到如何开始这样的事情。



为简化问题，我基本上想制作某种用户数据库，如Spotify或Rdio。



感谢您的帮助：）

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 :)

推荐答案

如果信息不敏感，那么您可以实现XML以将数据保存在STRUCTURED xml文档中。

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

这篇关于VB.NET（Advnaced MySQL）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！