atmosphere1212 Posted August 31, 2004 Posted August 31, 2004 Hi Ive never used a database in .net before. Im currently using visual c++ .net 2003 and im wondering what would suit my needs Im creating a media library similar to that in microsoft media player. Is a .net database suitable or is there an easier way. If someone could give me a brief overview of what to use or point me to a good tutorial page that would be perfect. Quote
Arch4ngel Posted August 31, 2004 Posted August 31, 2004 What could be a good thing is a XML file if you don't need to "share" this library. If you need to manage multiple user access and everything... go with a database. Quote "If someone say : "Die mortal !"... don't stay to see if he isn't." - Unknown "Learning to program is like going out with a new girl friend. There's always something that wasn't mentioned in the documentation..." - Me "A drunk girl is like an animal... it scream at everything like a cat and roll in the grass like a dog." - Me after seeing my girlfriend drunk and some of her drunk friend. C# TO VB TRANSLATOR
samsmithnz Posted August 31, 2004 Posted August 31, 2004 Another thing to consider is your final user. If you use a database it will be considerably quicker to access the 'media library' than an XML file, but your users may not have an SQL database, or Office (for access) installed. Quote Thanks Sam http://www.samsmith.co.nz
Arch4ngel Posted August 31, 2004 Posted August 31, 2004 (edited) Well... an XML file isn't THAT slow. What I use to use is the DataSet property WriteXML and ReadXML. With a schema you can read and write any "media library" and have it loaded nearly as fast as in a DB. I'm sure that if the file is 200Mb big... it will have some impact on performance... but well... you can also separate them on multipule file or adopt a different approch. Installing SQL DB or Office (can cause "version" problem) might cause more trouble than the "speed" access to a XML file. And maybe the user don't want to install a database server to run a media library. As an exemple... Winamp3 was working with XML files and... up to 1200 Mp3... I hadn't any problem of speed (well... it wasn't ONLY loading the XML... it was also reading each mp3 for information) So... my suggestion ? XML. Fast (much more compared to a TXT file), supported by ANY operating system and with more learning on XML... you could show all your Data in IE without big problem (I think that other browser now support XML) XML is future. XML is not Microsoft Copyrighted. The only reason why you shouldn't use XML is if you have to manage multiple-user access. But if only 1 user read and write from your library... well... why don't use XML ? [edit]Added some link on XML and XLS (stylesheet) files : http://www.codeproject.com/soap/dataset.asp http://www.w3schools.com/xml/default.asp[/edit] Edited August 31, 2004 by Arch4ngel Quote "If someone say : "Die mortal !"... don't stay to see if he isn't." - Unknown "Learning to program is like going out with a new girl friend. There's always something that wasn't mentioned in the documentation..." - Me "A drunk girl is like an animal... it scream at everything like a cat and roll in the grass like a dog." - Me after seeing my girlfriend drunk and some of her drunk friend. C# TO VB TRANSLATOR
samsmithnz Posted August 31, 2004 Posted August 31, 2004 The reason I wasn't so keen on XML, is that many 'media libaries' have over 30,000 items in them now... Quote Thanks Sam http://www.samsmith.co.nz
Arch4ngel Posted August 31, 2004 Posted August 31, 2004 Well... if it's a personal media library... XML will be perfect. Else... if it's a profesionnal media library (like those who sells mp3 online you know) well... SQL-Server will be better. But the more important thing in all that is... the volume of information. Like I said... if you can make it work with XML. BUT.... if it's going to be really large and there will be MANY user (like a web site) then... go with SQL-Server or MySql or any DB that you want. You have to remember that XML files are easily moved and copied while SQL db are more... hard to go along with but have more features (like Backup and User login - excluding Access which will never figure in my choice of a "professional" database) Now... I've finished arguing with samsmithnz... now it's time to atmosphere1212 to tell us his needs. Quote "If someone say : "Die mortal !"... don't stay to see if he isn't." - Unknown "Learning to program is like going out with a new girl friend. There's always something that wasn't mentioned in the documentation..." - Me "A drunk girl is like an animal... it scream at everything like a cat and roll in the grass like a dog." - Me after seeing my girlfriend drunk and some of her drunk friend. C# TO VB TRANSLATOR
samsmithnz Posted August 31, 2004 Posted August 31, 2004 Agreed! :rolleyes: :-\ ;) :p you crack me up Arch4ngel. You Canadians are crazy! ;) Quote Thanks Sam http://www.samsmith.co.nz
Arch4ngel Posted August 31, 2004 Posted August 31, 2004 I'm Crazy Lol :p :cool: If you think that Canadian are crazy... you don't know French Canadian (I'm from this group) !! We are mad as hell and we are even more crazy than anyone ! :p LOLLLL ;) :D Quote "If someone say : "Die mortal !"... don't stay to see if he isn't." - Unknown "Learning to program is like going out with a new girl friend. There's always something that wasn't mentioned in the documentation..." - Me "A drunk girl is like an animal... it scream at everything like a cat and roll in the grass like a dog." - Me after seeing my girlfriend drunk and some of her drunk friend. C# TO VB TRANSLATOR
pelikan Posted August 31, 2004 Posted August 31, 2004 that's why they traffic in Loonies!! Quote IN PARVUM MULTUM
atmosphere1212 Posted August 31, 2004 Author Posted August 31, 2004 Thanks for all the advice.. im going to go with the xml i think. Its a personal library and it would be benificial to have it easily transferable.. by the way, canada rocks Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.