Allowing sharing a database (was Re: extragear/multimedia/amarok/src)

[Ian Monroe]

On 10/2/07, Tobias G. Pfeiffer <tgpfeiffer at web.de> wrote:
> If there is no necessity to support multiple backends (with "everything with
> more than 10.000 tracks kills sqlite" or the like probably being
> a "necessity"), then you shouldn't do it. Especially because it gives you the
> possibility to tune your queries according to sqlite features, for example
> using bind variables and prepare statements at startup instead of have the
> query string being parsed on execution time.

We were thinking of using using MySQL embedded. There's a thread on
amarok-devel about it.

> BTW, isn't there a native way in Qt to handle multiple database backends, so
> you actually don't have to worry about that any more?

There is, but you still have to worry about what SQL you can use since
its a pretty low level abstraction. So low-level thats its worthless
IMO, probably mostly meant for the generic SQL widgets.

Ian