Re: GSoC 2011 - Mentors? Projects?

Hi!

PostgreSQL is applying for GSoC again this year. We're looking for:

* Mentors
* Project ideas

Would you like to mentor? Please let me know! Our application closes
on Friday, so please contact me *before* Friday.

I've started a wiki page: http://wiki.postgresql.org/wiki/GSoC_2011

It's seeded with last year's todo lists and information. We need to
add project ideas for students to it.

The wiki pages for 2008 and 2010 are available, including links to the
original student proposals:

http://wiki.postgresql.org/wiki/GSoC_2010
http://wiki.postgresql.org/wiki/GSoC_2008

Thanks!
-selena

--
http://chesnok.com

On 08/03/2011 07:44, Selena Deckelmann wrote:
> Hi!
>
> PostgreSQL is applying for GSoC again this year. We're looking for:
>
> * Mentors

Ready to mentor again this year for phpPgAdmin

> * Project ideas
>
> Would you like to mentor? Please let me know! Our application closes
> on Friday, so please contact me *before* Friday.
>
> I've started a wiki page: http://wiki.postgresql.org/wiki/GSoC_2011
>
> It's seeded with last year's todo lists and information. We need to
> add project ideas for students to it.

I updated the page with last year PPA project

> The wiki pages for 2008 and 2010 are available, including links to the
> original student proposals:
>
> http://wiki.postgresql.org/wiki/GSoC_2010
> http://wiki.postgresql.org/wiki/GSoC_2008
>
> Thanks!
> -selena
>

Hello!

I've following project proposal.

Currently GiST index don't have any bulk load functionality. It have to
create new index by entry insertion one by one. This makes new index
creation relatively slow.
There are various works in computer science about bulk operation on R-tree.
Since gist in basic is generalization of R-tree, some of them seems to
be applicable to GiST.
Following work seems to be most applicable to GiST:
"Efficient Bulk Operations on Dynamic R-Trees", L. Arge, K. H. Hinrichs, J.
Vahrenhold and J. S. Vitter
http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.135.9894&rep=rep1&type=pdf
I believe that implementation of methods of this work should allow to
significally reduce GiST index creation time (probably, it'll be possible to
achive acceleration of other operations too). Also, it's possible to achive
some results in computer science, since GiST is more general data structure
than R-tree.
I'm going to create wiki page for this project proposal soon.

I'm last year phd. student and I would like to participate in GSoC with
PostgreSQL. I would be especially happy to work with project above or other
project related to indexing.

----
With best regards,
Alexander Korotkov.

On Tue, Mar 8, 2011 at 9:44 AM, Selena Deckelmann <selena(at)chesnok(dot)com>wrote:

> Hi!
>
> PostgreSQL is applying for GSoC again this year. We're looking for:
>
> * Mentors
> * Project ideas
>
> Would you like to mentor? Please let me know! Our application closes
> on Friday, so please contact me *before* Friday.
>
> I've started a wiki page: http://wiki.postgresql.org/wiki/GSoC_2011
>
> It's seeded with last year's todo lists and information. We need to
> add project ideas for students to it.
>
> The wiki pages for 2008 and 2010 are available, including links to the
> original student proposals:
>
> http://wiki.postgresql.org/wiki/GSoC_2010
> http://wiki.postgresql.org/wiki/GSoC_2008
>
> Thanks!
> -selena
>
> --
> http://chesnok.com
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

Yes,

this would be very interesting project. It's not just about
bulk load (CREATE INDEX) but also about bulk insert, which is important
for update operations. As it adds two additional internal GiST methods, there
should be no problem with compatibility.

Oleg

On Tue, 8 Mar 2011, Alexander Korotkov wrote:

> Hello!
>
> I've following project proposal.
>
> Currently GiST index don't have any bulk load functionality. It have to
> create new index by entry insertion one by one. This makes new index
> creation relatively slow.
> There are various works in computer science about bulk operation on R-tree.
> Since gist in basic is generalization of R-tree, some of them seems to
> be applicable to GiST.
> Following work seems to be most applicable to GiST:
> "Efficient Bulk Operations on Dynamic R-Trees", L. Arge, K. H. Hinrichs, J.
> Vahrenhold and J. S. Vitter
> http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.135.9894&rep=rep1&type=pdf
> I believe that implementation of methods of this work should allow to
> significally reduce GiST index creation time (probably, it'll be possible to
> achive acceleration of other operations too). Also, it's possible to achive
> some results in computer science, since GiST is more general data structure
> than R-tree.
> I'm going to create wiki page for this project proposal soon.
>
> I'm last year phd. student and I would like to participate in GSoC with
> PostgreSQL. I would be especially happy to work with project above or other
> project related to indexing.
>
> ----
> With best regards,
> Alexander Korotkov.
>
> On Tue, Mar 8, 2011 at 9:44 AM, Selena Deckelmann <selena(at)chesnok(dot)com>wrote:
>
>> Hi!
>>
>> PostgreSQL is applying for GSoC again this year. We're looking for:
>>
>> * Mentors
>> * Project ideas
>>
>> Would you like to mentor? Please let me know! Our application closes
>> on Friday, so please contact me *before* Friday.
>>
>> I've started a wiki page: http://wiki.postgresql.org/wiki/GSoC_2011
>>
>> It's seeded with last year's todo lists and information. We need to
>> add project ideas for students to it.
>>
>> The wiki pages for 2008 and 2010 are available, including links to the
>> original student proposals:
>>
>> http://wiki.postgresql.org/wiki/GSoC_2010
>> http://wiki.postgresql.org/wiki/GSoC_2008
>>
>> Thanks!
>> -selena
>>
>> --
>> http://chesnok.com
>>
>> --
>> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-hackers
>>
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

