I am participating in the Stanford Database Class, and there are some problem sets to be solved in "mathy" relational algebra syntax.
RA: an interactive relational algebra interpreter Version 2.1b by Jun Yang (email@example.com) >
I wonder if there is a better evaluator available? This one is pretty good but
on the command-line-interpreter prompt, the cursor position is hard to see
the tool translates relational alegbra experssions to SQL and submits them to SQLite. It does not show (return to the user) the intermediate steps. There should be a -log or verbose option to return the SQL generated. (The ra tool has a -v option to return the submitted ra query).
I want the CREATE VIEW.... and SELECT ... SQL statements that the jar file generates and sends to SQLite. Alternatively, can I configure SQLite to echo/log all sql commands submitted to it? Is there an option for the .properties file?