Discussion:
Call for Google Summer of Code mentors, admins
(too old to reply)
Josh Berkus
2013-02-14 18:02:13 UTC
Permalink
Folks,

Once again, Google is holding Summer of Code. We need to assess whether
we want to participate this year.

Questions:

- Who wants to mentor for GSOC?

- Who can admin for GSOC? Thom?

- Please suggest project ideas for GSOC

- Students seeing this -- please speak up if you have projects you plan
to submit.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Sîrbu Nicolae-Cezar
2013-02-14 21:38:18 UTC
Permalink
Hello,

Well i'm interested in PostgreSQL for GSOC, i'm not sure for the project
yet. But i'm looking forward in meeting the mentors and speak with them
what could be implemented over the summer.

Thanks,
Sirbu Nicolae-Cezar
Thom Brown
2013-02-14 22:48:48 UTC
Permalink
Post by Josh Berkus
Folks,
Once again, Google is holding Summer of Code. We need to assess whether
we want to participate this year.
- Who wants to mentor for GSOC?
- Who can admin for GSOC? Thom?
I don't mind being an admin again.
--
Thom
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Josh Berkus
2013-03-09 01:01:53 UTC
Permalink
Thom.
Post by Thom Brown
I don't mind being an admin again.
Can you gather together all of the projects suggested on this thread and
use them to create updated text for the GSOC page? If you don't have
web repo access, I can create a patch, but if you can do the text, that
would be a big help.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Thom Brown
2013-03-09 17:42:37 UTC
Permalink
Post by Josh Berkus
Thom.
Post by Thom Brown
I don't mind being an admin again.
Can you gather together all of the projects suggested on this thread and
use them to create updated text for the GSOC page? If you don't have
web repo access, I can create a patch, but if you can do the text, that
would be a big help.
Okay, I've pushed some changes to the repo for 2013 GSoC, and purged
the varnish cache so that it's visible immediately:
http://www.postgresql.org/developer/summerofcode/

I've also created a new GSoC 2013 wiki page with mentor volunteers and
project ideas submitted so far:
https://wiki.postgresql.org/wiki/GSoC_2013

--
Thom
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Josh Berkus
2013-03-10 00:08:14 UTC
Permalink
Thom,
Post by Thom Brown
Okay, I've pushed some changes to the repo for 2013 GSoC, and purged
http://www.postgresql.org/developer/summerofcode/
I've also created a new GSoC 2013 wiki page with mentor volunteers and
https://wiki.postgresql.org/wiki/GSoC_2013
Nice work!

Please change the list of admins on /summerofcode/ to you and me.

I'll see about filling in more details on the suggested projects.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Thom Brown
2013-03-10 00:21:04 UTC
Permalink
Post by Josh Berkus
Thom,
Post by Thom Brown
Okay, I've pushed some changes to the repo for 2013 GSoC, and purged
http://www.postgresql.org/developer/summerofcode/
I've also created a new GSoC 2013 wiki page with mentor volunteers and
https://wiki.postgresql.org/wiki/GSoC_2013
Nice work!
Please change the list of admins on /summerofcode/ to you and me.
Done.
--
Thom
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Alvaro Herrera
2013-02-15 02:55:30 UTC
Permalink
Post by Josh Berkus
Folks,
Once again, Google is holding Summer of Code. We need to assess whether
we want to participate this year.
- Who wants to mentor for GSOC?
I am open to being a mentor.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Dimitri Fontaine
2013-02-15 10:51:22 UTC
Permalink
Post by Alvaro Herrera
Post by Josh Berkus
- Who wants to mentor for GSOC?
I am open to being a mentor.
Me too.
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Sîrbu Nicolae-Cezar
2013-02-15 12:29:08 UTC
Permalink
Hello,

Can you guys send me a link to a where to start page ?

Thanks,
Sirbu Nicolae-Cezar
Atri Sharma
2013-02-15 14:03:03 UTC
Permalink
Can't we have something related to machine learning? I was thinking of extending a technique where we can fill in some missing values in a data set for the user if he wants us to using some standard ml algorithms.

Atri

