Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Tree-wise visualization of database connections and hierarchical objects structure
  • Contextual popup menu with supported operations on each database entity (e.g. compile, execute, refresh lists)
  • Several embedded navigation capabilities via context menu (e.g. from column to its constraints, from synonym to underlying object)
  • Accessors for database object editor and method execution operation 
  • Navigation history and speed search capabilities
  • Highlighting of invalid objects, accessors for multiple-compile operation (identify invalid objects and fire compilation operation on them) **
  • DDL extraction to editor or to clipboard (deprecated feature - see ddl file creation in code-editor section) **
  • Lazy loading of database objects (objects are loaded only on demand from the database to save system resources)
  • Intelligent background loading strategies strategy to ensure minimal waiting times for developer

Note: Refreshing objects feature is still in testing phase and not available yet (because of serious system instability hazard)

top

Anchor
ExecutionEngine
ExecutionEngine

...

  • Execution of sql statements can be fired directly from the editor gutter against the database mapped to the editor
  • Sticky linkage between statements in editor and execution result (navigation from the editor to the result and backwards is ensured even if the file is being edited)
  • Sortable query results in tabular form
  • Export of query results to file or to clipboard in several formats (sql insert statements, .xls, .csv)
  • Message window for failed statement executions
  • Executed statement preview window (useful when the underlying statement has been changed in editor)
  • Transaction awareness on execution of data manipulation statements (commit and rollback controls are being enabled for the corresponding connection)
  • Compiler engine for database program objects (functions, procedures, triggers, packages, types) **
  • Method execution engine with persistency of input values and detailed output panel

NotesNote:
     Configuration of execution processes is still pending.    Method execution is still under development and not released yet (execution input mask is released but still draft)

top

Anchor
CodeEditor
CodeEditor

...

  • Editor for database functions, procedures, packages, types and triggers
  • Qualified editor for database views (advanced editing capabilities like code completion, folding, navigation, error highlighting)
  • Show changes facility (diff visualization for local changes and changes against database)
  • Basic team coding support to prevent blind overwriting on concurrent editing (if the edited object was changed by a third party since it was last saved, developer will be prompted to merge the changes)  
  • Support for creation of DDL files for database objects
  • DDL file mapping - locating and aggregating project .ddl files with the database objects being edited (ddl files are automatically updated when object is edited) 
  • Firing compile operation after updating changes to database **
  • Compiler error messages in the execution console with navigation to code (to exact row and column position) **
  • Structure projection in the "Structure" tool window (not navigable)

Notes:
  Signature changes on program objects are not reflected in the object browser or structure window due to the missing (not-released) refresh feature (see object browser)
  Version Note:  Version conflict editors are not highlighted. Will be fixed in future releases. 

...