Re: [GENERAL] [ADMIN] Using Postgresql as application server
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [ADMIN] Using Postgresql as application server
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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [ADMIN] Using Postgresql as application server
Scott Marlowe пишет: On Sat, Aug 13, 2011 at 9:57 AM, 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, Besides the previously mentioned nginx module there's apache's mod libpq http://asmith.id.au/mod_libpq.html But I'd stick to a language to wrap stuff in like php etc. BTW, string concatenation in postgresql (plpgsql) is FASTER than in PHP -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [ADMIN] Using Postgresql as application server
Scott Marlowe пишет: On Mon, Aug 15, 2011 at 11:33 AM, s...@bestmx.ru wrote: Scott Marlowe пишет: On Sat, Aug 13, 2011 at 9:57 AM, c kwrote: 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, Besides the previously mentioned nginx module there's apache's mod libpq http://asmith.id.au/mod_libpq.html But I'd stick to a language to wrap stuff in like php etc. BTW, string concatenation in postgresql (plpgsql) is FASTER than in PHP But I can throw 1,000 cores at a large load with php. Much harder to do with plpgsql. and? all of them would inevitably connect the same postgresql the solution is outside the scope. ...a web-server page cache is one element of a solution -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [ADMIN] Using Postgresql as application server
Evan Rempel пишет: Security is near impossible to manage as well. Again, almost everything needs to run as the same user. throw your nameless DMS away, or fire the architect. Scott Marlowe ÐÉÛÅÔ: On Mon, Aug 15, 2011 at 11:33 AM, s...@bestmx.ru šwrote: Scott Marlowe ÐÉÛÅÔ: On Sat, Aug 13, 2011 at 9:57 AM, 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, Besides the previously mentioned nginx module there's apache's mod libpq http://asmith.id.au/mod_libpq.html But I'd stick to a language to wrap stuff in like php etc. BTW, string concatenation in postgresql (plpgsql) is FASTER than in PHP But I can throw 1,000 cores at a large load with php. šMuch harder to do with plpgsql. and? all of them would inevitably connect the same postgresql And they'd each need postgresql to do a concat? I'd hope nobody was dumb enough to program the app layer to do something like that. PG might make a decent app server, but there's no way you could scale it to millions of users like you could a farm of app servers. 2011/8/16 s...@bestmx.ru : -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Using Postgresql as application server
Merlin Moncure пишет: On Thu, Aug 18, 2011 at 5:48 AM, Dimitri Fontaine wrote: c k writes: Many users are using it and found it stable and scalable. Important is that web server is external to the database and a mod_pgsql like mod_plsql is used to connect web server to database. Each page is considered as a stored procedure in the oracle database. I am not thinking of implementing as it is It's been around for a long time already: http://asmith.id.au/mod_libpq.html mod_libpq looks like it hasn't been updated in quite a while (apache 1.3 only) -- I think a node.js http server is superior in just about every way for this case. I 100% agree with the comments on the page though. merlin i still recommend nginx -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Using Postgresql as application server
Dmitriy Igrishin пишет: 2011/8/18 s...@bestmx.ru <mailto:s...@bestmx.ru> <mailto:s...@bestmx.ru>> Merlin Moncure пишет: On Thu, Aug 18, 2011 at 5:48 AM, Dimitri Fontaine mailto:dimi...@2ndquadrant.fr>> wrote: c kmailto:shreeseva.learn...@gmail.com>> writes: Many users are using it and found it stable and scalable. Important is that web server is external to the database and a mod_pgsql like mod_plsql is used to connect web server to database. Each page is considered as a stored procedure in the oracle database. I am not thinking of implementing as it is It's been around for a long time already: http://asmith.id.au/mod_libpq.html mod_libpq looks like it hasn't been updated in quite a while (apache 1.3 only) -- I think a node.js http server is superior in just about every way for this case. I 100% agree with the comments on the page though. merlin i still recommend nginx I recommend Wt: http://www.webtoolkit.eu/ :-) it looks like feces "and uses well-tested patterns of desktop GUI development" -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Using Postgresql as application server
Dmitriy Igrishin пишет:
2011/8/18 s...@bestmx.ru <mailto:s...@bestmx.ru> <mailto:s...@bestmx.ru>>
Dmitriy Igrishin пишет:
2011/8/18 s...@bestmx.ru <mailto:s...@bestmx.ru>
<mailto:s...@bestmx.ru <mailto:s...@bestmx.ru>> mailto:s...@bestmx.ru> <mailto:s...@bestmx.ru
<mailto:s...@bestmx.ru>>>
Merlin Moncure пишет:
On Thu, Aug 18, 2011 at 5:48 AM, Dimitri Fontaine
mailto:dimi...@2ndquadrant.fr>
<mailto:dimi...@2ndquadrant.fr
<mailto:dimi...@2ndquadrant.fr>>> wrote:
c kmailto:shreeseva.learn...@gmail.com>
<mailto:shreeseva.learn...@gmail.com
<mailto:shreeseva.learn...@gmail.com>>> writes:
Many users are using it and found it stable and
scalable. Important is that
web server is external to the database and a
mod_pgsql
like mod_plsql is
used to connect web server to database. Each
page is
considered as a stored
procedure in the oracle database. I am not
thinking of
implementing as it is
It's been around for a long time already:
http://asmith.id.au/mod_libpq.html
mod_libpq looks like it hasn't been updated in quite a
while
(apache
1.3 only) -- I think a node.js http server is superior
in just
about
every way for this case. I 100% agree with the comments on
the page
though.
merlin
i still recommend nginx
I recommend Wt:
http://www.webtoolkit.eu/
:-)
it looks like feces
"and uses well-tested patterns of desktop GUI development"
Oh oh. So unprofessional comment!
Well, have a nice coding a Web 2.0 application with nginx + PostgreSQL :-)
--
// Dmitriy.
who said "web 2.0" ?
i've never used religious idioms in a technical talk.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
