Using Postgresql as application server

From: c k <shreeseva(dot)learning(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Using Postgresql as application server
Date: 2011-08-13 15:57:14
Message-ID: CAN2Y=uPjF14F5A9JXj02_vaPw4TMR0WGQid_w80xt4sC8o4qGg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Johnston 2011-08-13 17:12:12 Re: [GENERAL] Using Postgresql as application server
Previous Message c k 2011-08-13 15:35:08 Re: postgresql server crash on windows 7 when using plpython

Browse pgsql-general by date

  From Date Subject
Next Message George MacKerron 2011-08-13 16:02:29 Re: Functions returning setof record -- can I use a table type as my return type hint?
Previous Message c k 2011-08-13 15:35:08 Re: postgresql server crash on windows 7 when using plpython