SQLMinus

来自开放百科 - 灰狐
(版本间的差异)
跳转到: 导航, 搜索
 
 
(未显示2个用户的3个中间版本)
第1行: 第1行:
 +
{{top news}}
 +
 
==简介==
 
==简介==
 
SQLMinus is an SQL Client with many developer-friendly features including::
 
SQLMinus is an SQL Client with many developer-friendly features including::
第20行: 第22行:
 
* Can auto-construct a query based on table/s and field/s selected in combo.Will automatically create joins on identically named fields.
 
* 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
 
* 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.
+
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)
 
* 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.
 
* SQLs can be set as bookmarks which will appear in Bookmarks menu,or can be loaded from a file in XML format.
第31行: 第33行:
  
 
==相关链接==
 
==相关链接==
*官方网站 http://sqlminus.sourceforge.net/
+
*[http://sqlminus.sourceforge.net/ 官方网站]
 
+
  
 
==屏幕截图==
 
==屏幕截图==
 +
<gallery>
 +
image:SQLMinus_scr3.png
 +
</gallery>
 +
 +
[[Category:Database]]
 +
[[Category:Java]]

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.

[编辑] 相关链接

[编辑] 屏幕截图

分享您的观点
个人工具
名字空间

变换
操作
导航
工具箱