Generic Browsing in MP? Database Re-Design? (1 Viewer)

[Agree]

I would really like to see something like this happening in the future and have tried coming up with a few schemas but never got one that was either good enough or clean/simple enough .

I'm quite a fan of the death to hierarchies approach of Google's label system, the ability to label any item in your library as 'Holiday May 2006' and being able to access all those items by navigating a label hierarchy (didn't I say earlier that I support death to hierarchies?!?!?) or by searching would be really cool IMO.

offtopic:
You are willing to help dev xaml stuff for mp smirnuf?

greets
agree

 

[mbuzina]

I think you really should look at using Microsoft SQL Server 2005 Express Edition, it will be useful when version 0.3 starts to roll out.

Does anybody know if there is a difference in developing for SQL Express or the "big" SQL Server? I have the big one installed and would like to start on developing... Thnx.

 

[Lyxalig]

For one... Mon-ay..

 

[mzemina]

Yes, Lyxalig is correct. It cost to have the "big" SQL Server from Microsoft. I haven't looked through this thread as closely before asking this question, but does this design allow for the addition of a new object to be added, like games? I't seems that several people are wanting to enhance MP with additional features in the area of game emulator launching. Well, I was just wondering.

Mike

 

[mbuzina]

Yes, Lyxalig is correct. It cost to have the "big" SQL Server from Microsoft.

My question is more around : Can you develop for both without changing code? But I have dismissed it, I programm for the express version now (neve knew it was already installed!).

I haven't looked through this thread as closely before asking this question, but does this design allow for the addition of a new object to be added, like games? I't seems that several people are wanting to enhance MP with additional features in the area of game emulator launching. Well, I was just wondering.

Mike

I hope it can. I am trying to make this as generic as possible (Labels & Items, which can be anything). But my main focus would be "Media".x[/quote]

 

[NLS]

I am sure free SQL solutions more than suffice - the point is to use whichever SQL solution more effectively.

 

[samuel337]

I would suggest SQL Server Everywhere instead of SQL Server Express Edition as Everywhere does not require a server installation - just install the client app and a couple of DLLs if not installed already. Essentially, it is the SQL Server version of the Microsoft Jet DB Engine (Access). This will make the installation process much easier and less things can go wrong, similar to the current SQLite-style setup. However, this will depend on how the MP devs want to handle network DB access.

http://msdn.microsoft.com/vstudio/default.aspx?pull=/library/en-us/dnvs05/html/sqleverywhere.asp

Sam

 

[Lyxalig]

Don't know of the product in question sam, but I'm quite sure Jet DB is know to have inferior speed over "any" other sollution

 

[mbuzina]

As far as I am aware, the dev team is using the SQL Server Express version. Although it is a server it is free of charge, can be included in distributable package and is virtually "maintenance free" (we will see...)

I am using it and it seems to be great. Will say more later...

 

[Lyxalig]

"The dev team" - Who's got their hands on this project. Ahh.. can't wait..