PL contribution guidelines?

Started by mlg3over 22 years ago12 messages
#1mlg3
mlg3@mail15.com

I want to make a contribution.
It is a new (to pgsql) procedural language.
Currently it already works (but debugging output
is not disabled yet).

I've got some questions and considerations, please, correct me
if I am wrong:

I understand that pgsql uses autoconf but not other autotools.
The best location for such contribution is in
src/pl/pl<lang-name>

Now, how do I include my PL into the build list?
What files must I provide? (preferrably, by borrowing
them from another PL, e.g. PLPERL or TCL])

Currently, I compile the C source by hands:
cc -fpic -I /pgsql/src/include -c plpfe.c
cc -shared -Wl,--rpath -Wl,/usr/local/lib -Wl,--rpath -Wl,
/usr/local/lib/pfe -o plpfe.so plpfe.o -lpfe

One part of the implementation resides in the pfe build tree,
but it needs postgres.h and fmgr.h

Currently I use
#include "/pgsql/src/include/postgres.h"
#include "/pgsql/src/include/fmgr.h"
(/pgsql is a symlink to the PostgreSQL*.*.* directory)
but IMO there should be a better way.

Should I publish the project as plpfe.sf.net, or there's
a better location?

I also composed PLSAMPLE (the same implementation
components, but empty). IMO, it (PLSAMPLE) also should be
there in the PSQL distribution.

regards, mlg

#2Peter Eisentraut
peter_e@gmx.net
In reply to: mlg3 (#1)
Re: PL contribution guidelines?

mlg3 writes:

I understand that pgsql uses autoconf but not other autotools.
The best location for such contribution is in
src/pl/pl<lang-name>

Now, how do I include my PL into the build list?
What files must I provide? (preferrably, by borrowing
them from another PL, e.g. PLPERL or TCL])

There is currently some disagreement about whether every now procedural
language implementation should be included in the core distribution. If
you choose to distribute your package separately, you can take a look at
http://developer.postgresql.org/~petere/plsh.html as an example for how to
package it.

I also composed PLSAMPLE (the same implementation
components, but empty). IMO, it (PLSAMPLE) also should be
there in the PSQL distribution.

I think there is enough documentation about this already. Creating a PL
handler is not a common task. But if you have concrete points that you
would like to have mentioned somewhere, please tell us about them.

--
Peter Eisentraut peter_e@gmx.net

#3Robert Treat
xzilla@users.sourceforge.net
In reply to: Peter Eisentraut (#2)
Re: PL contribution guidelines?

On Thu, 2003-09-25 at 07:12, Peter Eisentraut wrote:

mlg3 writes:

Now, how do I include my PL into the build list?
What files must I provide? (preferrably, by borrowing
them from another PL, e.g. PLPERL or TCL])

There is currently some disagreement about whether every now procedural
language implementation should be included in the core distribution. If
you choose to distribute your package separately, you can take a look at
http://developer.postgresql.org/~petere/plsh.html as an example for how to
package it.

Is there? The last new procedural language that I recall was Joe's plr,
which IIRC was moved to gborg due to license issues with the R
libraries. <troll>darn gpl license..if only it was commercially dual
licensed</troll>

otherwise my understanding is that all of the other pl authors that
distribute outside of core do so either by their own choosing or because
the proposed implementation is not quite "ready for prime time" enough
to be included.

oh.. and i'm not forgetting plphp, but it has both licensing issues and
isn't ready for prime time.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

