SQLMinus

2010年9月26日 (日) 10:18的最后版本

[编辑] 简介

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.

[编辑] 相关链接

• 官方网站

[编辑] 屏幕截图