Reply to thread

Message

Hi.
This Database provider is obsolete as it has no advantages but only disadvantages compared to the now (since a long time) default SQLite (that is included in the main installer package for sure). SQLite needs no external database server, it also is unlimited in DB size and it's ten times faster than MySQL (real live speed tested by ourselves). The only "downside" of SQLite is that there can be only one writing access at a time. Opposite to MP1 where everyone can fiddle around with the database of TV server the MP2 server is the only task that read and write to the MP2 database. Sp this is no disadvantage in this use case. I was part of the testing team as we finally (but very easily in the end) decided to go with SQLite. It definitely is way better than any other option we could test ...

MySQL (that meanwhile is commercial, so it should be MariaDB instead nowadays) is the db engine to choose if you need a "multi- user from multi- location" access to the database. This is valid for MP1 and also for Kodi, but this is not the case for MP2. Under "one- user from one location only" access as it is the case for MP2, SQLite is the much better, the best choice without any doubt.

<blockquote data-quote="Lehmden" data-source="post: 1278971" data-attributes="member: 109222">Hi.This Database provider is obsolete as it has no advantages but only disadvantages compared to the now (since a long time) default SQLite (that is included in the main installer package for sure). SQLite needs no external database server, it also is unlimited in DB size and it's ten times faster than MySQL (real live speed tested by ourselves). The only &quot;downside&quot; of SQLite is that there can be only one writing access at a time. Opposite to MP1 where everyone can fiddle around with the database of TV server the MP2 server is the only task that read and write to the MP2 database. Sp this is no disadvantage in this use case.&nbsp; I was part of the testing team as we finally (but very easily in the end) decided to go with SQLite. It definitely is way better than any other option we could test ... MySQL (that meanwhile is commercial, so it should be MariaDB instead nowadays) is the db engine to choose if you need a &quot;multi- user from&nbsp; multi- location&quot; access to the database. This is valid for MP1 and also for Kodi, but this is not the case for MP2. Under &quot;one- user&nbsp; from one location only&quot; access as it is the case for MP2, SQLite is the much better, the best choice without any doubt.</blockquote>

[QUOTE="Lehmden, post: 1278971, member: 109222"] Hi. This Database provider is obsolete as it has no advantages but only disadvantages compared to the now (since a long time) default SQLite (that is included in the main installer package for sure). SQLite needs no external database server, it also is unlimited in DB size and it's ten times faster than MySQL (real live speed tested by ourselves). The only "downside" of SQLite is that there can be only one writing access at a time. Opposite to MP1 where everyone can fiddle around with the database of TV server the MP2 server is the only task that read and write to the MP2 database. Sp this is no disadvantage in this use case. I was part of the testing team as we finally (but very easily in the end) decided to go with SQLite. It definitely is way better than any other option we could test ... MySQL (that meanwhile is commercial, so it should be MariaDB instead nowadays) is the db engine to choose if you need a "multi- user from multi- location" access to the database. This is valid for MP1 and also for Kodi, but this is not the case for MP2. Under "one- user from one location only" access as it is the case for MP2, SQLite is the much better, the best choice without any doubt. [/QUOTE]