SQLite Pilot V1

[subscription1]

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 <mailto: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/20200305/50ad1b61/attachment.html>