Re: Using Postgresql as application server - Mailing list pgsql-general
| From | Andreas Joseph Krogh |
|---|---|
| Subject | Re: Using Postgresql as application server |
| Date | |
| Msg-id | 4E46D0D7.3090700@officenet.no Whole thread Raw |
| In response to | Using Postgresql as application server (c k <shreeseva.learning@gmail.com>) |
| Responses |
Re: Using Postgresql as application server
(Merlin Moncure <mmoncure@gmail.com>)
|
| List | pgsql-general |
On 08/13/2011 05:57 PM, 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
No, PG has never, and will never, act as an application-server. Are you really sure you need a full-blown application-server?
If you're familiar with Scala (a language which runs on the JVM) I really recommend Lift (www.liftweb.net) with PostgreSQL. Definitely the best. Although Lift has a history of having a steep learning-curve I always favour maintainability, type-safety and robustness over RAD and time-to-market. Having said that I honestly think a skilled Lift team is at least 2x more productive than with any other web-based framework for building modern UI.
I'm about to post a Lift+JPA+Spring+PostgreSQL example soon which demonstrates how to use Lift with Spring+JPA+XA(2 phase commit, aka. distributed transactions). Follow the mailing-list and you'll see it there soon (I hope): http://groups.google.com/group/liftweb
--
Andreas Joseph Krogh <andreak@officenet.no>
Senior Software Developer / CTO
Public key: http://home.officenet.no/~andreak/public_key.asc
------------------------+---------------------------------------------+
OfficeNet AS | The most difficult thing in the world is to |
Rosenholmveien 25 | know how to do a thing and to watch |
1414 Trollåsen | somebody else doing it wrong, without |
NORWAY | comment. |
Org.nr: NO 981 479 076 | |
| |
Tlf: +47 24 15 38 90 | |
Fax: +47 24 15 38 91 | |
Mobile: +47 909 56 963 | |
------------------------+---------------------------------------------+
> 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
No, PG has never, and will never, act as an application-server. Are you really sure you need a full-blown application-server?
If you're familiar with Scala (a language which runs on the JVM) I really recommend Lift (www.liftweb.net) with PostgreSQL. Definitely the best. Although Lift has a history of having a steep learning-curve I always favour maintainability, type-safety and robustness over RAD and time-to-market. Having said that I honestly think a skilled Lift team is at least 2x more productive than with any other web-based framework for building modern UI.
I'm about to post a Lift+JPA+Spring+PostgreSQL example soon which demonstrates how to use Lift with Spring+JPA+XA(2 phase commit, aka. distributed transactions). Follow the mailing-list and you'll see it there soon (I hope): http://groups.google.com/group/liftweb
--
Andreas Joseph Krogh <andreak@officenet.no>
Senior Software Developer / CTO
Public key: http://home.officenet.no/~andreak/public_key.asc
------------------------+---------------------------------------------+
OfficeNet AS | The most difficult thing in the world is to |
Rosenholmveien 25 | know how to do a thing and to watch |
1414 Trollåsen | somebody else doing it wrong, without |
NORWAY | comment. |
Org.nr: NO 981 479 076 | |
| |
Tlf: +47 24 15 38 90 | |
Fax: +47 24 15 38 91 | |
Mobile: +47 909 56 963 | |
------------------------+---------------------------------------------+
pgsql-general by date: