embedded MySql alternatives

[subscription1]

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 <llsubscr at zudiewiener.com 
> <mailto:llsubscr at 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)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/amarok-devel/attachments/20200109/322cbe2e/attachment.html>