Re: PL language selection - Mailing list pgsql-general

From Nicolay A Vasiliev
Subject Re: PL language selection
Date
Msg-id dkvcem$e27$1@sea.gmane.org
Whole thread Raw
In response to Re: PL language selection  (Richard Huxton <dev@archonet.com>)
Responses Re: PL language selection  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
Richard Huxton wrote:
> Nicolay A Vasiliev wrote:
>
>> Hello!
>>
>> I am going to be inspired into PostgreSQL community. So I need your
>> advices, buddies.
>
>
> Crikey! I must be more persuasive than I thought :-)

Wow :)

>
>> There are a number of different PL-languages. How do you select these
>> languages? I think PL/SQL is more fast or am I wrong?
>
>
> Hmm - it varies. You are guaranteed to always have plpgsql available
> wherever PG is installed. It's not very good at dynamic stuff

What do you mean?

> - with Perl/TCL etc you can write one trigger function and have it adapt itself
> to different tables quite easily.

Perl is our working horse :), so this sounds good.

>
> The others have their strengths and weaknesses depending on the language
> itself. If you're prepared to compile from source there is a pl-php
> which might interest you.
>
> It's from the nice people at Command Prompt:
>   http://www.commandprompt.com/community/plphp/

I've heard about this, but Perl and Python are more preferred for us.

Regards,
Nicolay

pgsql-general by date:

Previous
From: Nicolay A Vasiliev
Date:
Subject: Re: PL language selection
Next
From: "A. Kretschmer"
Date:
Subject: Re: Time trigger