On Aug 04, Lenz Grimmer wrote:
> Hi Guys,
> Amarok, the audio player of KDE has recently switched to using MySQL
> embedded as their storage backend (they used SQLite before). They
> approached me with a few questions that I could need some help with,
> especially 1+2. Could some kind soul please provide me with some
> input? Thanks in advance!
> -------- Original Message --------
> Subject: Amarok support of MySQL Embedded
> Date: Tue, 29 Jul 2008 20:59:21 +0400
> From: Edward Hades <edward.hades@stripped>
> To: lenz@stripped
> CC: amarok-devel@stripped
> 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
> 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.
What's the DB schema that you use ? Table structures ?
> 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
Make it a bugreport.
> 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).
Make it a bugreport.
Regards / Mit vielen Grüssen,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ Principal Software Engineer/Server Architect
/_/ /_/\_, /___/\___\_\___/ Sun Microsystems GmbH, HRB München 161028
<___/ Sonnenallee 1, 85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Häring