Sent from my iPad
Post by Sîrbu Nicolae-Cezar
Hello,
Can you guys send me a link to a where to start page ?
Take a look at the Project Ideas page from last year, and the project TODO list. See http://www.postgresql.org/developer/summerofcode/#ideas.
One approach is to pick a research paper on some algorithm or technique that's applicable to databases, and then implement that in PostgreSQL.
- Heikki
--
http://www.postgresql.org/mailpref/pgsql-hackers
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Josh Berkus
2013-02-15 17:34:11 UTC
Permalink
Post by Atri Sharma
Can't we have something related to machine learning? I was thinking of extending a technique where we can fill in some missing values in a data set for the user if he wants us to using some standard ml algorithms.
Take a look at MADLib. My suggestion would be extending the MADlib
functions; there's plenty of unimplemented ML algrothims which could be
added to it.

http://madlib.net/
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Atri Sharma
2013-02-15 18:20:33 UTC
Permalink
I would love to mentor if anybody would be willing to take a project in it.

Atri

Sent from my iPad
Post by Josh Berkus
Post by Atri Sharma
Can't we have something related to machine learning? I was thinking of extending a technique where we can fill in some missing values in a data set for the user if he wants us to using some standard ml algorithms.
Take a look at MADLib. My suggestion would be extending the MADlib
functions; there's plenty of unimplemented ML algrothims which could be
added to it.
http://madlib.net/
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Atri Sharma
2013-02-24 06:38:30 UTC
Permalink
Post by Josh Berkus
Take a look at MADLib. My suggestion would be extending the MADlib
functions; there's plenty of unimplemented ML algrothims which could be
added to it.
I went through the MADLib library and came up with the following two
ideas which I feel could be potential GSoC 2013 projects:

1) MADlib currently has K-means clustering implemented.I would suggest
implementing the K-medoids clustering as it has better performance as
compared to K-means clustering.We could use k-means clustering code
base as the starting point for our implementation.

2) A more complex project would be to implement backpropogation
algorithm for much better classification. This would require
implementing some parts of neural network algorithms as well.

Again, I am willing to mentor either of the two projects if they are taken.

Regards,

Atri
--
Regards,

Atri
l'apprenant
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Heikki Linnakangas
2013-02-15 13:56:45 UTC
Permalink
Post by Sîrbu Nicolae-Cezar
Hello,
Can you guys send me a link to a where to start page ?
Take a look at the Project Ideas page from last year, and the project
TODO list. See http://www.postgresql.org/developer/summerofcode/#ideas.

One approach is to pick a research paper on some algorithm or technique
that's applicable to databases, and then implement that in PostgreSQL.

- Heikki
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Gilberto Castillo
2013-02-15 19:19:45 UTC
Permalink
Post by Josh Berkus
Folks,
Once again, Google is holding Summer of Code. We need to assess whether
we want to participate this year.
- Who wants to mentor for GSOC?
I am open to being a mentor too.

Saludos,
Gilberto Castillo
La Habana, Cuba
Atri Sharma
2013-02-15 03:22:28 UTC
Permalink
I forgot to mark all.

I could be a co mentor, helping in overall coordination and supporting all the students in getting familiar with the project and community etc.

Atri

Sent from my iPad
Post by Josh Berkus
Folks,
Once again, Google is holding Summer of Code. We need to assess whether
we want to participate this year.
- Who wants to mentor for GSOC?
- Who can admin for GSOC? Thom?
- Please suggest project ideas for GSOC
- Students seeing this -- please speak up if you have projects you plan
to submit.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
http://www.postgresql.org/mailpref/pgsql-advocacy
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Atri Sharma
2013-02-15 03:21:40 UTC
Permalink
I forgot to mark all.

I could be a co mentor, helping in overall coordination and supporting all the students in getting familiar with the project and community etc.

Atri

Sent from my iPad
Post by Josh Berkus
- Who wants to mentor for GSOC?
I could be a mentor.
Post by Josh Berkus
- Who can admin for GSOC? Thom?
- Please suggest project ideas for GSOC
Will think on this.
Thanks,
Stephen
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
David Fetter
2013-02-18 17:12:59 UTC
Permalink
Post by Josh Berkus
Folks,
Once again, Google is holding Summer of Code. We need to assess whether
we want to participate this year.
- Who wants to mentor for GSOC?
I'd be up for this.
Post by Josh Berkus
- Who can admin for GSOC? Thom?
- Please suggest project ideas for GSOC
UPDATE ... RETURNING OLD
Add RETURNING to DDL (CREATE, ALTER, DROP) and possible DCL (GRANT, REVOKE), time permitting.

