Re: Using Postgresql as application server

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: "sad(at)bestmx(dot)ru" <sad(at)bestmx(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Using Postgresql as application server
Date: 2011-08-16 15:44:14
Message-ID: CAOR=d=2nsPfUORdoJA9nG8CaH84E3of8DeoAw+S07hgbe9KGTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

2011/8/16 sad(at)bestmx(dot)ru <sad(at)bestmx(dot)ru>:
> Scott Marlowe пишет:
>>
>> On Mon, Aug 15, 2011 at 11:33 AM, sad(at)bestmx(dot)ru<sad(at)bestmx(dot)ru>  wrote:
>>>
>>> Scott Marlowe пишет:
>>>>
>>>> On Sat, Aug 13, 2011 at 9:57 AM, c k<shreeseva(dot)learning(at)gmail(dot)com>
>>>>  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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Evan Rempel 2011-08-16 16:27:47 Re: Using Postgresql as application server
Previous Message John DeSoi 2011-08-16 13:23:53 Re: [GENERAL] Using Postgresql as application server

Browse pgsql-general by date

  From Date Subject
Next Message Evan Rempel 2011-08-16 16:27:47 Re: Using Postgresql as application server
Previous Message John R Pierce 2011-08-16 15:14:09 Re: How to give \COPY inside a function