Slashdot Mirror

← Back to Stories (view on slashdot.org)

Diagramming Tool For SQL Select Statements

Posted by kdawson on from the unique-like-a-snowflake dept.

alxtoth writes "Snowflake is a new BSD-licensed 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 statement, if syntactically correct, resulting in runaway queries that can bring the database down. If you sit close to the DBAs, you can hear them screaming... "

2 of 156 comments (clear)

  1. So, an alpha project for what exactly? by Mycroft_514 · · Score: 5, Interesting

    Doesn't name WHICH RDBMS, and then you throw SQL at it? So what? For DB2 we have a thing called "Visual Explain" which NOT ONLY does this, but is free, provided by IBM, but also shows you other things like whch index is being used for each step, etc.

    This is news? This isn't even worth a second look!

  2. Comment removed by account_deleted · · Score: 5, Interesting

    Comment removed based on user account deletion