Re: Prepared statements considered harmful - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Prepared statements considered harmful
Date
Msg-id 20060831172945.GF27851@svana.org
Whole thread Raw
In response to Re: Prepared statements considered harmful  (Lukas Kahwe Smith <smith@pooteeweet.org>)
List pgsql-hackers
On Thu, Aug 31, 2006 at 06:34:45PM +0200, Lukas Kahwe Smith wrote:
> BTW: PDO has gotten a switch to force client side placeholder
> replacement in favor of using server side prepared statements due to the
> fact that prepared statements side-step the MySQL query cache.

Perl DBD:Pg also has a switch to force one way or the other.

However (as has been stated already) people are confusing prepared
statements with out-of-line parameters. Even DBI uses the phrase
"prepare" for setting up statements, whereas this doesn't actually
require server-side prepare, all it needs is out-of-line parameters.

I see from the source that DBD::Pg does use PQexecParams() sometimes so
maybe it does support out-of-line parameters...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

pgsql-hackers by date:

Previous
From: "Jaime Casanova"
Date:
Subject: updatable views and default values
Next
From: "Merlin Moncure"
Date:
Subject: Re: Prepared statements considered harmful