| 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: | Whole Thread | Raw Message | 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?
| 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 |