Re: Using Postgresql as application server

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, pl/python etc, supports dblink like functions to connect to
> other postgresql servers and now features are in development to use
> external data. Postgresql works well on many operating systems and has a
> stable and good quality code. As many users are using plpython or plperl
> to work on many types of data and to implement logic that can be useful
> in web application management.
> So i am thinking if I can use postgresql as web application server.
> Few points that supports this opinion:
> 1. multiple languages support for stored procs and triggers.
> 2. can connect to other postgresql servers or databases
> 3. it is easy to manage stored procs or triggers than managing web
> application in other servers.
> 4. data and logic/processing can be separated. One postgresql can be
> used as application server and another as database.
> 5. stable, mature and open codebase.
>
> I request to users and developers give your suggestions and opinions.
> Waiting for your replies.
>
> Thanks and regards,
>
> Chaitanya Kulkarni

I believe that it is ideal for Postgres to be computationally complete in that
one *could* use it to implement a complete application.  That isn't to say one
should do this as a matter of course, good to use appropriate tools for a job,
but that it should at least be possible if one wanted to. -- Darren Duncan