Re: [GSoC 2019] Proposal: Develop Performance Farm Database andWebsite

Hi Ilaria,

Edited for bottom posting. :)

On Fri, Mar 29, 2019 at 03:01:05PM +0100, Ilaria wrote:
> > Am 29.03.2019 um 13:52 schrieb Peter Eisentraut <peter.eisentraut@2ndquadrant.com>:
> > 
> >> On 2019-03-29 13:04, Robert Haas wrote:
> >>> On Tue, Mar 26, 2019 at 9:10 AM Ila B. <ilaria.battiston@gmail.com> wrote:
> >>> I am Ilaria Battiston, an aspiring GSoC student, and I would love to have a feedback on the first draft of my
GoogleSummer of Code proposal. The project is "Develop Performance Farm Database and Website”. You can find any other
detailin the attached PDF file :)
 
> >> 
> >> I think there's probably a very large amount of work to be done in
> >> this area.  Nobody is going to finish it in a summer.  Still, there's
> >> probably some useful things you could get done in a summer.  I think a
> >> lot will depend on finding a good mentor who is familiar with these
> >> areas (which I am not).  Has anyone expressed an interest?
> > 
> > Moreover, I have a feeling that have been hearing about work on a
> > performance farm for many years.  Perhaps it should be investigated what
> > became of that work and what the problems were getting it to a working
> > state.

> Hello,
> 
> Thanks for the answer. This project is on the official PostgreSQL project list of GSoC 2019, and potential mentors
arestated there. 
 
> 
> I trust mentors’ judgement on outlining the work and the tasks to be done in three months, and there is the previous
student’swork to use as example if needed. The project consists in building a database and a website on top of it for
usersto browse performance data. 
 
> 
> Let me know whether there are any specific issues you’re concerned about. 

Hongyuan, our student last summer, put together a summary of his
progress in a GitHub issue:

https://github.com/PGPerfFarm/pgperffarm/issues/22


We have systems for proofing (from OSUOSL) and you can also see the
prototype here:

http://140.211.168.111/


For Phase 1, I'd recommend getting familiar with the database schema in
place now.  Perhaps it can use some tweaking, but I just mean to suggest
that it might not be necessary to rebuild it from scratch.

In Phase 2, we had some difficulty last year about getting the
authentication/authorization completely integrated.  I think the main
issue was how to integrate this app while using resources outside of the
community infrastructure.  We may have to continue working around that.

Otherwise, I think the rest make sense.  Let us know if you have any
more questions.

Regards,
Mark

-- 
Mark Wong
2ndQuadrant - PostgreSQL Solutions for the Enterprise
https://www.2ndQuadrant.com/