Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-16 Thread s...@bestmx.ru
Scott Marlowe пишет: On Mon, Aug 15, 2011 at 11:33 AM, s...@bestmx.rus...@bestmx.ru wrote: Scott Marlowe пишет: On Sat, Aug 13, 2011 at 9:57 AM, c kshreeseva.learn...@gmail.comwrote: Dear Postgres users, from last few months I am reading and searching for can postgresql used as

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-16 Thread John DeSoi
On Aug 13, 2011, at 2:44 PM, s...@bestmx.ru wrote: c k wrote: Yes, I know that I can not create a simple web application using only postgresql because we need a web server to server the html content. u r wrong. u CAN! there is nginx_htttp_postgresql_module exactly to connect webserver

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-16 Thread Scott Marlowe
2011/8/16 s...@bestmx.ru s...@bestmx.ru: Scott Marlowe пишет: On Mon, Aug 15, 2011 at 11:33 AM, s...@bestmx.rus...@bestmx.ru  wrote: Scott Marlowe пишет: On Sat, Aug 13, 2011 at 9:57 AM, c kshreeseva.learn...@gmail.com  wrote: Dear Postgres users, from last few months I am reading and

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-16 Thread Evan Rempel
Technically it can be done, but just because we can do something does not mean we should do something. Having said that... We have been using a middleware product that shall remain nameless, that goes against a large commercial database that shall also remain nameless. The middleware has been

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-16 Thread s...@bestmx.ru
Evan Rempel пишет: Security is near impossible to manage as well. Again, almost everything needs to run as the same user. throw your nameless DMS away, or fire the architect. Scott Marlowe ÐÉÛÅÔ: On Mon, Aug 15, 2011 at 11:33 AM, s...@bestmx.rus...@bestmx.ru šwrote: Scott Marlowe ÐÉÛÅÔ:

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-16 Thread Chris Travers
I can't let this slide :-D On Tue, Aug 16, 2011 at 9:27 AM, Evan Rempel erem...@uvic.ca wrote: Technically it can be done, but just because we can do something does not mean we should do something. Having said that... We have been using a middleware product that shall remain nameless, that

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-16 Thread Merlin Moncure
On Tue, Aug 16, 2011 at 11:27 AM, Evan Rempel erem...@uvic.ca wrote: Technically it can be done, but just because we can do something does not mean we should do something. Having said that... We have been using a middleware product that shall remain nameless, that goes against a large

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-16 Thread Scott Marlowe
On Tue, Aug 16, 2011 at 12:25 PM, Merlin Moncure mmonc...@gmail.com wrote: one point that is getting lost in all this that if you are using a database for an application server, this does not mean it's the same database as your main database or even on the same machine -- you can still keep

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-16 Thread c k
I want to use the postgresql for exactly the same use. I want to keep my database separate and use another postgresql machine just as application server. Even for load balancing and scaling we can use many techniques mixed to get the work done. Chaitanya Kulkarni On Tue, Aug 16, 2011 at 11:55

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-15 Thread Scott Marlowe
On Sat, Aug 13, 2011 at 9:57 AM, c k shreeseva.learn...@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, Besides the previously mentioned nginx module there's

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-15 Thread Benjamin Krajmalnik
Further to Scott's comment, we are running our application platform on nginx/php (using php-fpm). It scales very well and it is extremely fast. When running under Apache, we had to constantly restart the apache service because it could not handle the load (at 150 concurrent users hitting the app

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-15 Thread s...@bestmx.ru
Scott Marlowe пишет: On Sat, Aug 13, 2011 at 9:57 AM, c kshreeseva.learn...@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, Besides the previously mentioned

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-15 Thread Scott Marlowe
On Mon, Aug 15, 2011 at 11:33 AM, s...@bestmx.ru s...@bestmx.ru wrote: Scott Marlowe пишет: On Sat, Aug 13, 2011 at 9:57 AM, c kshreeseva.learn...@gmail.com  wrote: Dear Postgres users, from last few months I am reading and searching for can postgresql used as application server? As

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-14 Thread c k
Thanks for everyone. I will give reply after some experiments. Regards, Chaitanya Kulkarni On Sun, Aug 14, 2011 at 6:04 PM, s...@bestmx.ru wrote: On Aug 14 2011, Uwe Schroeder wrote: can u please give me it's link. I found ngx_postgres module. there is

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-13 Thread c k
Yes, I know that I can not create a simple web application using only postgresql because we need a web server to server the html content. I not going to add web server functionalities to postgresql, but just want to use existing features. I would like to generate content dynamically. I want

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-13 Thread s...@bestmx.ru
c k wrote: Yes, I know that I can not create a simple web application using only postgresql because we need a web server to server the html content. u r wrong. u CAN! there is nginx_htttp_postgresql_module exactly to connect webserver directly to postgresql and to OUTPUT query result to a

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-13 Thread c k
can u please give me it's link. I found ngx_postgres module. Chaitanya Kulkarni On Sun, Aug 14, 2011 at 12:14 AM, s...@bestmx.ru s...@bestmx.ru wrote: c k wrote: Yes, I know that I can not create a simple web application using only postgresql because we need a web server to server the html

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-13 Thread s...@bestmx.ru
can u please give me it's link. I found ngx_postgres module. there is nginx_htttp_postgresql_module exactly to connect webserver directly to postgresql and to OUTPUT query result to a browser. http://wiki.nginx.org/3rdPartyModules http://labs.frickle.com/nginx_ngx_postgres/ --

Re: [GENERAL] [ADMIN] Using Postgresql as application server

2011-08-13 Thread Rich Shepard
On Sun, 14 Aug 2011, c k wrote: I would like to generate content dynamically. I want minimum developers to be required, simple and powerful security and administration, and most importantly ability to respond to changes. For my application the most important part is generating dynamic content.