Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 9885FB5DBF7 for ; Sat, 13 Aug 2011 19:06:53 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 76397-07; Sat, 13 Aug 2011 22:06:45 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mbx.knossos.net.nz (mbx.knossos.net.nz [202.160.48.10]) by mail.postgresql.org (Postfix) with ESMTP id 66C3BB5DBFE; Sat, 13 Aug 2011 19:06:43 -0300 (ADT) Received: from [10.1.1.3] (60-234-150-59.bitstream.orcon.net.nz [60.234.150.59]) (authenticated bits=0) by mbx.knossos.net.nz (8.14.4/8.14.4) with ESMTP id p7DM6Xjj015413 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Sun, 14 Aug 2011 10:06:35 +1200 Message-ID: <4E46F568.5090403@archidevsys.co.nz> Date: Sun, 14 Aug 2011 10:06:32 +1200 From: Gavin Flower Organization: ArchiDevSys User-Agent: Mozilla/5.0 (X11; Linux i686 on x86_64; rv:5.0) Gecko/20110624 Thunderbird/5.0 MIME-Version: 1.0 To: David Johnston CC: c k , "pgsql-general@postgresql.org" , pgsql-admin Subject: Re: [GENERAL] Using Postgresql as application server References: <4405BEF7-6E71-4FD0-B70F-4E651E2A2381@yahoo.com> In-Reply-To: <4405BEF7-6E71-4FD0-B70F-4E651E2A2381@yahoo.com> Content-Type: multipart/alternative; boundary="------------040508010707010307000009" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201108/131 X-Sequence-Number: 38118 This is a multi-part message in MIME format. --------------040508010707010307000009 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 14/08/11 05:12, David Johnston wrote: > > On Aug 13, 2011, at 11:57, 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 > Code yourself a nice "hello world" application that can accessed by a web browser and outputs in HTML using only PostgreSQL. IF you can actually do that simple task you will then be in a better position to decide if such an architecture is worth expanding upon. > > The better question to ask is why wouldn't you want to use something like Tomcat or Apache+Programming Language? > > David J. > > > Hi, I see from other posts that you are using Python (A lovely language, but one that does not scale well for my own purposes -- unfortunately) so this is most likely not relevant to your current situation. However, for those people who would consider Java, then consider using JBoss 7, it is very fast and will support very sophisticated web front ends while allowing very powerful logic written in Java, and can easily be configured to use PostgreSQL. The combination of JBoss http://www.jboss.org/overview.html and JEE (Java Enterprise Edition), is well suited to large projects that can benefit from multi-core processors and massive amounts of RAM. My own humble development machine has a mere 4 cores and 8GB, but production machines can easily use a terrabyte of memory and many more cores. Eclipse is an IDE that is well suited for developing applications in Java, and can be configured to develop applications for JBoss. Cheers, Gavin I have written a script to install JBoss 7 (a lot easier than for JBoss 4 and earlier!) and convert it to use PostgreSQL 9.1 beta3. This I am using to revise my JEE knowledge and get to grips with version 6 of JEE. --------------040508010707010307000009 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On 14/08/11 05:12, David Johnston wrote: 

On Aug 13, 2011, at 11:57, 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, 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

Code yourself a nice "hello world" application that can accessed by a web browser and outputs in HTML using only PostgreSQL.  IF you can actually do that simple task you will then be in a better position to decide if such an architecture is worth expanding upon.

The better question to ask is why wouldn't you want to use something like Tomcat or Apache+Programming Language?

David J.
Hi,

I see from other posts that you are using Python (A lovely language, but one that does not scale well for my own purposes – unfortunately) so this is most likely not relevant to your current situation.

However, for those people who would consider Java, then consider using JBoss 7, it is very fast and will support very sophisticated web front ends while allowing very powerful logic written in Java, and can easily be configured to use PostgreSQL.

The combination of JBoss http://www.jboss.org/overview.html and JEE (Java Enterprise Edition), is well suited to large projects that can benefit from multi-core processors and massive amounts of RAM. My own humble development machine has a mere 4 cores and 8GB, but production machines can easily use a terrabyte of memory and many more cores. Eclipse is an IDE that is well suited for developing applications in Java, and can be configured to develop applications for JBoss.


Cheers,
Gavin

I have written a script to install JBoss 7 (a lot easier than for JBoss 4 and earlier!) and convert it to use PostgreSQL 9.1 beta3. This I am using to revise my JEE knowledge and get to grips with version 6 of JEE.


--------------040508010707010307000009--