<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Myriam,</p>
<p>Maybe as a starting point somebody could just outline the
requirements for the replacement of the embedded MySQL i.e.</p>
<p>Capacity, Speed, Ease of use (i.e. usable by non-techos),
available on all amarok platforms, etc.</p>
<p>Or to look at this differently, indicate the reasons why SQLite
couldn't do the job.</p>
<p>Cheers,</p>
<p>Leo<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 7/1/20 2:30 am, Myriam Schweingruber
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAGzoOB_1uqN2k=z5i339yqCiF1iWG10_YrtVe+4R7trG6VapdA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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"
moz-do-not-send="true">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" class="gmail_signature">
<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"
moz-do-not-send="true">http://www.fsfe.org</a><a
href="http://www.fsfe.org/"
style="color:rgb(17,85,204)" target="_blank"
moz-do-not-send="true"><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>
</body>
</html>