download25.com

Your free TOP 25 download source!

Caché Monitor 0.40

Cache Monitor is an SQL development tool for InterSystems database Cache
Publisher: Cache Monitor
Category: Development Tools
Version: 0.40
License: freeware
Cost: 0$
Size: CacheMonitor_034.zip 4.32 MB
Updated: 10 Oct 2008
Screenshot: view screenshot
Bookmark: Click here
award
Review
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. After typing the keyword ON in a JOIN clause, Caché 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"). The 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.

Changelog:
Version: 0.40(18 May 2008)
V 0.40:
Query Analyzer
- Executing stored procedures with CALL no longe raise exception if the resultset is bigger than 99 rows and the option "block fetch" is used.
- Better code complition in some situations

Server Navigator / Table Browser
- Max Rows and Max Chars can now be configured. Max Rows limit the rows fetched from server. Max Chars limit the size of charfields fetched from server

V 0.39:
This Version is a minor release for better support for Caché 2008.1
and his JDBC Driver. Use Java Runtime Environment 6!! AND Caché JDBC Driver for Java 6 !!
Version: 0.38(31 Jan 2008) - CacheMonitor_034.zip
V 0.38:
Query Analyzer
- The selected commit mode is now stored in query analyzer.
Version: 0.35(08 Jun 2006)
V 0.35:
- Server Info box shows now the driver version and also the compile time of the driver
- Maxresult and Autocomplete state is now saved, so this information is restored after restart

Query Analyzer
- Work now with Caché Driver Version: 2008.1.0.171 Fri 06/01/2007 0:01:54.22
Version: 0.34(26 Apr 2006) -
0.34 is a hotfix release for better support for Caché 2007.1
Version: 0.32(27 Sep 2006)
0.32 in download section with some enhancements e.g.
General
- Main Toolbar removed to get more space
- Main Page context actions added eg: Connect\disconnect
- Open Query Analyzer on last server\namespace show now last server\namespace

Query Analyzer
- Query metadata can displayed by context menu on result table
- Column width can by optimized by context menu
- Column width is optimized for each query
Version: 0.31
Tags: Sql | Editor | Database | Intersystems | Query

download (CacheMonitor_034.zip - 4.32 MB)