Re: pgsql vs mysql - Mailing list pgsql-general

From Scott Marlowe
Subject Re: pgsql vs mysql
Date
Msg-id 1152637727.6540.76.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: pgsql vs mysql  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: pgsql vs mysql
List pgsql-general
On Tue, 2006-07-11 at 11:04, Jan Wieck wrote:
> On 6/30/2006 1:07 PM, Merlin Moncure wrote:
>
> > * mysql has a few features here and there which are nice...just to
> > name a few, flush tables with lock, multiple insert, etc

> The multiple insert stuff is not only non-standard, it also encourages
> the bad practice of using literal values directly in the SQL string
> versus prepared statements with place holders.

I thought it was in the SQL 99 standard...

>  It is bad practice
> because it introduces SQL injection risks since the responsibility of
> literal value escaping is with the application instead of the driver.

agreed, however.

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: pgsql vs mysql
Next
From: Jan Wieck
Date:
Subject: Re: pgsql vs mysql