Caché Monitor is an SQL development tool for InterSystems database Caché. It features an advanced SQL query editor with SQL syntax highlighting, SQL code completion with context sensitive information about database objects (also known as Intellisense), an SQL history buffer for executed SQL commands, SQL code formatting, parallel queries, graphical SQL execution plan with index and selectivity information, SQL abbreviations, and much more. Database diagrams graphically show the structure of the database.
|Tags||Utilities Database Front-Ends|
|Operating Systems||OS Independent|
|Implementation||Java SQL jdbc Caché Object Script|
Please use the forum for questions and tips at: http://www.cachemonitor.de/support/forum
Release Notes: This version contains some minor improvements including much better CLOB\BLOB Handling in Table and in Viewer. A problem where the record dialog couldn't be opened was fixed. The "SELECT first 1000 rows" menu entry now executes the query immediately.
Release Notes: For the namespaces list, no access to the "%SYS" namespace is required. The source code in Class Browser shows the same code as in Studio. The Global Browser visualizes different node types with icons. The new Record dialog is available, and shows columns in rows. Each grid in Caché Monitor can open this Record dialog via context menu. In the table viewer, the new storage tab lists the storage information about a table, like global name and global size. All workspace settings are saved on exit and reloaded on startup, so Caché Monitor remembers the window position and state (docked\undocked).
Release Notes: This version supports Java 8. To improve performance\minimize user waiting, prefetching of meta data is implemented. The Tables\Views are grouped by schema, and empty schema will not be displayed by default. CodeCompletion works now on all schema by default. The Source-, Class-, and GlobalViewer show the item count on registertitle and in a tree.
Release Notes: This release opens the current class in Caché Studio, adds some code completion improvements to show more Caché keywords in completion and coloring, adds some code completion display additional information for keywords and functions, and makes icons visualize the completion type (e.g., Table, Column, Schema, Index, etc.). The Type column shows the primary key, datatype, and nullable property. Optimizer hints are listed with additional information Disconnecting a server no longer closes all subpanels. License management has improved.
Release Notes: A new Bulk Export Dialog allows the user to save the current and load the previous selections of Tables. The server version number can now be viewed in the Server Navigator tree, toggled via the Menu "Show version". A new context popup menu in the tables entry allows fast data access via generated SQL: "SELECT first 1000 rows".