Hi Myriam,
Maybe as a starting point somebody could just outline the requirements
for the replacement of the embedded MySQL i.e.
Capacity, Speed, Ease of use (i.e. usable by non-techos), available on
all amarok platforms, etc.
Or to look at this differently, indicate the reasons why SQLite couldn't
do the job.
Cheers,
Leo
On 7/1/20 2:30 am, Myriam Schweingruber wrote:
Hi Leo,
On Sun, 5 Jan 2020 at 10:11, subscription1 <llsub...@zudiewiener.com
<mailto:llsub...@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 andsupport the work ofthe FSFE:
http://www.fsfe.org <http://www.fsfe.org/>
<http://www.fsfe.org/>
Please don't send me proprietary file formats,
use ISO standard ODF instead (ISO/IEC 26300)
