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

[Tobias G. Pfeiffer]

Hi!

On Wednesday 03 October 2007, 08:40, Bart Cerneels wrote:
> 2007/10/2, Tobias G. Pfeiffer <tgpfeiffer at web.de>:
> > 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?
>
> I believe there is and I wonder why it is not at all. I would to see
> the relevant people comment on this.

This would be quite an interesting information. As I just saw, the QtSql 
module even supports prepared statements and other advanced features. There 
is also a class QSqlRecord that represents (surprise!) a record in the 
database, with methods such as QSqlRecord::value(columnName) or 
QSqlRecord::setValue(columnName, newValue), i.e. exactly the things that the 
current Meta::Sql* classes do by manually calling the corresponding SQL 
statements. I suppose the use of QtSql would simplify (and possibly speed up) 
everything a lot.

In addition, I'd propose to split up the database into collection-relevant 
data and player-relevant data. The collection-relevant could be shared with 
other clients, on a MySQL/PostgreSQL server (or a sqlite file, in normal 
case) while the player-relevant data (e.g. current playlist) would always be 
locally stored as sqlite file. Any comments on this?

Bye
Tobias

-- 
follow the penguin...
-------------- 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/20071005/07f248bb/attachment.pgp