Re: Application written in pure pgsql, good idea?

From: Jan de Visser <jan(at)de-visser(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Application written in pure pgsql, good idea?
Date: 2015-03-01 15:39:15
Message-ID: 2488845.AvlUhJNiUn@wolverine
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On March 1, 2015 09:45:24 AM inspector morse wrote:
> This is just for fun/research, I don't need a web framework because PHP is
> actually picking up the incoming requests and sending it to a pgsql stored
> function. The pgsql will concatenate all the html that is required for the
> page and send it back to PHP to write out to the response.
>
> My main concern is, since there will be a lot of concatenation in pgsql to
> generate the HTML, would it affect performance?

Again, performance is the least of your concerns. Building HTML from raw
strings is, except in the smallest of toys, an exercise in frustration. And in
those toys performance won't be an issue anyway.

Save yourself a bunch of aggravation and let PHP do the HTML for you. It's
good at it. pl/pgsql isn't.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2015-03-01 18:00:37 Re: Application written in pure pgsql, good idea?
Previous Message inspector morse 2015-03-01 14:45:24 Re: Application written in pure pgsql, good idea?