Move to SQL server instead of db3 file? (1 Viewer)

ScoopD

Portal Member
April 24, 2007
37
4
Melbourne
Home Country
Well I started a bit or a discussion there, didn't I.

don't know why everyone around here is so hot on SQL Server

I suggested SQL for the main reason that TVServer uses it, so there was already an installation in the MP environment. Don't really want to install another database back end. If its there, why not use it?

concurrent access from multiple clients ... could be taken care with just about the same amount of work with a client/server setup in the program

Great ideas. Again, I just suggested SQL cause it was already there. What I was really getting at was exactly the design of a multi-client single data source setup. Using the current plugin on multiple machines, but linking to a single SQLite db3 file has issues that I have experienced first hand. It is not intended for multiple concurrent connections.

All the questions that fforde has put forward should be answered, no question. My personal setup of the plugin at the moment is all network shares, no drive letters, so that I can access my file on any of my computers. Everything is streamed and it works just fine.

What is possibly more obvious to consider, thinking about the way that MP, its skins & this plugin work at the moment, is how to handle the banners, thumbs, fan art etc that inker brought up.

My "design" preference would be to be able to assign a central location (network share or local for single seat) for these image files to be downloaded to and accessed from. I don't think MP or the skins could deal with that as currently designed unfortunately (please tell me I'm wrong). To cope with this current setup, potentially there would have to be a mirroring of these image files between "client" and "server" for a multi-seat setup. A function that could be initiated from the client plugin configuration for a first-time setup, then mirrored on launch from within MP. Still that is an issue that could cause delay on bringing up the screens. It gets more difficult. Avoiding duplication of files is one of the reasons that I suggested this in the first place.

Just had another design thought, but this is completely over the top. I've been dealing with getting applications running in a locked down Citrix environment lately and the have a wonderful tool called "Application Isolation Environment." This essentially provides a shell for the application to run in. If the application attempts to make a call to a specific location, you can configure the AIE to redirect it to somewhere else. The application is none the wiser. Cool concept, if only it were simple to implement and configure .... but it's not.

Just more thoughts on and off the topic.
 

Inker

Retired Team Member
  • Premium Supporter
  • December 6, 2004
    2,055
    318
    My "design" preference would be to be able to assign a central location (network share or local for single seat) for these image files to be downloaded to and accessed from. I don't think MP or the skins could deal with that as currently designed unfortunately (please tell me I'm wrong).
    .

    You're wrong :)

    MP can load data from anywhere you want on it's own, if the plugin copes with the images don't even have to exist anywhere (logos for instance get appended into one large image on the fly, it only exists in memory), they can come from any source (think ftp, or some other transfer protocoll).

    What I'm getting at is that those are design questions, not technical problems.
     

    zicoz

    MP Donator
  • Premium Supporter
  • September 3, 2006
    896
    63
    Home Country
    Norway Norway
    Stubled upon this thread by acident but tought I'd give my toughts. I have no idea when it comes to programming or databases and so on, but as a user, here is what I would really like a HTPC setup to look like.

    You have one server that stores the mediafiles, and the database (this can either be a stand alone computer or one of your HTPC just like TV-Server today).

    Then you have one or more HTPCs around the house.

    - When one starts up the HTPC program you get to choose who you are from a list. "Mom, Dad, Bob, Billy, Chuck, Nina, Biff" etc.

    - Once you have chosen who you are, you get access to the the "Home menu" and can watch/listen to what you want. Just like you have in todays Mediaportal.


    This way each user can have their own home menu, and their own movie lists and "watched"-list.

    This is probably alot more work to set up, but imo that is the ultimate setup.
     

    allanp81

    Portal Pro
    October 24, 2006
    917
    41
    This seems even more relevant now that TVE2 is obsolete. It would mean that every install of MP would need SQL server installed though, which is only used if you are using the TV Server.
     

    fforde

    Community Plugin Dev
    June 7, 2007
    2,667
    1,702
    44
    Texas
    Home Country
    United States of America United States of America
    Why do you think this is more relevant now allanp81? What advantages would changing the database engine bring for TV-Series? SQL Server clearly has many many advantages over SQLite for enterprise level applications. But for something as small scale as TV-Series, Moving Pictures (or even MediaPortal!), it in my opinion only complicates the user experience.
     

    aj1405

    Portal Pro
    September 30, 2007
    443
    302
    Home Country
    Norway Norway
    I’m +1 on SQL server.

    I have multiple installations and want the same data (not just TV series, but all databases) on all my installation.

    The main reason to switch to SQL server I think is the Server-Client possibility. You also get some other nice features like memory caching (much faster than SQLite file based system) and relational data.

    I think he means it's more relevant because TV Server 3 requires SQL server, so most users already have it installed. Due to this fact moving TV Series to SQL server should not complicate the user experience.
     

    fforde

    Community Plugin Dev
    June 7, 2007
    2,667
    1,702
    44
    Texas
    Home Country
    United States of America United States of America
    1) Using SQL Server has nothing to do with server / client possibilities. At best it is a very loosely related concept. At the enterprise level, SQL Server would bring a big advantage with it's ability to better handle concurrent transactions. At the level MediaPortal operates (3-5 clients), it is totally irrelevant.

    2) The speed of the database is really just not an issue. As the lead developer of Moving Pictures, I have never once heard a complaint about speed of the plugin where the database was the bottle neck. In my experience, online web services (like IMDb, Movie-XML, etc) and file system access (like files on a network drive) are the real slow downs. Database access with SQLite is generally fairly snappy.

    3) Not all users use TV Server 3 or have SQL Server already installed. According to the last user survey, 26% of people don't even use the TV features of MediaPortal. This means that for those people, they would have to specifically install SQL Server for TV Series. This complicates the user experience. It makes it harder to begin using the plugin.


    Ultimately I see at least one down side and no advantage...
     

    allanp81

    Portal Pro
    October 24, 2006
    917
    41
    Lots of people run multiple clients and would love to have a central database rather than maintain individual databases on each client.
     

    JB72

    MP Donator
  • Premium Supporter
  • June 15, 2007
    791
    128
    52
    Bremen
    Home Country
    Germany Germany
    Lots of people run multiple clients and would love to have a central database rather than maintain individual databases on each client.

    Right, i am on the best way to have 4 clients ... the TV Server forced this :D
    To have an option to save the Database on the TV Server will be a good thing.
     

    fforde

    Community Plugin Dev
    June 7, 2007
    2,667
    1,702
    44
    Texas
    Home Country
    United States of America United States of America
    You guys misunderstand. Using SQL Server does not magically make the plugin work with a multi-seat setup. I can't really speak for TV-Series so maybe one of their devs will speak up, but at least for Moving Pictures, if we were to move to SQL Server, there would still be concurrency issues, and it would be very likely the data in the database would loose integrity if significant changes were not made.

    My point is that while multi-seat support is obviously a very desirable feature, switching to SQL Server (or any other database engine) does not really solve any of the problems that make multi-seat support difficult.
     

    Users who are viewing this thread


    Write your reply...
    Top Bottom