SQLMinus

2007年1月13日 (六) 18:49的版本

简介

SQLMinus is an SQL Client with many developer-friendly features including::

• auto-linking across tables
• dependency discovery
• simple, intuitive and powerful keys to sort columns and filter data
• tab-completion of table and column names
• expansion of abbreviations (as in vi)
• expansion of previously entered words (as in vim)
• User may select tables and columns from combo lists and construct an SQL. Does auto-joining of fields, thus making SQL construction very easy
• preferences may be configured by user in file, or specified during session
• creation of create, insert, update script from table metadata
• creation of create index scripts by just selecting table and keys
• creation of other scripts (e.g. primary key) by just selecting table and columns
• allow user to add new script templates that will generate scripts on selecting tables and columns
• data presented in text format or tabular format (JTable). Multiple tables may be viewed
• Allows reflection of java.sql classes and the database meta data
• User may save command or output area to file and read the same from a file
• User can run a batch command from a file. If the driver does not support batched SQLs, then they would be issued individually
• User may define an SQL statement to be executed for multiple tables(such as if a user wants to see the count of rows in many tables one by one, or all data in a table one by one)
• Can auto-construct a query based on table/s and field/s selected in combo.Will automatically create joins on identically named fields.
• One may specify links between tables in the ini file. When auto-constructing an SQL, descriptive fields such as person_name or

     dept_name will also be picked from the master table. See the ini file for an example of a link.

• preferences can be specific to database or product or user (using hooks as in mutt)
• SQLs can be set as bookmarks which will appear in Bookmarks menu,or can be loaded from a file in XML format.
• regular expression searching in results
• paging of results
• intelligent linking across tables
• define your own keystrokes for actions
• Has been used on both Oracle and mysql
• Updating/deleting data in table view: the data tables are readonly, however, if you select a row, and press Table - Update Action, the sql to update that row will be appended into the input area. Similarly, you can press Delete Action etc. Then you modify the sql and run it.

相关链接

• 官方网站 http://sqlminus.sourceforge.net/

屏幕截图