On Sat, Feb 28, 2015 at 2:39 PM, inspector morse <inspectormorse86@xxxxxxxxx> wrote: > > 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? I think this idea is pretty neat. Posgres string processing will likely not be performance competitive with some of the more popular string processing engines, but it should be fast enough to get the job done in any cases. Some general tips: *) format() function will often yield more readable code than excessive string concatentation via || or concat() *) consider serving static html (perhaps directly via web server vs database rendered) and rethink your strategy to have the database compose json which is post rendered in the browser. This is a very powerful strategy *) advise liberally using powerful javascript libraries (slickgrid, highcharts, google visualizations, etc) vs doing database based constructions of same merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
