SQLite Pilot V1

[Pedro de Carvalho Gomes]

Hi Leo,

Your learning was certainly not in vain. It has been a while that Amarok
developers are discussing about moving out from Mysql Embedded, including
MariaDB's replacement. The reason is that it is likely that MariaDB will
drop support for libmariadbd since Mysql did it. Thus, an Sqlite backend
seems like the best replacement as default DB. I think Myriam can say more
about this.

I will take a look at your code as soon as I have some time.

Regards,

Pedro

On Thu, Mar 5, 2020 at 2:13 AM subscription1 <llsubscr at zudiewiener.com>
wrote:

> Hi Pedro,
>
> Your MariaDB solution works as far as I can tell. Wish I knew this before
> I spent 2 months on the SQLite solution;-(
>
> Still, learned a lot in the process
>
> Here is what I did
>
> 1) Installed Kubuntu 19.10 (on a VM)
>
> 2) Installed all prerequiste software as per your docker; the only thing I
> added was libphonon4qt5-dev
>
> apt-get install -y cmake extra-cmake-modules g++ git libmariadb-dev
> libmariadbd-dev pkg-config  \
>     qtdeclarative5-dev qtscript5-dev libqt5svg5-dev qtquickcontrols2-5-dev
> qtwebengine5-dev  \
>     libkf5archive-dev libkf5attica-dev libkf5codecs-dev libkf5config-dev
> libkf5configwidgets-dev libkf5coreaddons-dev libkf5crash-dev \
>     libkf5dbusaddons-dev libkf5declarative-dev libkf5dnssd-dev
> libkf5globalaccel-dev libkf5guiaddons-dev libkf5i18n-dev
> libkf5iconthemes-dev \
>     libkf5kcmutils-dev libkf5kio-dev libkf5newstuff-dev
> libkf5notifications-dev libkf5notifyconfig-dev libkf5package-dev
> libkf5solid-dev \
>     libkf5texteditor-dev libkf5threadweaver-dev libkf5widgetsaddons-dev
> libkf5windowsystem-dev libkf5wallet-dev kirigami2-dev \
>     gettext libtag1-dev libtag-extras-dev libavcodec-dev libavformat-dev
> libavdevice-dev libavutil-dev libswscale-dev libpostproc-dev \
>     libgpod-dev libgdk-pixbuf2.0-dev libmygpo-qt-dev libmtp-dev
> libcurl4-openssl-dev libxml2-dev libssl-dev libgcrypt20-dev \
>     libfftw3-dev libloudmouth1-dev libofa0-dev liblastfm5-dev libgmock-dev
> libphonon4qt5-dev
>
> 3) cloned amarok
>
> 4) built/installed amarok (my dev environment is under /kdedev)
>
> cmake -DCMAKE_INSTALL_PREFIX=$HOME/kdedev -j4
> -DCMAKE_VERBOSE_MAKEFILE=TRUE -DCMAKE_BUILD_TYPE=Debug
> -DMYSQLCONFIG_EXECUTABLE=/usr/bin/mariadb_config
> -DMYSQL_INCLUDE_DIR=/usr/include/mariadb ../../src/amarok/
>
> cmake --build .
>
> make install
>
> amarok runs, I can add my music and play from a random playlist. Have not
> done any extesnive testing, but think you have found a solution for
> installation for (U/Ku)bunto without the embedded MySql.
>
> Thanks,
>
> Leo
>
>
> On 28/2/20 1:46 am, Pedro de Carvalho Gomes wrote:
>
> Hi,
>
> Is this branch available somewhere? I may take a lot and help you with
> that.
>
> About the (K)Ubuntu 19+: indeed it comes with Mysql 8, which no longer
> supports Mysql Embedded. Still Ubuntu 19.10 provides MariaDB 10.3 as
> alternative, which has a compatible library (libmariadbd) that works
> exactly the same as mysql
>
> At the following bug report I have attached a Docker image for Ubuntu
> 19.10 that builds Amarok packages with MariaDB. Even if you are not
> familiar with Docker, you can use it as a reference to build your own
> Amarok. Let me know if you have issues building it.
>
> https://bugs.kde.org/show_bug.cgi?id=414407
>
> Pedro
>
> On Tue, Feb 25, 2020 at 8:20 PM subscription1 <llsubscr at zudiewiener.com>
> wrote:
>
>> Given that there is no support for the embedded MySql in (native) Ubuntu
>> 19+ I've started an implementation of SQLite as a possible alternative.
>>
>> I've created a branch that creates the SQLite DB, loads albums and
>> creates/plays dynamic playlists.
>>
>> There is (obviously) more work to do, but it's a start,
>>
>> Not sure where this should go next (if at all).
>>
>> Cheers,
>>
>> Leo
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/amarok-devel/attachments/20200309/05f1731d/attachment.html>