Re: SQL injection, php and queueing multiple statement

From: Yasuo Ohgaki <yohgaki(at)ohgaki(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SQL injection, php and queueing multiple statement
Date: 2008-11-11 09:51:49
Message-ID: 491955B5.6020707@ohgaki.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Developers,

It seems you are overlooking application user/system admin perspective.

I agree developers should use prepared statement, but application user or
system admins are not able to modify codes usually.

There are many PostgreSQL/MySQL applications that generating SQL statements.

MySQL's query API only allow single SQL statements at a time, while PostgreSQL
allows multiple statements. Therefore, MySQL users will likely to have less
impact from buggy codes compare to PostgreSQL users.

It would be nice to have API like PQquerySingle that allows only a single SQL
statement at a time.

--
Yasuo Ohgaki

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message WaGathoni 2008-11-11 10:10:08 Re: Chart of Accounts
Previous Message Andrus 2008-11-11 09:14:52 Re: Current log files when rotating?