Thread: SQL Lint

SQL Lint

From
"Roderick A. Anderson"
Date:
Just rejoined after a year of so of being away and have a question.  The
Search from the PostgreSQL.org mail-archives site isn't working ( or
maybe not working like I think it should ) I get a 503 Server error.

The quesion just came up, as we start the process of moving from MySQL
to PostgreSQL, if there was a 'lint' for SQL syntax?  Looking around
using google.com I found only one decent reference but couldn't find
anything further.

Anyone aware of a lint for SQL ( 92, 99, PostgreSQL )?  We want to look
quickly at the code we're porting for any MySQL-isms so we can figure
out what it is suppose to be so the final post will go smoother.


TIA,
Rod
--


Re: SQL Lint

From
Andreas Kretschmer
Date:
Roderick A. Anderson <raanders@acm.org> schrieb:
> Anyone aware of a lint for SQL ( 92, 99, PostgreSQL )?  We want to look
> quickly at the code we're porting for any MySQL-isms so we can figure out
> what it is suppose to be so the final post will go smoother.

Nice idea. I found http://dbs.informatik.uni-halle.de/sqllint/, but it
is very stricly.


HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°