Re: Is it considered good practice to use stored procedures for most tasks?

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Gaetano Mendola <mendola(at)gmail(dot)com>, Simon Connah <scopensource(at)gmail(dot)com>
Cc: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Is it considered good practice to use stored procedures for most tasks?
Date: 2019-04-18 08:36:13
Message-ID: 0fe0d50a25af3604b680905901c7c3754c32b1f4.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Gaetano Mendola wrote:
> For sure do not allow your application to touch directly tables, use views and sp,
> lately I'm abandoning views for table functions.

As far as I know, a table function result is materialized on the server,
and you have to wait for the query to finish before you can retrieve the
first row.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Gaetano Mendola 2019-04-18 11:10:29 Re: Is it considered good practice to use stored procedures for most tasks?
Previous Message Steve Horn 2019-04-17 23:04:33 Re: Is it considered good practice to use stored procedures for most tasks?