Reply to thread

Message

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...

<blockquote data-quote="Lehmden" data-source="post: 1201444" data-attributes="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 &quot;real live&quot; 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 &quot;other projects&quot; 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...</blockquote>

[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]