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... "

5 of 156 comments (clear)

  1. WTF by GleeBot · · Score: -1, Troll

    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.

    SQL isn't Turing complete. It can't loop. That's sorta the whole point.

  2. How do these stories get picked? by Hackerlish · · Score: 0, Troll

    Poorly Written Summary. Something not many people many if any will care about. Yesterday we the 'Language Translation Error' One-liner and now this? How did this story get picked?

  3. Re:Might come in handy by Anonymous Coward · · Score: -1, Troll

    why would you write such a stupid query to begin with?

  4. ATTENTION SHOPPERS! by Anonymous Coward · · Score: -1, Troll

    ATTENTION SHOPPERS: PAY NO ATTENTION TO THE NECROTIC DOG PENIS. I REPEAT, PAY NO ATTENTION TO THE NECROTIC DOG PENIS CURRENTLY LOOMING OUTSIDE LOT 4. CONTINUE SHOPPING BUT PLEASE ENSURE YOU LEAVE VIA AN ALTERNATIVE EXIT AS WE ARE NO LONGER ABLE TO GUARANTEE YOUR SAFETY IN LOT 4, DUE TO THE NECROTIC DOG PENIS. FOR YOUR INFORMATION, LOTS 1, 2, 3, 5 AND 6 ARE CURRENTLY FREE OF BAYING NECROTIC DOG PENIS. PAY NO ATTENTION TO THE NECROTIC DOG PENIS. THANK YOU.

    Lameness filter encountered. Post aborted! Lameness filter encountered. Post aborted! Lameness filter encountered. Post aborted! Lameness filter encountered. Post aborted! Lameness filter encountered. Post aborted! Lameness filter encountered. Post aborted! Lameness filter = censorship, lameness filter = censorship, lameness filter = censorship, lameness filter = censorship, lameness filter = censorship, lameness filter = censorship.

    Your comment violated the "postercomment" compression filter. Try less whitespace and/or less repetition.

  5. Re:Bring a database down? by Anonymous Coward · · Score: -1, Troll

    I like eating pee pee