Cheers,
David.
--
David Fetter <***@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: ***@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Simon Riggs
2013-04-08 21:06:58 UTC
Permalink
Just reading GSoC project ideas...
Post by David Fetter
Post by Josh Berkus
- Please suggest project ideas for GSOC
UPDATE ... RETURNING OLD
Not sure what that is, but...
Post by David Fetter
Add RETURNING to DDL (CREATE, ALTER, DROP) and possible DCL (GRANT,
REVOKE), time permitting.
-1 on that idea

Making DDL less standard and more complex isn't good.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
Alvaro Herrera
2013-04-08 21:09:16 UTC
Permalink
Post by Simon Riggs
Post by David Fetter
Add RETURNING to DDL (CREATE, ALTER, DROP) and possible DCL (GRANT,
REVOKE), time permitting.
-1 on that idea
Making DDL less standard and more complex isn't good.
I think this need is served by having event triggers on DDL and DCL.
Not sure whether improving event triggers can be a good GSoC proposal.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
David Fetter
2013-04-08 21:25:21 UTC
Permalink
Post by Simon Riggs
Just reading GSoC project ideas...
Post by David Fetter
Post by Josh Berkus
- Please suggest project ideas for GSOC
UPDATE ... RETURNING OLD
Not sure what that is, but...
Perhaps asking would help :)

At the moment, we have a system where only some DML commands return
rows, and then only sometimes, to wit:

- SELECT generally returns rows.
- INSERT can return expressions on the rows inserted with a RETURNING
clause.
- UPDATE ... RETURNING can return expressions on new versions of the
rows affected, but not the old ones.
- DELETE can return expressions on the rows deleted.

Of the above, only SELECT can return aggregates.

There are several more DML operations with odd inability to return
rows, but UPDATE's the one that really stands out, and is a bite-sized
chunk in the sense of having a relatively small scope of design and
not touching parts of the system unless they use the new grammar.
Post by Simon Riggs
Post by David Fetter
Add RETURNING to DDL (CREATE, ALTER, DROP) and possible DCL (GRANT,
REVOKE), time permitting.
-1 on that idea
Making DDL less standard and more complex isn't good.
Sometimes implementations lead the standard, as POSTGRES did. In no
case have I proposed anything which would conflict with any existing
or (to the best of my knowledge) any proposed standard.

Would a PoC implementation with docs help get better lights on this?

Cheers,
David.
--
David Fetter <***@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: ***@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Dimitri Fontaine
2013-04-09 08:22:20 UTC
Permalink
Post by David Fetter
Post by David Fetter
UPDATE ... RETURNING OLD
There are several more DML operations with odd inability to return
rows, but UPDATE's the one that really stands out, and is a bite-sized
chunk in the sense of having a relatively small scope of design and
not touching parts of the system unless they use the new grammar.
Which makes me think about having OLD and NEW "relations" available in
per statement triggers, too. Would that be a SoC sized projects? Maybe
if the relation is simply a SRF…

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
David Fetter
2013-04-09 16:13:04 UTC
Permalink
Post by Dimitri Fontaine
Post by David Fetter
Post by David Fetter
UPDATE ... RETURNING OLD
There are several more DML operations with odd inability to return
rows, but UPDATE's the one that really stands out, and is a bite-sized
chunk in the sense of having a relatively small scope of design and
not touching parts of the system unless they use the new grammar.
Which makes me think about having OLD and NEW "relations" available in
per statement triggers, too. Would that be a SoC sized projects? Maybe
if the relation is simply a SRF…
Are you envisioning this as a common infrastructure to both?

