Introduction, Features and Screen Shots

For a more detailed description see the paper by Gerd Wagner and Glenn Griffin: English version German version

The SQuirreL desktop in Ocean Theme





Introduction:

  1. Configure or add a driver.




  1. Create an Alias.






Features, Screen Shots

Object Tree of Session window
Right-click to access the popup menu which provides access to advanced script generation and graphing features. The graph plugin allows the user to create table charts.




SQL Editor with code completion popup (ctrl+space) open
Code completion can be used to access drop-down lists of options that include keywords, tables, columns, views, stored procedures. Code completion also provides join generation functions. For example, look at the table structure here. Hitting ctrl+space after the expression

#i,ITEM,PRODUCT,PRODUCT_DETAILS,

(note the comma at the end) SQuirreL will expand it to:

INNER JOIN PRODUCT ON PRODUCT.PRODUCTID = ITEM.PRODUCTID
INNER JOIN PRODUCT_DETAILS ON PRODUCT.PRODUCTID = PRODUCT_DETAILS.PRODUCTID




SQL Editor with tools popup menu (ctrl+t) shown
With the tools popup any editor function can be located with only a single short cut: ctrl+t
Additionally, the list can be searched incrementally with just a few keystrokes.




SQL Editor with bookmark selection popup (ctrl+j) shown
Bookmarks are user-defined code templates. SQuirreL comes with several pre-defined example bookmarks for the most common SQL and DDL statements.




Abbreviations and auto corrections dialog
This feature works much like auto corrects in common office products. With the entries shown in the dialog you may for example type 'sf<space>' which will expand to 'SELECT * FROM'.




Editing of SQL results.
The result tabs of SQL queries support editing the rows returned from a query on a single table. You may also edit the contents tab of tables in the Object tree.




Graph: Charts of tables and their relations.
To create new charts or to add tables to existing charts right mouse click tables in the Object tree and choose the 'Add to graph' menu. Graph manipulation functions can be accessed by using the right-click context popup menu.




Graph: Scaling and distributing tables on configurable page sizes to prepare for printing
Use the right-click context popup menu to switch to the scaling and printing mode.