PostgreSQL Maestro 6.12 released

Dec 6, 2006

SQL Maestro Group is happy to announce the release of a new version of PostgreSQL Maestro, a powerful Windows GUI solution for PostgreSQL administration and database development.

Please consider the list of new features implemented in PostgreSQL Maestro 6.12 since last official release:

PostgreSQL 8.2 management extensions:

• Now it is possible to specify fill factor when creating/editing tables and indexes;
  
  
• Support of CONNECT privilege for databases and USAGE privilege for sequences is added. For setting sequence-specific permissions the GRANT ON SEQUENCE syntax is used instead of GRANT ON TABLE one;
  
  
• Now it is possible to empty a table together with all foreign-key referencing tables;
  
  
• Now it is possible to create a domain based on another one;
  
  
• Added support for comments on server-scope objects such as roles and tablespaces.

Other server management extensions:

• The Make primary key and Clear primary key commands are now accessible anywhere in the software (Table Editor, Explorer Tree, Object Browser, etc);
  
  
• Since this version PostgreSQL Maestro can display native type names such as int4 instead of SQL-standard ones (e.g. integer).
  
  

• SQL Formatter is done: you can beatify all the DML statements (SELECT, INSERT and UPDATE) in the SQL Editor. Also it is possible to format view definitions;
  
  
• The tabbed interface is implemented in addition to classic MDI (see screenshot). You can choose your favorite UI in the Options dialog;
  
  

  Here is a list of some tabbed interface features:

  • you can drag-n-drop tabs to change their order;
    
    
  • you can close the current tab pressing the mouse wheel (or the middle mouse button);
    
    
  • you can drag-n-drop database objects or selected text between tabs e.g. drag-n-drop a field from a table to another table or select a text at the SQL page of an Object Editor and drag-n-drop it to the SQL Editor;
    
    
  • each tab has a popup menu, which allows you to close current tab, close all tabs or close all the tab except selected one (close other tabs).
    
    
• SQL Script Editor: if a user opens a file larger than 100K, PostgreSQL Maestro will suggest him to execute the script file without opening it in the editor. Of course it is also possible to execute any script file using this way: just press the "Execute script from file" link on the Script Editor navigation bar and specify the filename;
  
  
• We have implemented the Data Analysis, a tool to represent your data as OLAP cubes
  
  
• Database profiles are now grouped by host+port+login combination rather than host+port in the previous versions;
  
  
• The Table Editor interface is improved: now all the subitems i.e. fields, indexes, and triggers are displayed at the main editor tab. We found this layout more comfortable;
  
  
• BLOB Viewer / Editor: the text pane provides now several types of text highlighting (Plain text, HTML, JScript, CSS, PHP, XML, SQL, and PostgreSQL DDL). Also it is possible to find and replace a text fragment of a BLOB column data;
  
  
• It is now possible to refresh schema object list whenever an object depends on other objects e.g. refresh table list on view creation;
  
  
• Since this version PostgreSQL Maestro can hide empty schemas. The corresponding setting can be found at the Explorer page of the Options dialog;
  
  
• The Insert key is now a shortcut for creating a new database object from the Explorer tree;
  
  
• Create profiles wizard: we've added an option for converting new object names to lower/upper case;
  
  
• Data grid: the speed of data loading was significantly increased.
  
  

In addition to this, several bugs were fixed and some other minor improvements and corrections were made.

Related links:

Back to news archive