Cheers,
David.
--
David Fetter <***@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: ***@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Dimitri Fontaine
2013-04-09 16:27:13 UTC
Permalink
Post by David Fetter
Post by Dimitri Fontaine
Post by David Fetter
Post by David Fetter
UPDATE ... RETURNING OLD
There are several more DML operations with odd inability to return
rows, but UPDATE's the one that really stands out, and is a bite-sized
chunk in the sense of having a relatively small scope of design and
not touching parts of the system unless they use the new grammar.
Which makes me think about having OLD and NEW "relations" available in
per statement triggers, too. Would that be a SoC sized projects? Maybe
if the relation is simply a SRF…
Are you envisioning this as a common infrastructure to both?
I don't think so. Would happily be proven wrong, though :)

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Kevin Grittner
2013-04-09 16:39:52 UTC
Permalink
Post by David Fetter
Post by Dimitri Fontaine
Post by David Fetter
Post by David Fetter
UPDATE ... RETURNING OLD
There are several more DML operations with odd inability to
return rows, but UPDATE's the one that really stands out, and
is a bite-sized chunk in the sense of having a relatively small
scope of design and not touching parts of the system unless
they use the new grammar.
Which makes me think about having OLD and NEW "relations"
available in per statement triggers, too. Would that be a SoC
sized projects? Maybe if the relation is simply a SRF…
Are you envisioning this as a common infrastructure to both?
This may also wind up sharing some infrastructure with incremental
mainenance of materialized views.  The most efficient and provably
correct optimization of that I've found in the literature[1] seems
to me to require the ability to accumulate "delta relations", and
it has been occuring to me how easy it would be to use a delta
relation for a statement to supply the OLD and NEW relations for an
FOR EACH STATEMENT trigger.

I don't really want to get into a design discussion about
incremental maintenance of matviews at this time, but felt that I
should give a "heads up" about potentially overlapping work.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


[1]  http://dl.acm.org/citation.cfm?id=170066&dl=ACM&coll=DL&CFID=202507837&CFTOKEN=96875563
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Andres Freund
2013-02-18 21:37:11 UTC
Permalink
Post by Josh Berkus
- Please suggest project ideas for GSOC
pg_upgrade support for debian's pg_upgradecluster

Greetings,

Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Magnus Hagander
2013-02-18 21:38:45 UTC
Permalink
Post by Josh Berkus
Folks,
Once again, Google is holding Summer of Code. We need to assess whether
we want to participate this year.
- Who wants to mentor for GSOC?
Sign me up on that list. Depending on projects, of course.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Josh Berkus
2013-02-19 20:38:46 UTC
Permalink
This was discussed before in this thread [1] but we don't reach a consensus
of what we'll do, so I propose we discuss any more about it and I can
implement it in GSOC2013, if my proposal will be accepted.
As a mentor or as a student?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Thom Brown
2013-03-19 17:42:58 UTC
Permalink
Post by Josh Berkus
Folks,
Once again, Google is holding Summer of Code. We need to assess whether
we want to participate this year.
- Who wants to mentor for GSOC?
- Who can admin for GSOC? Thom?
- Please suggest project ideas for GSOC
- Students seeing this -- please speak up if you have projects you plan
to submit.
If anyone else has more projects ideas to suggest, please do share.
Students, please feel free to review the PostgreSQL Todo list for
inspiration: http://wiki.postgresql.org/wiki/Todo Of course ensure
you don't choose anything too ambitious or trivial.

--
Thom
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Thom Brown
2013-03-20 16:03:23 UTC
Permalink
Post by Thom Brown
Post by Josh Berkus
Folks,
Once again, Google is holding Summer of Code. We need to assess whether
we want to participate this year.
- Who wants to mentor for GSOC?
- Who can admin for GSOC? Thom?
- Please suggest project ideas for GSOC
- Students seeing this -- please speak up if you have projects you plan
to submit.
If anyone else has more projects ideas to suggest, please do share.
Students, please feel free to review the PostgreSQL Todo list for
inspiration: http://wiki.postgresql.org/wiki/Todo Of course ensure
you don't choose anything too ambitious or trivial.
Okay, here's a random idea (which could be infeasible and/or
undesirable). How about a way to internally schedule tasks using a
background worker process (introduced in 9.2) to wake on each tick and
run tasks?

So:

CREATE EXTENSION pg_scheduler;
--
schedule_task(task_command, task_priority, task_start, repeat_interval);

