[ale] query diagramming

[Michael B. Trausch]

On 03/02/2010 04:09 PM, Jim Kinney wrote:
> I need to make pictures of my postgresql queries fro the pointy-haired
> boss types. I have Dia which I've used extensively to document the
> logical flow of the application.
> Now I need to produce a pictorial map of the logic of the actual sql
> queries. google is not being helpful on this as I keep getting a
> gazillion apps for making pictures of the database structure (that's
> already done.).
>
> The only thing I've seen is an example of using Venn Diagrams to
> illustrate joins.  OK. That makes loads of sense. But how do I
> illustrate an insert or an update? Or the sub query based on date string
> logic used as the source data for the insert's join call?

I'm not entirely certain that there would be any way to really put into 
picture the various types of queries that you would find in an SQL-based 
application.  I mean, you could do something like draw a SELECT as 
"grabbing" columns from tables that are perhaps positioned in a 
Venn-diagram, or an INSERT as "placing" row(s) into a table, or an 
UPDATE maybe as a SELECT followed by a DELETE followed by an INSERT (I 
don't know how else to represent such a thing pictorially).  But all of 
it seems pointless.

Why can't they settle for an English version of the query?

	--- Mike

-- 
Michael B. Trausch                                    ☎ (404) 492-6475