Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 6F5CEB5DBEE for ; Sun, 14 Aug 2011 05:09:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 26005-05 for ; Sun, 14 Aug 2011 08:09:35 +0000 (UTC) X-Greylist: delayed 00:06:40.430462 by SQLgrey-1.7.6 Received: from bunspace.com (mail.kreative-hands.com [64.142.76.151]) by mail.postgresql.org (Postfix) with SMTP id A2145B5DBE5 for ; Sun, 14 Aug 2011 05:09:34 -0300 (ADT) Received: (qmail 18455 invoked by uid 453); 14 Aug 2011 08:02:52 -0000 X-Virus-Checked: Checked by ClamAV on bunspace.com Received: from tiburon.bunspace.com (HELO tiburon.localnet) (192.168.1.4) by bunspace.com (qpsmtpd/0.83) with ESMTP; Sun, 14 Aug 2011 01:02:52 -0700 From: Uwe Schroeder Organization: OSS4U, LLC To: pgsql-admin@postgresql.org Subject: Re: Using Postgresql as application server Date: Sun, 14 Aug 2011 01:02:51 -0700 User-Agent: KMail/1.13.5 (Linux/2.6.35-25-paeoss; KDE/4.5.1; i686; ; ) References: <4E46C725.1060306@bestmx.ru> In-Reply-To: <4E46C725.1060306@bestmx.ru> MIME-Version: 1.0 Content-Type: Text/Plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Message-Id: <201108140102.51745.uwe@oss4u.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201108/128 X-Sequence-Number: 38115 > > can u please give me it's link. > > I found ngx_postgres module. > > > >> there is nginx_htttp_postgresql_module > >> exactly to connect webserver directly to postgresql > >> and to OUTPUT query result to a browser. > > http://wiki.nginx.org/3rdPartyModules > http://labs.frickle.com/nginx_ngx_postgres/ Which is still a webserver on top of postgresql. Sure, you're coding more in postgresql, but by the end of the day, a database is a database and a webserver is a webserver. Sure, you can use a kitchen knife to chop firewood, but wouldn't a tool made for the job be better at it? IMHO you trade flexibility and security with "simplification" Personally I'd never ever hook my database directly to the internet - for me that's like writing your PIN on your banking card and leave it next to the ATM :-)