Thread: [GSoC 2019] Proposal: Develop Performance Farm Database and Website

[GSoC 2019] Proposal: Develop Performance Farm Database and Website

From
"Ila B."
Date:
Good morning everyone,

I am Ilaria Battiston, an aspiring GSoC student, and I would love to have a feedback on the first draft of my Google
Summerof Code proposal. The project is "Develop Performance Farm Database and Website”. You can find any other detail
inthe attached PDF file :) 

Thank you,
Ilaria



Attachment

Re: [GSoC 2019] Proposal: Develop Performance Farm Database and Website

From
Robert Haas
Date:
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 Google
Summerof Code proposal. The project is "Develop Performance Farm Database and Website”. You can find any other detail
inthe 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?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

From
Peter Eisentraut
Date:
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 Google
Summerof Code proposal. The project is "Develop Performance Farm Database and Website”. You can find any other detail
inthe 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.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



Hello,

Thanks for the answer. This project is on the official PostgreSQL project list of GSoC 2019, and potential mentors are
statedthere.  

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.

Ilaria

> 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.
>
> --
> Peter Eisentraut              http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

From
Mark Wong
Date:
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/



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

From
"Ila B."
Date:
Thank you so much for your answer, it provided a clearer understanding of the task and it was really useful to complete
myproposal which I’ve now submitted. I really hope to keep on working with Postgres. 

Best of luck to all GSoC students :)

Ilaria

> On 4 Apr 2019, at 18:59, Mark Wong <mark@2ndQuadrant.com> wrote:
>
> 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/