home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 2
General
MP2-Setup-Spring16 new install using sqlserver 2016
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Lehmden" data-source="post: 1201444" data-attributes="member: 109222"><p>Hi.</p><p></p><p>MP2 was not and is not usable with SQLExpress database. There don't even exists any plans to do so. And as the TV Engine is running inside MP2 server as a plugin it has no own database- connection at all. Changing Gentle config only leads to errors, as you have seen already. This tiny little tables used for TV engine is nothing that needs a database server. It never had and it never will. You even can use a plain text file (XML or JSON) better than a full blown database server. But definitely the best is to use SQLite for it. </p><p></p><p>If you really want to use SQLExpress you first need to write a proper MP2 server database plugin for it. But I can proof you never will get the performance and easiness than with SQLite. That's why MySQL and any other database sources were dropped long time ago. I was involved in the development those days and I have seen with own eyes that SQLite was at least 10 times as fast as MySQL in "real live" situations, needs lot less power and memory and was (and still is) absolutely stable. The MySQL Plugin still is available, but afaik it is no longer working with recent MP2 versions. Haven't looked at it for years now. But maybe you can use it as a manual for writing the SQLExpress plugin...</p><p></p><p></p><p>As SQLite did not need any setup or configuration and it also did not interfere with any other DB system, there is no need to use it wich "other projects" if you use it with MP2...</p><p></p><p>Maybe SQLExpress is more to play with, but SQLite is the perfect solution for anybody who simply want something functional without any setup or hassle...</p></blockquote><p></p>
[QUOTE="Lehmden, post: 1201444, member: 109222"] Hi. MP2 was not and is not usable with SQLExpress database. There don't even exists any plans to do so. And as the TV Engine is running inside MP2 server as a plugin it has no own database- connection at all. Changing Gentle config only leads to errors, as you have seen already. This tiny little tables used for TV engine is nothing that needs a database server. It never had and it never will. You even can use a plain text file (XML or JSON) better than a full blown database server. But definitely the best is to use SQLite for it. If you really want to use SQLExpress you first need to write a proper MP2 server database plugin for it. But I can proof you never will get the performance and easiness than with SQLite. That's why MySQL and any other database sources were dropped long time ago. I was involved in the development those days and I have seen with own eyes that SQLite was at least 10 times as fast as MySQL in "real live" situations, needs lot less power and memory and was (and still is) absolutely stable. The MySQL Plugin still is available, but afaik it is no longer working with recent MP2 versions. Haven't looked at it for years now. But maybe you can use it as a manual for writing the SQLExpress plugin... As SQLite did not need any setup or configuration and it also did not interfere with any other DB system, there is no need to use it wich "other projects" if you use it with MP2... Maybe SQLExpress is more to play with, but SQLite is the perfect solution for anybody who simply want something functional without any setup or hassle... [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
General
MP2-Setup-Spring16 new install using sqlserver 2016
Contact us
RSS
Top
Bottom