<div dir="auto">I've done testing with SQLite in other applications, and I don't think the problems we had with it 10 years ago are relevant anymore due to improvements in both hardware and software. I've got a private branch where I started porting Amarok's code over to SQLite a couple of years ago, but didn't finish it. It's still a worthy goal.<div dir="auto"><br></div><div dir="auto">The other thing I started doing in that branch is using baloo for file scanning and metadata extraction, with only Amarok-specific data like play counts stored in the SQLite DB. That, I think, is the best way to go so Amarok doesn't duplicate strigi's pretty good scanning capabilities.</div><div dir="auto"><br><div dir="auto"><div data-smartmail="gmail_signature" dir="auto">--<br>Soren Harward<br><a href="mailto:stharward@gmail.com">stharward@gmail.com</a></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jan 6, 2020, 10:31 Myriam Schweingruber <<a href="mailto:myriam@kde.org">myriam@kde.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;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" rel="noreferrer">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" rel="noreferrer">http://www.fsfe.org</a><a href="http://www.fsfe.org/" style="color:rgb(17,85,204)" target="_blank" rel="noreferrer"><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>