Cache Monitor 1.64 Beta

Cache Monitor 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. After typing the keyword ON in a JOIN clause, Cache Monitor displays foreign key join suggestion Cache-SQL formatting can executed from context menu to make your code, or the code of others, much easier to read ("Format SQL").

Cache Monitor also supports of course: Undo/Redo and Search and Replace. With Hyperlink navigation you can simple navigate from the editor to Tables metadata.

When you presses the CTRL key and hovers the mouse cursor over a certain code element, the element is changed to a hyperlink. When you holds the CTRL key and clicks on the hyperlink, the "go to Tables metadata" action is performed.

NOTE: To be able to download Cache Monitor you will have to register for an account on the developer's website, HERE.

Here are some key features of "Cache Monitor":

Server Navigator for Intersystems Cache:
· The server navigator allow to browse Intersystems Caché servers and there database objects and structures such as tables, views, classes, indexes, constraints, procedures, functions, etc.

Integrated Query Analyzer with code completion (Intellisense):
· The Query Analyzer is fully integrated in Caché Monitor.
· The Query Analyzer (SQL Editor) support developers with Code completion and an graphically execution plan with information about column selectivity and used/existing indexes.

The execution plan in Query Analyzer:
· Cachè Monitor provides a visual display of an execution plan for SQL Queries. With this information it is more easily to tune SQL Statements.

Caché Process Viewer:
· With the Caché Process Viewer (Processlist) you see details about Caché processes.

SQL Editor with variable substitution in version 0.56:
· In the new version 0.56 Caché Monitor execute parameterized SQL queries.

· Caché Locktable Viewer
· To display or delete locks, click on the Lock Table in the Server Navigator.

Requirements:

· Java 6.0
· ~ 1.5 MB disk space
· A minimum of 64 MB RAM

What's New in This Release: [ read full changelog ]

· FIXED: TableViewer - Editing\deleting function fixed
· FIXED: TableViewer - If you make a table editable and selecting another table, editable mode is set to false again
· FIXED: TableViewer - Refresh bug in RowHeader fixed
· FIXED: TableViewer - The Color for NULL values are now a system color
· FIXED: TableViewer - Fixed handling with tables with a dot in name
· ENH : TableViewer - The Import Table function added. Cache Monitor can import data from csv files

FIXED: TableViewer:
· Import Table, Export Table and Save Results clarified. Save Result is on every Table available and saves the Result from this table
· Export Table saves the entire table data into file
· Import and Export is only available in the TableViewer (with the context menu on the top table)