SELECT schedule_task('REINDEX my_table', 1, '2012-03-20
00:10:00'::timestamp, '1 week'::interval);

SELECT list_tasks();

-[ RECORD 1 ]---+-----------------------
task_id | 1
task_command | REINDEX my_table
task_priority | 1
task_start | 2012-03-20 00:10:00-04
repeat_interval | 7 days
owner | postgres

SELECT delete_task(1);

Tasks would be run in sequence if they share the same scheduled time
ordered by priority descending, beyond which it would be
non-deterministic. Or perhaps additional worker processes to fire
commands in parallel if necessary.

Disclaimer: I haven't really thought this through.

--
Thom
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Atri Sharma
2013-03-20 17:05:26 UTC
Permalink
It does sound nice,something like cron?

We can use a scheduling algorithm, and can define a pool of tasks as well as a time constraint for the amount of time which can be used for running the tasks.Then, a scheduling algorithm can pick tasks from the pool based on priorities and the time duration of a task.I can see a dynamic programming solution to this problem.

Atri

Sent from my iPad
Post by Thom Brown
Post by Thom Brown
Post by Josh Berkus
Folks,
Once again, Google is holding Summer of Code. We need to assess whether
we want to participate this year.
- Who wants to mentor for GSOC?
- Who can admin for GSOC? Thom?
- Please suggest project ideas for GSOC
- Students seeing this -- please speak up if you have projects you plan
to submit.
If anyone else has more projects ideas to suggest, please do share.
Students, please feel free to review the PostgreSQL Todo list for
inspiration: http://wiki.postgresql.org/wiki/Todo Of course ensure
you don't choose anything too ambitious or trivial.
Okay, here's a random idea (which could be infeasible and/or
undesirable). How about a way to internally schedule tasks using a
background worker process (introduced in 9.2) to wake on each tick and
run tasks?
CREATE EXTENSION pg_scheduler;
--
schedule_task(task_command, task_priority, task_start, repeat_interval);
SELECT schedule_task('REINDEX my_table', 1, '2012-03-20
00:10:00'::timestamp, '1 week'::interval);
SELECT list_tasks();
-[ RECORD 1 ]---+-----------------------
task_id | 1
task_command | REINDEX my_table
task_priority | 1
task_start | 2012-03-20 00:10:00-04
repeat_interval | 7 days
owner | postgres
SELECT delete_task(1);
Tasks would be run in sequence if they share the same scheduled time
ordered by priority descending, beyond which it would be
non-deterministic. Or perhaps additional worker processes to fire
commands in parallel if necessary.
Disclaimer: I haven't really thought this through.
--
Thom
--
http://www.postgresql.org/mailpref/pgsql-advocacy
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Dimitri Fontaine
2013-03-20 22:14:05 UTC
Permalink
Post by Atri Sharma
We can use a scheduling algorithm, and can define a pool of tasks as well as
a time constraint for the amount of time which can be used for running the
tasks.Then, a scheduling algorithm can pick tasks from the pool based on
priorities and the time duration of a task.I can see a dynamic programming
solution to this problem.
I think mcron already implements it all and is made to be embedded into
a larger program.

http://www.gnu.org/software/mcron/

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Magnus Hagander
2013-03-21 03:42:12 UTC
Permalink
Post by Dimitri Fontaine
Post by Atri Sharma
We can use a scheduling algorithm, and can define a pool of tasks as well as
a time constraint for the amount of time which can be used for running the
tasks.Then, a scheduling algorithm can pick tasks from the pool based on
priorities and the time duration of a task.I can see a dynamic programming
solution to this problem.
I think mcron already implements it all and is made to be embedded into
a larger program.
As long as your larger program is gpl. Not even lgpl on that one. I'd think
that's a killer for that idea...

/Magnus
Dimitri Fontaine
2013-03-21 08:29:29 UTC
Permalink
Post by Magnus Hagander
Post by Dimitri Fontaine
I think mcron already implements it all and is made to be embedded into
a larger program.
As long as your larger program is gpl. Not even lgpl on that one. I'd think
that's a killer for that idea...
Oh, are we now talking about including a scheduler in core or contrib?

My understanding was that the background worker infrastructure had been
made in parts so that we don't even have to talk about a scheduler specs
and implementation details on -hackers, where the usual answer is that
we already have a system's scheduler anyways.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Gilberto Castillo
2013-03-21 12:14:02 UTC
Permalink
Post by Dimitri Fontaine
Post by Atri Sharma
We can use a scheduling algorithm, and can define a pool of tasks as well as
a time constraint for the amount of time which can be used for running the
tasks.Then, a scheduling algorithm can pick tasks from the pool based on
priorities and the time duration of a task.I can see a dynamic programming
solution to this problem.
I think mcron already implements it all and is made to be embedded into
a larger program.
http://www.gnu.org/software/mcron/
I wonder if we can add the domain, something like:

SELECT * FROM DOMAINS mydom;

Returns

{"a", "b", "c", "d"}

Their content.

Saludos,
Gilberto Castillo
La Habana, Cuba
Thom Brown
2013-03-21 08:53:15 UTC
Permalink
Post by Thom Brown
Post by Thom Brown
Post by Josh Berkus
Folks,
Once again, Google is holding Summer of Code. We need to assess whether
we want to participate this year.
- Who wants to mentor for GSOC?
- Who can admin for GSOC? Thom?
- Please suggest project ideas for GSOC
- Students seeing this -- please speak up if you have projects you plan
to submit.
If anyone else has more projects ideas to suggest, please do share.
Students, please feel free to review the PostgreSQL Todo list for
inspiration: http://wiki.postgresql.org/wiki/Todo Of course ensure
you don't choose anything too ambitious or trivial.
Okay, here's a random idea (which could be infeasible and/or
undesirable). How about a way to internally schedule tasks using a
background worker process (introduced in 9.2) to wake on each tick and
run tasks?
CREATE EXTENSION pg_scheduler;
--
schedule_task(task_command, task_priority, task_start, repeat_interval);
SELECT schedule_task('REINDEX my_table', 1, '2012-03-20
00:10:00'::timestamp, '1 week'::interval);
SELECT list_tasks();
-[ RECORD 1 ]---+-----------------------
task_id | 1
task_command | REINDEX my_table
task_priority | 1
task_start | 2012-03-20 00:10:00-04
repeat_interval | 7 days
owner | postgres
SELECT delete_task(1);
Tasks would be run in sequence if they share the same scheduled time
ordered by priority descending, beyond which it would be
non-deterministic. Or perhaps additional worker processes to fire
commands in parallel if necessary.
Disclaimer: I haven't really thought this through.
Here's some evidence for my last statement: custom background worker
processes are actually being introduced as part of 9.3, not available
in 9.2. I don't think that changes things much though.

--
Thom
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Basil Bourque
2013-03-22 09:03:49 UTC
Permalink
Post by Thom Brown
Once again, Google is holding Summer of Code. …
If anyone else has more projects ideas to suggest, please do share.
JDBC driver perhaps…

Recently there's been some work started on an all-new code base for the Postgres JDBC driver. That might provide a nice opportunity for Summer of Code project(s).

--Basil Bourque
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
n***@gmail.com
2013-03-22 10:53:02 UTC
Permalink
Sent from my iPhone
Post by Basil Bourque
Post by Thom Brown
Once again, Google is holding Summer of Code. …
If anyone else has more projects ideas to suggest, please do share.
JDBC driver perhaps…
Recently there's been some work started on an all-new code base for the Postgres JDBC driver.
Unrelated to SOC I may be able to help with that particular project in my meager free time. Would you kindly send me a link to this? I didn't see anything on the old jdbc driver's site.

Nik Everett
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Basil Bourque
2013-04-09 20:23:38 UTC
Permalink
Regarding possible JDBC driver project…
Post by n***@gmail.com
Post by Basil Bourque
Post by Thom Brown
Once again, Google is holding Summer of Code. …
If anyone else has more projects ideas to suggest, please do share.
JDBC driver perhaps…
Recently there's been some work started on an all-new code base for the Postgres JDBC driver.
Unrelated to SOC I may be able to help with that particular project in my meager free time. Would you kindly send me a link to this? I didn't see anything on the old jdbc driver's site.
Nik Everett
See discussion in the Postgres JDBC ("pgsql-jdbc") mail list:
pgsql-***@postgresql.org

http://jdbc.postgresql.org/lists.html

https://lists.postgresql.org/mj/mj_wwwusr?user=&passw=&func=lists-long-full&extra=pgsql-jdbc

Yesterday (April 8, 2013) Kevin Wooten posted an progress report on the work being done for a new next-generation JDBC driver.

Code available on GitHub.
https://github.com/kdubb/pgjdbc-ng

--Basil Bourque
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Selena Deckelmann
2013-04-08 20:56:25 UTC
Permalink
Was PostgreSQL accepted?
Post by Josh Berkus
Folks,
Once again, Google is holding Summer of Code. We need to assess whether
we want to participate this year.
- Who wants to mentor for GSOC?
- Who can admin for GSOC? Thom?
- Please suggest project ideas for GSOC
- Students seeing this -- please speak up if you have projects you plan
to submit.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
http://www.postgresql.org/mailpref/pgsql-advocacy
--
http://chesnok.com
Devrim GÜNDÜZ
2013-04-08 21:01:26 UTC
Permalink
Hi,
Post by Selena Deckelmann
Was PostgreSQL accepted?
Looks like no, if I am not missing something:

http://www.google-melange.com/gsoc/program/accepted_orgs/google/gsoc2013

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
Selena Deckelmann
2013-04-08 21:06:06 UTC
Permalink
Post by Devrim GÜNDÜZ
Hi,
Post by Selena Deckelmann
Was PostgreSQL accepted?
http://www.google-melange.com/gsoc/program/accepted_orgs/google/gsoc2013
Orgs only show up in that list after the Admins accept the acceptance, if
that makes sense. ;)
--
http://chesnok.com
Thom Brown
2013-04-08 21:06:53 UTC
Permalink
Post by Devrim GÜNDÜZ
Hi,
Post by Selena Deckelmann
Was PostgreSQL accepted?
http://www.google-melange.com/gsoc/program/accepted_orgs/google/gsoc2013
That list isn't accurate as it only reflects those projects that have
been accepted and have also completed their profile information. We
haven't done that just yet.

