Re: PL language selection

From: Richard Huxton <dev(at)archonet(dot)com>
To: Nicolay A Vasiliev <nvasiliev(at)whiteriversoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PL language selection
Date: 2005-11-10 10:48:14
Message-ID: 4373256E.9080902@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 :-)

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

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/

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2005-11-10 11:07:30 Re: Windows installer fails for 8.1
Previous Message Nicolay A Vasiliev 2005-11-10 10:31:15 Re: Dynamic web sites with PostgreSQL