Tuesday, November 11, 2008

link to revj from Canada

Dr. Dwight Deugo from School of Computer Science, Carleton, Canada kindly mentions Reverse Snowflake Joins in his COMP5900 course on Open Source Software (Fall 2008). Link is here

Friday, September 26, 2008

Friday, September 12, 2008

Digg

Posted a link on Digg, hope that somebody will care to vote it up

Wednesday, September 10, 2008

online demo

Finally managed to put an online demo of Reverse Snowflake Joins .

Saturday, September 6, 2008

Link from Graphviz

Reverse Snowflake Joins was linked from Graphviz site

Wednesday, August 27, 2008

Link from MonetDB

MonetDB site posted a link to Reverse Snowflake Joins, their link is http://monetdb.cwi.nl/

Tuesday, August 5, 2008

Monday, August 4, 2008

Friday, August 1, 2008

Reverse Snowflake Joins


Just subbmited to Sourceforge.net a new project, called "Reverse Snowflake Joins" (revj). The description:

A tool that parses SQL Select statements and generates a diagram. In addition to joins, the diagram shows parts of the underlying SQL directly in the diagram. For example x=30 , GROUP BY (year), SUM(profit), HAVING MIN(age) > 18 

And a sample diagram with some random column names, WHERE conditions and GROUP BYs

-Alex 


Wednesday, July 30, 2008

Practical usage of "Tangible Functional Programming"

Just watched the Google Talk about " Tangible Functional Programming" by Conal Elliott.

Got the idea of using it in practice by wrapping up existing applications and offering them inside the framework. For example a "transformation" around say, Firefox, that takes as input a string and represents as output the webpage (maybe of primitive type image) . An example application would be: input text box "www.google.com/search?q=" , another input text box with the actual query, say "Python", and the transformation "browse with Firefox"

Or a transformation for mysql command line utility, that would take inputs: database + username + password + SQL statement and return the query result as text.

Many applications , including GUIs, can be accessed on the simple command line + parameters paradigm, and as such could be wrapped up as TV transformations.