<div dir="ltr">Hi Leo,<div><br></div><div>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.<br><br>I will take a look at your code as soon as I have some time.</div><div><br></div><div>Regards,</div><div><br></div><div>Pedro</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Mar 5, 2020 at 2:13 AM subscription1 <<a href="mailto:llsubscr@zudiewiener.com">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>Hi Pedro,</p>
<p>Your MariaDB solution works as far as I can tell. Wish I knew
this before I spent 2 months on the SQLite solution;-(</p>
<p>Still, learned a lot in the process</p>
<p>Here is what I did</p>
<p>1) Installed Kubuntu 19.10 (on a VM)</p>
<p>2) Installed all prerequiste software as per your docker; the
only thing I added was libphonon4qt5-dev</p>
<p>apt-get install -y cmake extra-cmake-modules g++ git
libmariadb-dev libmariadbd-dev pkg-config \<br>
qtdeclarative5-dev qtscript5-dev libqt5svg5-dev
qtquickcontrols2-5-dev qtwebengine5-dev \<br>
libkf5archive-dev libkf5attica-dev libkf5codecs-dev
libkf5config-dev libkf5configwidgets-dev libkf5coreaddons-dev
libkf5crash-dev \<br>
libkf5dbusaddons-dev libkf5declarative-dev libkf5dnssd-dev
libkf5globalaccel-dev libkf5guiaddons-dev libkf5i18n-dev
libkf5iconthemes-dev \<br>
libkf5kcmutils-dev libkf5kio-dev libkf5newstuff-dev
libkf5notifications-dev libkf5notifyconfig-dev libkf5package-dev
libkf5solid-dev \<br>
libkf5texteditor-dev libkf5threadweaver-dev
libkf5widgetsaddons-dev libkf5windowsystem-dev libkf5wallet-dev
kirigami2-dev \<br>
gettext libtag1-dev libtag-extras-dev libavcodec-dev
libavformat-dev libavdevice-dev libavutil-dev libswscale-dev
libpostproc-dev \<br>
libgpod-dev libgdk-pixbuf2.0-dev libmygpo-qt-dev libmtp-dev
libcurl4-openssl-dev libxml2-dev libssl-dev libgcrypt20-dev \<br>
libfftw3-dev libloudmouth1-dev libofa0-dev liblastfm5-dev
libgmock-dev libphonon4qt5-dev<br>
</p>
<p>3) cloned amarok <br>
</p>
<p>4) built/installed amarok (my dev environment is under /kdedev)</p>
<p>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/</p>
<p>cmake --build .</p>
<p>make install</p>
<p>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.</p>
<p>Thanks,</p>
<p>Leo</p>
<p><br>
</p>
<div>On 28/2/20 1:46 am, Pedro de Carvalho
Gomes wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hi,
<div><br>
</div>
<div>Is this branch available somewhere? I may take a lot and
help you with that.<br>
<br>
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 </div>
<div><br>
</div>
<div>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.</div>
<div><br>
<a href="https://bugs.kde.org/show_bug.cgi?id=414407" target="_blank">https://bugs.kde.org/show_bug.cgi?id=414407</a><br>
<br>
Pedro</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Feb 25, 2020 at 8:20
PM subscription1 <<a href="mailto:llsubscr@zudiewiener.com" 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">Given
that there is no support for the embedded MySql in (native)
Ubuntu <br>
19+ I've started an implementation of SQLite as a possible
alternative.<br>
<br>
I've created a branch that creates the SQLite DB, loads albums
and <br>
creates/plays dynamic playlists.<br>
<br>
There is (obviously) more work to do, but it's a start,<br>
<br>
Not sure where this should go next (if at all).<br>
<br>
Cheers,<br>
<br>
Leo<br>
<br>
</blockquote>
</div>
</blockquote>
</div>
</blockquote></div>