[prev in list] [next in list] [prev in thread] [next in thread]
List: amarok-devel
Subject: Re: embedded MySql alternatives
From: Soren Harward <stharward () gmail ! com>
Date: 2020-01-06 16:03:43
Message-ID: CANQojO6O47KDK3NBjxHgJVt1R1Dk+ynUsoyTQ_C887AMu0OdRQ () mail ! gmail ! com
[Download RAW message or body]
Sorry, I meant "baloo's scanning capabilities, which are much better than
strigi's were."
--
Soren Harward
stharward@gmail.com
On Mon, Jan 6, 2020, 11:02 Soren Harward <stharward@gmail.com> wrote:
> 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.
>
> 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.
>
> --
> Soren Harward
> stharward@gmail.com
>
> On Mon, Jan 6, 2020, 10:31 Myriam Schweingruber <myriam@kde.org> wrote:
>
>> Hi Leo,
>>
>> On Sun, 5 Jan 2020 at 10:11, subscription1 <llsubscr@zudiewiener.com>
>> wrote:
>>
>>> 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
>>>
>>> 1. Make amarok installation dependant on a MySQL server installation
>>> 2. Use something like Sqlite as the default
>>>
>>> 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 that were very
>> slow to handle with SQLite.
>>
>> 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.
>> 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.
>>
>> Regards, Myriam
>>
>> PS. Unless we find a better embedded database system, of course...
>> --
>> Proud member of the Amarok and KDE Community
>> Protect your freedom and support the work of the FSFE:
>> http://www.fsfe.org
>> <http://www.fsfe.org/>
>> Please don't send me proprietary file formats,
>> use ISO standard ODF instead (ISO/IEC 26300)
>>
>
[Attachment #3 (text/html)]
<div dir="auto">Sorry, I meant "baloo's scanning capabilities, \
which are much better than strigi's were."<br><br><div \
data-smartmail="gmail_signature">--<br>Soren Harward<br><a \
href="mailto:stharward@gmail.com">stharward@gmail.com</a></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jan 6, 2020, \
11:02 Soren Harward <<a \
href="mailto:stharward@gmail.com">stharward@gmail.com</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><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" target="_blank" \
rel="noreferrer">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" \
target="_blank" rel="noreferrer">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" \
rel="noreferrer noreferrer" \
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)" \
rel="noreferrer noreferrer" target="_blank">http://www.fsfe.org</a><a \
href="http://www.fsfe.org/" style="color:rgb(17,85,204)" rel="noreferrer \
noreferrer" 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>
</blockquote></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic