[KPhotoAlbum] Optimization of index.xml

[Shawn Willden]

On Monday 04 September 2006 15:13, William Holland wrote:
> However I'm a fan of not re-inventing the wheel, so does anyone know of any
> already existing tools for 'merging' databases?

I don't like reinventing wheels either, but I also don't like using tools that 
don't quite do the job -- not when it's a job I have to do regularly.  

> Or is it genuinely a trivial task to write the code for the merge?

Trivial?   I wouldn't call it that, but I also don't think it would be 
particularly difficult, based on a recent experience implenting an 
app-specific database synchronization system for work.  That system was 
one-way, not bi-directional like this would need to be, but it wouldn't be a 
large additional step.

Actually, after some more thought, I think what I really want isn't an 
additional synchronization tool, but to be able to configure KPA to use two 
databases, a local database and a master database, and to handle the 
synchronization automatically.

The first step, though, is to ensure that the necessary metadata is in place 
to make synchronization possible.  That is nice thing about using, for 
example, MySQL's master/slave replication -- MySQL already provides the 
necessary infrastructure in the form of the binary logfiles.

Hopefully Tuomas has thought about synchronization.  If not, some new database 
tables and/or columns may be required.

	Shawn.