[csw-maintainers] Inconsistency on package database

[Maciej Bliziński]

Ben Walton wrote:
> Excerpts from Maciej Bliziński's message of Sun Feb 26 14:23:30 -0500 2012:
> 
> > http://quinoa.blizinski.pl/~maciej/opencsw/test.html
> > 
> > It is a static HTML file, and yet it displays current information
> > from the buildfarm database.  It dynamically fetches data from the
> > buildfarm and fills the fields on the page.
> > 
> > Arguably it adds about 1s to the page latency, but frees the package
> > browser from the problems with local database schema.
> 
> I'd think that replicating the db directly to the webserver and
> updating the package browser accordingly would be the best of both
> worlds though.  It would skip the latency but get the same always
> accurate, full featured information.
> 
> It could be ajax still, but wouldn't really need to be...
> 
> Thoughts?

We talked a little bit about it on IRC, and the rough conclusion was
that the web host could have an own db with a minimal schema. This
schema would be optimized for the web page serving, with potential
denormalizations allowing to achieve better website performance.
The integration from the buildfarm db to the web db could be done over
REST, allowing easy schema changes to the buildfarm db, or even a change
to a different database engine in the future.

Maciej
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <http://lists.opencsw.org/pipermail/maintainers/attachments/20120226/7b01cf5b/attachment.asc>