Thread: [GSoC 2019] Proposal: Develop Performance Farm Database and Website
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
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
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
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/
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/