Cache Monitor is the SQL development tool designed for InterSystems database Cache. It supports developers with features, like: Advanced SQL Query Editor, Cache-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting,Graphical SQL execution plan and more.
You see the process ID (PID) from your connection on the Tabpane on every Query Analyzer. Code completion allows you to type a few characters and then display a list of context-sensitive possibilities to complete the text you are typing. Editor code completion brings up a list of Tables or Columns (also known as Intellisense). Code completion can be triggered by pressing [CTRL+SPACE] or by typing a hotchar or keyword, such as "." or "," in an SELECT list. Cache-SQL formatting can executed from context menu to make your code, or the code of others, much easier to read ("Format SQL"). Also supports, of course: Undo/Redo and Search and Replace.
Since version 0.18 the Hyperlink navigation has been added. Hyperlink navigation is a means for simple navigation from the editor to Tables metadata. When you presses the CTRL key and hover the mouse cursor over a certain code element, the element is changed to a hyperlink. When you hold the CTRL key and click on the hyperlink, the go to Tables metadata action is performed.
Since 0.20, Cache Monitor contains features to tune the database.
Product's homepage
Requirements:
· Java 2 Standard Edition Runtime Environment
What's New in This Release: [ read full changelog ]
· This version fixes some bugs with date datatypes.
· Row headers are back in all tables.
Find us on Google+
