Re: [GENERAL] Using Postgresql as application server

Scott Marlowe <scott.marlowe@gmail.com>

From: Scott Marlowe <scott.marlowe@gmail.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Evan Rempel <erempel@uvic.ca>, "sad@bestmx.ru" <sad@bestmx.ru>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>, pgsql-admin <pgsql-admin@postgresql.org>
Date: 2011-08-16T18:32:07Z
Lists: pgsql-general
On Tue, Aug 16, 2011 at 12:25 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
> one point that is getting lost in all this that if you are using a
> database for an application server, this does not mean it's the same
> database as your main database or even on the same machine -- you can
> still keep traditional separation of roles and use something like
> dblink to transfer data.  regarding the use of postgres functions for

I'm thining pl/proxy would be pretty amazing here.  I still prefer
using another layer in another language for an app server, but now
that you've got me thinking a bit more out of the box, pl/proxy would
increase your ability to scale quite a lot.