[development] Do not let postgresql hold back great patches

Henrique Recidive recidive at gmail.com
Wed Nov 28 14:54:37 UTC 2007


2007/11/28, Karoly Negyesi <karoly at negyesi.net>:
> > Maybe there is an open-source tool which can validate standard SQL
> > which could be used.  Then our DB abstraction could require a
> > verifiable standard SQL syntax which would then be translated (where
> > necessary) into the MySQL, Oracle, Postgres, etc. equivalents.   This
> > might only be for CRUD operations (data manipulation statements) and
> > not for DDL, for which we already have a reasonable API and which are
> > much less standardized.
>
> Good. I do not know about open source but http://developer.mimer.com/validator/index.htm offers what you want.
>

Mimer also provide a free webservice [1] for validating SQL against
ISO standards. This webservice has been implemented by two opensource
projects: phpMyAdmin [2] and SQuirreL SQL [3].

Can we implement this on devel module?

AFAIK it uses SOAP.

[1] http://sqlvalidator.mimer.com/index.html
[2] http://www.phpmyadmin.net
[3] http://squirrel-sql.sourceforge.net

Cheers,

Henrique


More information about the development mailing list