#4scott.marlowe
scott.marlowe@ihs.com
In reply to: Robert Treat (#3)
Re: PL contribution guidelines?

On 25 Sep 2003, Robert Treat wrote:

oh.. and i'm not forgetting plphp, but it has both licensing issues and
isn't ready for prime time.

I thought there weren't any license issues, except mayhaps with the name.

http://www.php.net/license/3_0.txt

#5Bruce Momjian
pgman@candle.pha.pa.us
In reply to: scott.marlowe (#4)
Re: PL contribution guidelines?

scott.marlowe wrote:

On 25 Sep 2003, Robert Treat wrote:

oh.. and i'm not forgetting plphp, but it has both licensing issues and
isn't ready for prime time.

I thought there weren't any license issues, except mayhaps with the name.

http://www.php.net/license/3_0.txt

That is what I thought too. Originally PlPHP was stated as being
released as GPL (which the author thought was used by PHP), but later
corrected to be the BSD license.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
#6Joshua D. Drake
jd@commandprompt.com
In reply to: Bruce Momjian (#5)
Re: PL contribution guidelines?

Hello,

Yes plPHP is under the BSD style PHP license. We are going to dual
license on next release which is REAL soon
now.

Sincerley,

Joshua Drake

Bruce Momjian wrote:

Show quoted text

scott.marlowe wrote:

On 25 Sep 2003, Robert Treat wrote:

oh.. and i'm not forgetting plphp, but it has both licensing issues and
isn't ready for prime time.

I thought there weren't any license issues, except mayhaps with the name.

http://www.php.net/license/3_0.txt

That is what I thought too. Originally PlPHP was stated as being
released as GPL (which the author thought was used by PHP), but later
corrected to be the BSD license.

#7Robert Treat
xzilla@users.sourceforge.net
In reply to: Bruce Momjian (#5)
Re: PL contribution guidelines?

On Thu, 2003-09-25 at 13:26, Bruce Momjian wrote:

scott.marlowe wrote:

On 25 Sep 2003, Robert Treat wrote:

oh.. and i'm not forgetting plphp, but it has both licensing issues and
isn't ready for prime time.

I thought there weren't any license issues, except mayhaps with the name.

http://www.php.net/license/3_0.txt

That is what I thought too. Originally PlPHP was stated as being
released as GPL (which the author thought was used by PHP), but later
corrected to be the BSD license.

The naming issue was the one that had stuck in my head.

(Noting that it isn't BSD licensed, it's PHP licensed, which might be a
problem for some, but seems fairly BSD compatible).

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

#8mlg7
mlg7@yandex.ru
In reply to: Robert Treat (#7)
Re: PL contribution guidelines?

Peter Eisentraut wrote:

mlg3 writes:

I understand that pgsql uses autoconf but not other autotools.
The best location for such contribution is in
src/pl/pl<lang-name>

Now, how do I include my PL into the build list?
What files must I provide? (preferrably, by borrowing
them from another PL, e.g. PLPERL or TCL])

There is currently some disagreement about whether every now procedural
language implementation should be included in the core distribution. If
you choose to distribute your package separately, you can take a look at
http://developer.postgresql.org/~petere/plsh.html as an example for how to
package it.

1)
Is there a centralized list of pgsql PL's ?

2)
At that URL, I see:
pgplsh-1.0-7.3.tar.gz 17-Dec-2002 19:17 244k GZIP compressed docume>
pgplsh-20010821.tar.gz 23-Sep-2002 18:08 99k GZIP compressed docume>
pgplsh-20010914.tar.gz 23-Sep-2002 18:08 101k GZIP compressed docume>
pgplsh-20011005.tar.gz 23-Sep-2002 18:08 102k GZIP compressed docume>
which version should I prefer? What is the difference between them?

#9Peter Eisentraut
peter_e@gmx.net
In reply to: mlg7 (#8)
Re: PL contribution guidelines?

mlg7 writes:

Is there a centralized list of pgsql PL's ?

I'm not aware of one.

At that URL, I see:
pgplsh-1.0-7.3.tar.gz 17-Dec-2002 19:17 244k GZIP compressed docume>
pgplsh-20010821.tar.gz 23-Sep-2002 18:08 99k GZIP compressed docume>
pgplsh-20010914.tar.gz 23-Sep-2002 18:08 101k GZIP compressed docume>
pgplsh-20011005.tar.gz 23-Sep-2002 18:08 102k GZIP compressed docume>
which version should I prefer? What is the difference between them?

They are different historical versions. Use the newest one.

--
Peter Eisentraut peter_e@gmx.net

#10Shridhar Daithankar
shridhar_daithankar@persistent.co.in
In reply to: Peter Eisentraut (#9)
Re: PL contribution guidelines?

On Saturday 27 September 2003 19:46, Peter Eisentraut wrote:

mlg7 writes:

Is there a centralized list of pgsql PL's ?

I'm not aware of one.

http://techdocs.postgresql.org/guides/PLLanguages

Josh posted it on advocacy few days back.

Shridhar

#11mlg7
mlg7@yandex.ru
In reply to: Shridhar Daithankar (#10)
Re: PL contribution guidelines?

On Saturday 27 September 2003 19:46, Peter Eisentraut wrote:

mlg7 writes:

Is there a centralized list of pgsql PL's ?

I'm not aware of one.

http://techdocs.postgresql.org/guides/PLLanguages

Josh posted it on advocacy few days back.

Shridhar

That does not work:

: Proxy Error
: The proxy server received an invalid response from an upstream server.
:
: The proxy server could not handle the request GET /guides/PLLanguages.
:
: Reason: Could not connect to remote machine: Operation timed out

#12Shridhar Daithankar
shridhar_daithankar@persistent.co.in
In reply to: mlg7 (#11)
Re: PL contribution guidelines?

On Sunday 28 September 2003 11:53, mlg7 wrote:

On Saturday 27 September 2003 19:46, Peter Eisentraut wrote:

mlg7 writes:

Is there a centralized list of pgsql PL's ?

I'm not aware of one.

http://techdocs.postgresql.org/guides/PLLanguages

Josh posted it on advocacy few days back.

Shridhar

That does not work:
: Proxy Error
: The proxy server received an invalid response from an upstream server.
:
: The proxy server could not handle the request GET /guides/PLLanguages.
:
: Reason: Could not connect to remote machine: Operation timed out

Try google cache

http://www.google.co.in/search?q=cache:iDjd8nA-l2IJ:techdocs.postgresql.org/guides/PLLanguages+list+of+postgresql+procedural+languages&amp;hl=mr&amp;ie=UTF-8

The google search term I used was "list of postgresql procedural languages".
Look for first techdocs link.

Yesterday when I got same error, I thought there was problem with
international link again...:-) Hard to tell where exactly problem is..

Shridhar