c k wrote:
from last few months I am reading and searching for can postgresql
used as application server?
So i am thinking if I can use postgresql as web application server.
I request to users and developers give your suggestions and opinions.
Waiting for your replies.
Yes! Yes And Yes, my friend!
You should!
i am using postgresql exactly as application server.
(stored procedures in PLpgsql)
at http://platzcart.com i managed to minimize server side scripting:
Stored procedures run entire "business logic" + PHP envelop results into
HTML code.
and in the next project (yet under construction)
i managed to ELIMINATE server side scripting at all
(except captcha server, which is standalone (written in perl))
PLpgsql "business logic" again + client side JS is building presentation.
most important point to support you is
*This is the originally intended usage of a DBMS*
All the troubles, all the NoSQL whining caused by unnecessary middleware.
P.S.
i have held a report to NLUUG Spring Conference 2011
about platzcart.com implementation
it is located at http://platzcart.com/lib/platzcart.pdf
it clearly describes advantages of using postgresql as an application
server.
and i am sure it explains the good practice (maybe the best one)
P.P.S.
now i am using nginx_http_postgres_module
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