--
Thom
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Thom Brown
2013-04-08 21:07:34 UTC
Permalink
Post by Thom Brown
Post by Devrim GÜNDÜZ
Hi,
Post by Selena Deckelmann
Was PostgreSQL accepted?
http://www.google-melange.com/gsoc/program/accepted_orgs/google/gsoc2013
That list isn't accurate as it only reflects those projects that have
been accepted and have also completed their profile information. We
haven't done that just yet.
And to be explicit, yes, PostgreSQL has been accepted.

--
Thom
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Thom Brown
2013-04-08 21:19:08 UTC
Permalink
Post by Thom Brown
Post by Thom Brown
Post by Devrim GÜNDÜZ
Hi,
Post by Selena Deckelmann
Was PostgreSQL accepted?
http://www.google-melange.com/gsoc/program/accepted_orgs/google/gsoc2013
That list isn't accurate as it only reflects those projects that have
been accepted and have also completed their profile information. We
haven't done that just yet.
And to be explicit, yes, PostgreSQL has been accepted.
I've just completed the profile, and we now appear on the list on that page.

--
Thom
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Jonathan S. Katz
2013-04-08 21:38:28 UTC
Permalink
Post by Thom Brown
Post by Thom Brown
Post by Thom Brown
Post by Devrim GÜNDÜZ
Hi,
Post by Selena Deckelmann
Was PostgreSQL accepted?
http://www.google-melange.com/gsoc/program/accepted_orgs/google/gsoc2013
That list isn't accurate as it only reflects those projects that have
been accepted and have also completed their profile information. We
haven't done that just yet.
And to be explicit, yes, PostgreSQL has been accepted.
I've just completed the profile, and we now appear on the list on that page.
Looks good! I would suggested adding "postgres" or "postgresql" as one of the tags as I tried searching that way and the actual "PostgresSQL Project" did not turn up.

Jonathan
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Thom Brown
2013-04-09 08:30:28 UTC
Permalink
Post by Jonathan S. Katz
Post by Thom Brown
Post by Thom Brown
Post by Thom Brown
Post by Devrim GÜNDÜZ
Hi,
Post by Selena Deckelmann
Was PostgreSQL accepted?
http://www.google-melange.com/gsoc/program/accepted_orgs/google/gsoc2013
That list isn't accurate as it only reflects those projects that have
been accepted and have also completed their profile information. We
haven't done that just yet.
And to be explicit, yes, PostgreSQL has been accepted.
I've just completed the profile, and we now appear on the list on that page.
Looks good! I would suggested adding "postgres" or "postgresql" as one of the tags as I tried searching that way and the actual "PostgresSQL Project" did not turn up.
Done. Thanks.

--
Thom
--
Sent via pgsql-advocacy mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
Loading...