SQLMinus

来自开放百科 - 灰狐
2007年1月21日 (日) 16:42Cocia (讨论 | 贡献)的版本

跳转到: 导航, 搜索

简介

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.

相关链接


屏幕截图

SQLMinus scr3.png
分享您的观点
个人工具
名字空间

变换
操作
导航
工具箱