Re: [GENERAL] Using Postgresql as application server

From: John DeSoi <desoi(at)pgedit(dot)com>
To: sad(at)bestmx(dot)ru
Cc: c k <shreeseva(dot)learning(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Using Postgresql as application server
Date: 2011-08-16 13:23:53
Message-ID: 2EEF6F82-BF46-433E-85A7-E446E9F89BE0@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general


On Aug 13, 2011, at 2:44 PM, sad(at)bestmx(dot)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!
>
> there is nginx_htttp_postgresql_module
> exactly to connect webserver directly to postgresql
> and to OUTPUT query result to a browser.
>

You could also use something like node.js which allows you to connect Javascript directly to Postgres using the front end/back end protocol.

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2011-08-16 15:44:14 Re: Using Postgresql as application server
Previous Message Greg Spiegelberg 2011-08-16 12:04:57 Re: lo_import/lo_export in other table

Browse pgsql-general by date

  From Date Subject
Next Message Harald Fuchs 2011-08-16 13:33:24 Re: join between a table and function.
Previous Message Simon Riggs 2011-08-16 13:16:54 Re: Check server mode (standby / master)