Beta
×

Welcome to the Slashdot Beta site -- learn more here. Use the link in the footer or click here to return to the Classic version of Slashdot.

Thank you!

Before you choose to head back to the Classic look of the site, we'd appreciate it if you share your thoughts on the Beta; your feedback is what drives our ongoing development.

Beta is different and we value you taking the time to try it out. Please take a look at the changes we've made in Beta and  learn more about it. Thanks for reading, and for making the site better!

Snowflake query diagramming tool

alxtoth (914920) writes | about 6 years ago

Databases 0

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

cancel ×

0 comments

Sorry! There are no comments related to the filter you selected.

Check for New Comments
Slashdot Login

Need an Account?

Forgot your password?

Submission Text Formatting Tips

We support a small subset of HTML, namely these tags:

  • b
  • i
  • p
  • br
  • a
  • ol
  • ul
  • li
  • dl
  • dt
  • dd
  • em
  • strong
  • tt
  • blockquote
  • div
  • quote
  • ecode

"ecode" can be used for code snippets, for example:

<ecode>    while(1) { do_something(); } </ecode>