Amarok support of MySQL Embedded

Edward Hades edward.hades at gmail.com
Tue Jul 29 18:59:21 CEST 2008


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello Lanz!

I currently work on MySQL Embedded integration into Amarok and was told
that you have been enthusiastic about it and that we could count on your
help. So we do ;)

We have successfully managed to compile and run Amarok with it, but had
several issues with that (rated in order of increasing significance):

1. Key limit in MyISAM engine is 1000 bytes. Amarok currently uses
larger keys, and I had to manually increase this limit. I guess we
should actually work on some db redesign to eliminate these keys, since
they bring performance drawback, but I am not a DB specialist, and we
would really appreciate an inside view on what to do best here.

2. MySQL embedded uses exit() when it encounters a severe error. I am
not sure what is the threshold of severity between exit() and
non-exit(), but still it would be hardly friendly for a GUI program to
quit abruptly without any error messages and such. I understand, that
this code is shared with big MySQL brother, but I've managed to evade it
with simple macro that redefines exit(). Maybe there is a better way to
tell MySQL to use slightly less radical approach to error handling?

3. It builds by default with no -fPIC flag, and that is bad for us,
because our SQL-related code resides in a shared library. I did not dig
MySQL's configure scripts, but I think it should honor --with-pic flag
when building libmysqld.a (which it does not).

Thank you in advance for your support, we hope that Amarok is doomed to
long and prosper life with MySQL embedded as DB backend.

- --
Edward "Hades" Toroshchin,
IRC nickname: Aides (#amarok at irc.freenode.org)
mailto:edward.hades at gmail.com

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkiPTGkACgkQd7FTKeBdCdMIYgCfWBlQPNU06k3nbAC/7WVS0Xv0
AV8AnjMcWR4JAkLJFu3goUURkeq2DKMu
=ss/4
-----END PGP SIGNATURE-----


More information about the Amarok-devel mailing list