<div dir="ltr">Hi Myriam,<br><br>What about deprecating Mysql embedded, and supporting MariaDB instead? It seems the natural path since it still has libmysqld.<br><br>Regards,<div><br></div><div>Pedro</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jan 6, 2020 at 4:31 PM Myriam Schweingruber <<a href="mailto:myriam@kde.org">myriam@kde.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Hi Leo,</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, 5 Jan 2020 at 10:11, subscription1 <<a href="mailto:llsubscr@zudiewiener.com" target="_blank">llsubscr@zudiewiener.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Given that the embedded MySql has disappeared from the latest
Ubuntu release the only other alternative to install Amarok on
this (and later) releases I can see is to</p>
<ol>
<li>Make amarok installation dependant on a MySQL server
installation</li>
<li>Use something like Sqlite as the default</li></ol></div></blockquote><div><span class="gmail_default" style="font-family:arial,helvetica,sans-serif">I don't really have a solution, but I know we deliberately changed from SQLite wich was default in Amarok 1.x to MySQL embedded with the option of MySQL Server due to the bad scaling of SQLite. Many users of Amarok requested that change, some having enormous databases</span> <span class="gmail_default" style="font-family:arial,helvetica,sans-serif">that were very slow to handle with SQLite.</span></div><div><br></div><div><span class="gmail_default" style="font-family:arial,helvetica,sans-serif">We probably have to choose the first option, but giving the users the option to use an existing MySQL server installation or creating one just for Amarok. There also is software in place (probably outdated) to use Akonadi which we waited to get usable before adopting it, something which even Kmail is still struggling with, unless Akonadi is used with PostgreSQL.</span></div><div><span class="gmail_default" style="font-family:arial,helvetica,sans-serif">Of course another option would be to change to PostgreSQL which scales quite well and might be a better solution. This looks like something we would need to ask the users TBH.</span></div><div><span class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></span></div><div><span class="gmail_default" style="font-family:arial,helvetica,sans-serif">Regards, Myriam</span></div><div><span class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></span></div><div><span class="gmail_default" style="font-family:arial,helvetica,sans-serif">PS. Unless we find a better embedded database system, of course...</span></div></div>-- <br><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><div style="text-align:left"><div>Proud member of the Amarok and KDE Community</div><div>Protect your freedom and<span style="font-family:arial,helvetica,sans-serif"> support the work</span> of<span style="font-family:arial,helvetica,sans-serif"> </span><span style="font-family:arial,helvetica,sans-serif">the</span> FSFE:</div><div><a href="http://www.fsfe.org/" style="color:rgb(17,85,204)" target="_blank">http://www.fsfe.org</a><a href="http://www.fsfe.org/" style="color:rgb(17,85,204)" target="_blank"><br></a></div><div>Please don't send me proprietary file formats,</div><div>use ISO standard ODF instead (ISO/IEC 26300)</div></div></div></div></div></div></div>
</blockquote></div>