Hi Alexander,

On Tue, Mar 8, 2011 at 12:13 PM, Alexander Korotkov
<aekorotkov(at)gmail(dot)com> wrote:

> I've following project proposal.

Thanks for getting a head start! One warning - we haven't been
accepted into GSoC yet. :) I'll be sure to contact you if we are
accepted!

> Currently GiST index don't have any bulk load functionality. It have to
> create new index by entry insertion one by one. This makes new index
> creation relatively slow.
> There are various works in computer science about bulk operation on R-tree.
> Since gist in basic is generalization of R-tree, some of them seems to
> be applicable to GiST.
> Following work seems to be most applicable to GiST:
> "Efficient Bulk Operations on Dynamic R-Trees", L. Arge, K. H. Hinrichs, J.
> Vahrenhold and J. S. Vitter
> http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.135.9894&rep=rep1&type=pdf
> I believe that implementation of methods of this work should allow to
> significally reduce GiST index creation time (probably, it'll be possible to
> achive acceleration of other operations too). Also, it's possible to achive
> some results in computer science, since GiST is more general data structure
> than R-tree.
> I'm going to create wiki page for this project proposal soon.

That sounds great. Please go ahead and create the page now.

-selena

--
http://chesnok.com

> Hi!
>
> PostgreSQL is applying for GSoC again this year. We're looking for:
>
> * Mentors

Can I be a metor for pgpool-II?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> * Project ideas
>
> Would you like to mentor? Please let me know! Our application closes
> on Friday, so please contact me *before* Friday.
>
> I've started a wiki page: http://wiki.postgresql.org/wiki/GSoC_2011
>
> It's seeded with last year's todo lists and information. We need to
> add project ideas for students to it.
>
> The wiki pages for 2008 and 2010 are available, including links to the
> original student proposals:
>
> http://wiki.postgresql.org/wiki/GSoC_2010
> http://wiki.postgresql.org/wiki/GSoC_2008
>
> Thanks!
> -selena
>
> --
> http://chesnok.com
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

On Tue, Mar 8, 2011 at 3:52 PM, Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:
>> Hi!
>>
>> PostgreSQL is applying for GSoC again this year. We're looking for:
>>
>> * Mentors
>
> Can I be a metor for pgpool-II?

Yes! I can't guarantee that we will get student proposals for it. But,
we will have a greater chance of student proposals for things if we
specifically list out projects that you'd like a student to tackle.

Could you add a few items to the wiki page for pgpool-II?
http://wiki.postgresql.org/wiki/GSoC_2011#Project_Ideas

Thanks!
-selena

--
http://chesnok.com

>> Can I be a metor for pgpool-II?
>
> Yes! I can't guarantee that we will get student proposals for it. But,
> we will have a greater chance of student proposals for things if we
> specifically list out projects that you'd like a student to tackle.
>
> Could you add a few items to the wiki page for pgpool-II?
> http://wiki.postgresql.org/wiki/GSoC_2011#Project_Ideas

Ok, I will do it.

> Thanks!

Thanks!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

Hi Selena,

On Mon, 2011-03-07 at 22:44 -0800, Selena Deckelmann wrote:
>
> PostgreSQL is applying for GSoC again this year. We're looking for:
>
> * Mentors
> * Project ideas
>
> Would you like to mentor? Please let me know! Our application closes
> on Friday, so please contact me *before* Friday.

Please count me in as a mentor for a GUI project. It is an open source
dashboard for PostgreSQL DBAs, called ADJ Dashboard.

