Re: [ADMIN] Using Postgresql as application server - Mailing list pgsql-general

From Scott Marlowe
Subject Re: [ADMIN] Using Postgresql as application server
Date
Msg-id CAOR=d=2nsPfUORdoJA9nG8CaH84E3of8DeoAw+S07hgbe9KGTg@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] Using Postgresql as application server  ("sad@bestmx.ru" <sad@bestmx.ru>)
Responses Re: [ADMIN] Using Postgresql as application server
List pgsql-general
2011/8/16 sad@bestmx.ru <sad@bestmx.ru>:
> Scott Marlowe пишет:
>>
>> On Mon, Aug 15, 2011 at 11:33 AM, sad@bestmx.ru<sad@bestmx.ru>  wrote:
>>>
>>> Scott Marlowe пишет:
>>>>
>>>> On Sat, Aug 13, 2011 at 9:57 AM, c k<shreeseva.learning@gmail.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.

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: How to give \COPY inside a function
Next
From: Evan Rempel
Date:
Subject: Re: [ADMIN] Using Postgresql as application server