Server database as film database? (1 Viewer)

[hafblade]

Hi guys,

I searched for it in the forum but didn't find a thread about it so I'll create one.

Is there a plan to use a real database system in the future?

I see so many plugins in the mediaportal environment and no plugin of these uses the database of the tv server which is really installed in every MediaPortal environment. Is there some special reason for this?

In my opinion it's the same complexity to create a database application compared to an application which only works with xml files instead.

There would be many benefits like locking data possibilities when many user work with the same set of data and faster data queries for example.

Is it because you would have to create script for MySql AND MsSql or some other technical issue?

I don't know the source code of MyFilms at the moment but I suppose there are some places to query data from the xml file. Would it be possible to plug in some database query classes in these places?

I would love this because the infrastructure is there.

In my opinion this would be the best solution for all plugins which use data for all clients.
Even if you say "Man, everyone wants his own data in my home" this could be solved by using different user accounts or something like this.

What do you think?

 

[Lehmden]

AW: Server database as film database?

Hi.
This is planed (and implemented) in MP2, The necessary changes to use "real" database on MP1 are way too big to be done at all.
And you can't implement all MP Users have TV Server installed. Lots of People are using MP as MediaPlayer only or with 4TR for TV Part... So you can't take TV Server DB as given..

 

[hafblade]

Hmmm sound cool with MP2 ( +1 )

Yes you're right that not everyone has this, haven't thought about it.
But I suppose that many people would install a database or a server software to manage this.

I love the idea of having every data in a central database instead of 20 different xml files, folder structures or something like this.

But you're right it's hard to achieve this.

 

[Guzzi]

AW: Server database as film database?

Hi hafblade,
since you have posted in MyFilms forum, I will comment at this as well.
In general, I fully agree with you - I personally am also a "network user" and have multiple clients - so yes, such a setup is what I am after too ;-)
Lehmden already mentioned, why this is not implemented in Mediaportal 1.x - and something like that will come with MP2.
Due to this, we made this intermediate solution for MyFilms - including basic support for "userprofiles" for watched status.
In MyFilms indeed there is a layer, that is currently "connecting" to the XML files - and that one could also connect to an SQL server of TV server. But MyFIlms is focused on end user databases - like Ant Movie Catalog - and keeping the "storage" in native XML allows to use both - the management application and MyFilms - on the same data.
If I would import the data into another database, the user would loose the 2-way interoperability (similar to the external catalogs like Xtreme moviemanager, that only support import to myfilms).
Changing the architecture in such a way was already proposed by some users - in a way, that myfilms uses it's own "proprietary" storage (that could be centrally on a server) and only interact via input/output filters with the respective external catalogs.
That is a nice idea, but quite a redesign/rewrite of a lot of parts - so unless there would be more helping hands, I think we have to live with it "as is" for now.
Further, it would not make much sense implementing that for a single plugin, when the frame work will be available in MP2 and could be used for such use case scenario.

 

[hafblade]

Further, it would not make much sense implementing that for a single plugin, when the frame work will be available in MP2 and could be used for such use case scenario.

I fully agree with this. Doing so much work for only throwing it away wouldn't be the best idea.

To bad that time is so short else I would like to help achieving this goal but no time means no programming