Re: PL language selection - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: PL language selection
Date
Msg-id 20051110102440.GA19686@svana.org
Whole thread Raw
In response to PL language selection  (Nicolay A Vasiliev <nvasiliev@whiteriversoft.com>)
Responses Re: PL language selection  (Nicolay A Vasiliev <nvasiliev@whiteriversoft.com>)
List pgsql-general
On Thu, Nov 10, 2005 at 12:16:12PM +0300, Nicolay A Vasiliev wrote:
> 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?
>
> Suggest me please your way of PL language selection.

Well, it kind of depends on what you want to do. Different languages
are good for different things. If you want pattern matching you might
want pl/perl. For simple SQL stuff, pl/sql has the advantage that it
can be inlined. pl/pgsql looks similar to oracles offering, some people
like that.

The languages are all fast enough that you should really consider
maintainability, readabilty and coding experience before speed...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Best way to use indexes for partial match at
Next
From: Richard Huxton
Date:
Subject: Re: Dynamic web sites with PostgreSQL