MySQL embedded? The future of our database?

[Maximilian Kossick]

On Saturday 08 September 2007, Seb Ruiz wrote:
> On 08/09/2007, Mark Kretschmann <kretschmann at kde.org> wrote:
> > Hey Amarokers,
> >
> > I just had this interesting discussion with Hydrogen on the future of
> > our database. I hope you don't mind me just pasting the IRC log; I
> > think it's more insightful than summarizing the content:
>
> Is it not important to keep in mind our users who host music and
> database on a fileserver, with a shared database? This is impossible
> with sqlite.

With mysql, we can use a stand-alone mysql server simply by linking to a 
different library. Therefore we could default to an embedded mysql server, 
but allow our users to switch to an external server.

Additionally, using mysql (or postgres, or any sql server whose sql support 
does not suck quite as much as sqlite) would make writing our SQL a lot 
easier. mysql actually supports all those alter table. and while we have not 
used foreign keys so far because of sqlite, they are useful, but not 
critical. And then there's support for nested queries:)

Max
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part.
Url : http://mail.kde.org/pipermail/amarok-devel/attachments/20070908/de824d02/attachment.pgp