Envelope-to: pgsql-admin@postgresql.org
Message-ID: <4E46B33B.7090801@bestmx.ru>
Date: Sat, 13 Aug 2011 21:24:11 +0400
From: "sad@bestmx.ru" <sad@bestmx.ru>
User-Agent: Mozilla/5.0 (Windows NT 5.1;
	rv:5.0) Gecko/20110706 Firefox/5.0 SeaMonkey/2.2
MIME-Version: 1.0
To: pgsql-admin@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:

> from last few months I am reading and searching for can postgresql
> used as application server?
> So i am thinking if I can use postgresql as web application server.
>
> I request to users and developers give your suggestions and opinions.
> Waiting for your replies.

Yes! Yes And Yes, my friend!
You should!

i am using postgresql exactly as application server.
(stored procedures in PLpgsql)
at http://platzcart.com i managed to minimize server side scripting:
Stored procedures run entire "business logic" + PHP envelop results into 
HTML code.

and in the next project (yet under construction)
i managed to ELIMINATE server side scripting at all
(except captcha server, which is standalone (written in perl))
PLpgsql "business logic" again + client side JS is building presentation.

most important point to support you is
*This is the originally intended usage of a DBMS*

All the troubles, all the NoSQL whining caused by unnecessary middleware.

P.S.
i have held a report to NLUUG Spring Conference 2011
about platzcart.com implementation
it is located at http://platzcart.com/lib/platzcart.pdf
it clearly describes advantages of using postgresql as an application 
server.
and i am sure it explains the good practice (maybe the best one)

P.P.S.
now i am using nginx_http_postgres_module