Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 477EBB5D803 for ; Tue, 16 Aug 2011 10:24:07 -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 88477-01; Tue, 16 Aug 2011 13:24:00 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from a2s36.a2hosting.com (a2s36.a2hosting.com [216.119.134.130]) by mail.postgresql.org (Postfix) with ESMTP id 059F4B5DBEE; Tue, 16 Aug 2011 10:23:57 -0300 (ADT) Received: from adsl-98-86-74-54.tys.bellsouth.net ([98.86.74.54] helo=[10.0.0.18]) by a2s36.a2hosting.com with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.69) (envelope-from ) id 1QtJcY-001vRM-Mz; Tue, 16 Aug 2011 09:23:54 -0400 Subject: Re: [GENERAL] Using Postgresql as application server Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii From: John DeSoi In-Reply-To: <4E46C5FE.8080203@bestmx.ru> Date: Tue, 16 Aug 2011 09:23:53 -0400 Cc: c k , pgsql-admin@postgresql.org, pgsql-general@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <2EEF6F82-BF46-433E-85A7-E446E9F89BE0@pgedit.com> References: <4E46B33B.7090801@bestmx.ru> <4E46C5FE.8080203@bestmx.ru> To: sad@bestmx.ru X-Mailer: Apple Mail (2.1084) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s36.a2hosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - pgedit.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, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201108/142 X-Sequence-Number: 38129 On Aug 13, 2011, at 2:44 PM, sad@bestmx.ru wrote: > c k wrote: >> Yes, I know that I can not create a simple web application using only = postgresql because we need a web server to server the html content. > u r wrong. > u CAN! >=20 > there is nginx_htttp_postgresql_module > exactly to connect webserver directly to postgresql > and to OUTPUT query result to a browser. >=20 You could also use something like node.js which allows you to connect = Javascript directly to Postgres using the front end/back end protocol.=20= With something like this, you could talk directly to Postgres from the = browser: http://ajaxian.com/archives/tcpsocket-sockets-in-the-browser http://www.postgresql.org/docs/9.0/interactive/protocol.html I'm not saying this is the right approach, but if that is what you are = really after... John DeSoi, Ph.D.