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:
Configure or add a driver.
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.