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