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
signature.asc
Description: Digital signature
_______________________________________________ maintainers mailing list [email protected] https://lists.opencsw.org/mailman/listinfo/maintainers .:: This mailing list's archive is public. ::.
