Message-ID: <4E498536.9080109@darrenduncan.net>
Date: Mon, 15 Aug 2011 13:44:38 -0700
From: Darren Duncan <darren@darrenduncan.net>
User-Agent: Thunderbird 2.0.0.24 (Macintosh/20100228)
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Re: Using Postgresql as application server
References: 
 <CAN2Y=uPjF14F5A9JXj02_vaPw4TMR0WGQid_w80xt4sC8o4qGg@mail.gmail.com>
In-Reply-To: 
 <CAN2Y=uPjF14F5A9JXj02_vaPw4TMR0WGQid_w80xt4sC8o4qGg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

c k wrote:
> Dear Postgres users,
> from last few months I am reading and searching for can postgresql used 
> as application server? As postgresql supports many languages like 
> pl/perl, pl/python etc, supports dblink like functions to connect to 
> other postgresql servers and now features are in development to use 
> external data. Postgresql works well on many operating systems and has a 
> stable and good quality code. As many users are using plpython or plperl 
> to work on many types of data and to implement logic that can be useful 
> in web application management.
> So i am thinking if I can use postgresql as web application server.
> Few points that supports this opinion:
> 1. multiple languages support for stored procs and triggers.
> 2. can connect to other postgresql servers or databases
> 3. it is easy to manage stored procs or triggers than managing web 
> application in other servers.
> 4. data and logic/processing can be separated. One postgresql can be 
> used as application server and another as database.
> 5. stable, mature and open codebase.
> 
> I request to users and developers give your suggestions and opinions.
> Waiting for your replies.
> 
> Thanks and regards,
> 
> Chaitanya Kulkarni

I believe that it is ideal for Postgres to be computationally complete in that 
one *could* use it to implement a complete application.  That isn't to say one 
should do this as a matter of course, good to use appropriate tools for a job, 
but that it should at least be possible if one wanted to. -- Darren Duncan