Slashdot is powered by your submissions, so send in your scoop

 



Forgot your password?
typodupeerror
Databases

+ - Snowflake query diagramming tool->

Submitted by alxtoth
alxtoth (914920) writes "There is a new open source tool that parses SQL Select statements and generates a diagram. It shows parts of the underlying SQL directly in the diagram. For example x=30 , GROUP BY (year), SUM(sales), HAVING MIN(age) > 18. The primary reason for the tool was to avoid cartesian joins and loops in SQL written by hand, with many joined tables. The database will execute such a syntactically correct statement, resulting in runaway queries that can bring the database down. If you sit close to the DBA's, you can hear them screaming .. License is BSD, and link: http://sourceforge.net/projects/revj/"
Link to Original Source
This discussion was created for logged-in users only, but now has been archived. No new comments can be posted.

Snowflake query diagramming tool

Comments Filter:

Never try to teach a pig to sing. It wastes your time and annoys the pig. -- Lazarus Long, "Time Enough for Love"

Working...