GSoC project suggestion: PIVOT ?
Hi all
The thought just occurred to me that a PIVOT feature might be a
respectable GSoC project.
tablefunc/crosstab works, but it's very clumsy to use, and difficult to
consume the data from. Going by Stack Overflow activity, pivot/crosstab
is second only to upsert when it comes to things that users find hard to
do in Pg.
I haven't investigated what'd be involved in implementing any integrated
form of pivoting, and I'm aware that there are some serious challenges
when it comes to generating a TupleDesc for pivot output. I thought I'd
raise it in case anyone has looked into this and has any comments on
whether this'd be a viable GSoC for an interested student.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Sun, Mar 30, 2014 at 11:30 PM, Craig Ringer <craig@2ndquadrant.com>
wrote:
Hi all
The thought just occurred to me that a PIVOT feature might be a
respectable GSoC project.tablefunc/crosstab works, but it's very clumsy to use, and difficult to
consume the data from. Going by Stack Overflow activity, pivot/crosstab
is second only to upsert when it comes to things that users find hard to
do in Pg.I haven't investigated what'd be involved in implementing any integrated
form of pivoting, and I'm aware that there are some serious challenges
when it comes to generating a TupleDesc for pivot output. I thought I'd
raise it in case anyone has looked into this and has any comments on
whether this'd be a viable GSoC for an interested student.
It's a nice idea, but the deadline to students send a proposal was 21th
April.
Regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Show quoted text
Timbira: http://www.timbira.com.br
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
Twitter: http://twitter.com/fabriziomello
On Mon, Mar 31, 2014 at 1:36 PM, Fabrízio de Royes Mello
<fabriziomello@gmail.com> wrote:
It's a nice idea, but the deadline to students send a proposal was 21th
April.
21st of March. All the details are here:
http://www.postgresql.org/developer/summerofcode/
--
Michael
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 03/31/2014 12:49 PM, Michael Paquier wrote:
On Mon, Mar 31, 2014 at 1:36 PM, Fabr�zio de Royes Mello
<fabriziomello@gmail.com> wrote:It's a nice idea, but the deadline to students send a proposal was 21th
April.21st of March. All the details are here:
http://www.postgresql.org/developer/summerofcode/
Ah, thanks.
There's always next year. Still curious about whether anyone's
investigated it / tried it out.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Em segunda-feira, 31 de março de 2014, Michael Paquier <
michael.paquier@gmail.com> escreveu:
On Mon, Mar 31, 2014 at 1:36 PM, Fabrízio de Royes Mello
<fabriziomello@gmail.com <javascript:;>> wrote:It's a nice idea, but the deadline to students send a proposal was 21th
April.21st of March. All the details are here:
http://www.postgresql.org/developer/summerofcode/
Sorry by my mistake. I'm with april in my mind.
Fabrízio.
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Show quoted text
Timbira: http://www.timbira.com.br
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
Twitter: http://twitter.com/fabriziomello
On Mon, Mar 31, 2014 at 1:14 AM, Craig Ringer <craig@2ndquadrant.com> wrote:
On 03/31/2014 12:49 PM, Michael Paquier wrote:
On Mon, Mar 31, 2014 at 1:36 PM, Fabrízio de Royes Mello
<fabriziomello@gmail.com> wrote:It's a nice idea, but the deadline to students send a proposal was 21th
April.21st of March. All the details are here:
http://www.postgresql.org/developer/summerofcode/Ah, thanks.
There's always next year. Still curious about whether anyone's
investigated it / tried it out.
I bet this is more complex than a typical GSoC student can handle.
Unless it's Alexander Korotkov. :-)
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers