Application written in pure pgsql, good idea?

From: inspector morse <inspectormorse86(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Application written in pure pgsql, good idea?
Date: 2015-02-28 20:39:06
Message-ID: CAHYn==4QsGTofh-PZ-j9gnJLDOHCL4seS=ZMW=wK1Y+xSTu+ZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it a good idea to write a simple application (consisting of just data
entry interfaces) in pure pgsql?

Basically, we would have each page has a stored function in postgresql that
is called by php+apache (the http get/post values would be passed into
postgrel as an array).

The pgpsql would render HTML and return back to the front end for display.

Sample:
create function render_user_login_page(out v_html varchar)
returns varchar
as
$$
begin
v_html := v_html || '<table><tr><td>User ID:</td><td><input
type="text" /></td></tr></table>';
end;
$$

Would there be any performance issues with doing this?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan de Visser 2015-02-28 21:39:16 Re: Application written in pure pgsql, good idea?
Previous Message Adrian Klaver 2015-02-27 20:08:04 Re: 'missing' data on replicate