Erdinc (I CC'ed him) is/will be working on the project.

This is my first touch with GSoC, please let me know if I'm missing
anything.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

2011/3/14 Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>:
>
> Hi Selena,
>
> On Mon, 2011-03-07 at 22:44 -0800, Selena Deckelmann wrote:
>>
>> PostgreSQL is applying for GSoC again this year. We're looking for:
>>
>> * Mentors
>> * Project ideas
>>
>> Would you like to mentor? Please let me know! Our application closes
>> on Friday, so please contact me *before* Friday.
>
> Please count me in as a mentor for a GUI project. It is an open source
> dashboard for PostgreSQL DBAs, called ADJ Dashboard.

I can't find any info on that via Google. URL please?

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, 2011-03-14 at 16:08 +0000, Dave Page wrote:
> >
> > Please count me in as a mentor for a GUI project. It is an open
> source
> > dashboard for PostgreSQL DBAs, called ADJ Dashboard.
>
> I can't find any info on that via Google. URL please?

Erdinc said that he will setup a web page for this, and let the list
know.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

Greetings,

ADJ Dashboard project small description is written
https://github.com/hzroot/ADJ-Dashboard/wiki here. If you give suggestions
(what you need as a dba? or what you use most? etc.. ), it will be great!

22 Mart 2011 03:51 tarihinde Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> yazdı:

> On Mon, 2011-03-14 at 16:08 +0000, Dave Page wrote:
> > >
> > > Please count me in as a mentor for a GUI project. It is an open
> > source
> > > dashboard for PostgreSQL DBAs, called ADJ Dashboard.
> >
> > I can't find any info on that via Google. URL please?
>
> Erdinc said that he will setup a web page for this, and let the list
> know.
>
> Regards,
> --
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
>

--
Erdinc Akkaya

Dne 8.3.2011 07:44, Selena Deckelmann napsal(a):
> Hi!
>
> PostgreSQL is applying for GSoC again this year. We're looking for:
>
> * Mentors
> * Project ideas
>
> Would you like to mentor? Please let me know! Our application closes
> on Friday, so please contact me *before* Friday.
>
> I've started a wiki page: http://wiki.postgresql.org/wiki/GSoC_2011

Hi,

I spoke to a teacher from a local university last week, mainly as we
were looking for a place where a local PUG could meet regularly. I
realized this could be a good opportunity to head-hunt some students to
participate in this GSoC. Are we still interested in new students?

I've never been involved in GSoC before, so I'm not quite sure how all
this works. Should the student choose a project idea from the wiki,
contact one of the mentors, write to pgsql-students or how is that
supposed to work?

I've noticed the student application deadline is April 8, so it would be
a bit rush, I guess. Is that worth a try?

regards
Tomas

Tomas,

> I spoke to a teacher from a local university last week, mainly as we
> were looking for a place where a local PUG could meet regularly. I
> realized this could be a good opportunity to head-hunt some students
> to
> participate in this GSoC. Are we still interested in new students?

Yes, please! We have had students from Charles University several times before, and would be glad to have more. The wiki page has links to the information about the program. Talk to Zdenek if you have more questions.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
San Francisco

Dne 26.3.2011 02:05, Joshua Berkus napsal(a):
> Tomas,
>
>> I spoke to a teacher from a local university last week, mainly as we
>> were looking for a place where a local PUG could meet regularly. I
>> realized this could be a good opportunity to head-hunt some students
>> to
>> participate in this GSoC. Are we still interested in new students?
>
> Yes, please! We have had students from Charles University several
> times before, and would be glad to have more. The wiki page has
> links to the information about the program. Talk to Zdenek if you
> have more questions.
>

I know Zdenek was mentoring some students in the previous years, but
he's been a bit hard to reach recently. And the deadline is near.

I've read some info about the program on a wiki, but I'm not sure what
should the students do. Let's say they will read the list of project
ideas on the wiki, and they'll choose one or two of them. What should
they do next? Should they write to the pgsql-students mailing list?

I guess most of the students won't have much experience with PostgreSQL,
and most of the ideas is described just very briefly, so they'll need
help with the proposal.

regards
Tomas

Le 26/03/2011 02:43, Tomas Vondra a écrit :
> Dne 26.3.2011 02:05, Joshua Berkus napsal(a):
>> Tomas,
>>
>>> I spoke to a teacher from a local university last week, mainly as we
>>> were looking for a place where a local PUG could meet regularly. I
>>> realized this could be a good opportunity to head-hunt some students
>>> to
>>> participate in this GSoC. Are we still interested in new students?
>>
>> Yes, please! We have had students from Charles University several
>> times before, and would be glad to have more. The wiki page has
>> links to the information about the program. Talk to Zdenek if you
>> have more questions.
>>
>
> I know Zdenek was mentoring some students in the previous years, but
> he's been a bit hard to reach recently. And the deadline is near.
>
> I've read some info about the program on a wiki, but I'm not sure what
> should the students do. Let's say they will read the list of project
> ideas on the wiki, and they'll choose one or two of them. What should
> they do next? Should they write to the pgsql-students mailing list?
>

They could write to the pgsql-students list. There are already some
threads about items to work on.

> I guess most of the students won't have much experience with PostgreSQL,
> and most of the ideas is described just very briefly, so they'll need
> help with the proposal.
>

Sure. Two lists AFAICT, pgsql_students and pgsql-hackers.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com