Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Automatically check for anti-patterns in SQL queries - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: [GENERAL] Automatically check for anti-patterns in SQL queries
Date
Msg-id orf4ip$j1s$1@blaine.gmane.org
Whole thread Raw
In response to [GENERAL] Automatically check for anti-patterns in SQL queries  (Joy Arulraj <jarulraj@cs.cmu.edu>)
List pgsql-general
Tree view 
Joy Arulraj schrieb am 08.10.2017 um 13:50:
> Hi folks -- We developed a static analysis tool, called SQLCheck, for
> automatically identifying anti-patterns in SQL queries.
> 
> https://github.com/jarulraj/sqlcheck
> 
> Our goal is to provide hints to the developers about potential
> performance and security issues present in SQL queries. I believe
> that integrating such a tool (maybe using a special SQL clause) with
> PostgreSQL can benefit users. Feedback would be much appreciated.

Looks interesting. 

However on Windows 10 this does not seem to work. e.g.:
  sqlcheck -h

simply does nothing. The program briefly starts (I can see the title of my cmd.exe changed) but then exists immediately
withouteven showing the help. 
 

Something like "sqlcheck -f test.sql" also shows no result at all (no error message, no output, nothing)

Regards
Thomas



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Andre Mikulec
Date:
Subject: [GENERAL] https://www.postgresql.org/ftp/source/v10.0/ distribution ISdifferent than git tag REL_10_0
Next
From: David Rowley
Date:
Subject: Re: [GENERAL] OR-clause support for indexes