Customers
PostgreSQL Maestro online Help
Prev  |
Return to chapter overview | Next  |
What's new
10/07/2008 - PostgreSQL Maestro 8.10 released
Server management extensions:
| • | The new version allows you to connect to remote PostgreSQL servers with restricted access via HTTP tunneling. The technology works as follows: |
| o | Upload the connection PHP script to your website. The script is named pgsql_tunnel.php and can be found under the installation folder, usually C:\Program Files\SQL Maestro Group\PostgreSQL Maestro. |
| o | Test the script in your web-browser (optionally). |
| o | Enter the script URL in the Create Profiles Wizard, Create Database Wizard, or Edit Database Profile dialog. Of course you should select the I have to use HTTP tunneling option in any of these windows. |
| • | Starting with this version it is possible to edit trigger's function body directly from Trigger Editor. |
| • | An ability of using the COPY FROM STDIN command has been incorporated into the Import Data wizard. This feature can speed up the import process up to 10 times so it is recommended to use it always if possible. Also we have added the Empty table before importing option (can be found at the last step of the wizard). |
Interface improvements:
| • | Data Grid features the following things: |
| o | Starting with this version it is possible to use the lookup editor for a column, which is linked by a foreign key with a (single) column from another table. The editor displays the contents of parent table’s columns within the dropdown window. |
| o | A possibility of displaying data in the master-detail form has been incorporated into the Table Editor (multiple detail pages can be displayed for a single master row). Use the Show/Hide details link at the editor’s navigation bar to activate/deactivate this view mode. |
| o | Filtering, grouping, and sorting features become available for TEXT columns. Also it is possible to edit the contents of such columns in a separate window as well as encrypt it using the md5 algorithm. |
| • | The Dependency tracker tool has been implemented (Main Menu | Tools | Dependency tracker). Use this tool to browse all-level dependencies of a schema object (table, view, function, etc). |
| • | PL/pgSQL Debugger: an ability to drag and drop a variable from the source code window to the watch list has been implemented. |
| • | Database Designer settings: the Show hints option has been added. Also it is now possible to select the default graphic file format to export diagrams as images. |
| • | Process Browser: the statements at the Last SQL tab are now formatted if possible. |
| • | Data Export, Data Import, and Get SQL Dump wizards now store their size and position. |
| • | Database Explorer: the Data management group has been added to table and view nodes popup menus. Use this group items to run Data Export, Data Import, and Get SQL Dump wizards for the selected table or view without opening its editor (the Empty Table command has been moved to this group too). The Go to foreign table command is now available for all the foreign keys. |
03/20/2008 - PostgreSQL Maestro 8.3 released
Server management extensions:
| • | This version features the PL/pgSQL Debugger. It is a tool to debug PL/pgSQL functions using traditional debugging features such as setting break points, viewing variable values, and examining the call stack. To debug a function, select the appropriate command from the object pop-up menu in the Explorer tree, or choose Main menu | Tools | PL/pgSQL Debugger and select a PL/pgSQL function directly in the debugger window. |
Interface improvements:
| • | This version of our software is fully compatible with large fonts (120 DPI). |
| • | Extract database wizard: common database properties and program info are now included into the result scripts. |
| • | SQL Editor: a popup menu has been added to each query tab. Using this menu you can create a new query, close existing one, save the query to profile, etc even if editor's navigation bar is closed. |
| • | Create Database Wizard, Create Profiles Wizard, and object creation wizards become resizable. |
| • | Data import wizard: the interface for adding and editing of replacements has been slightly improved. |
| • | The F11 key is now used to show/hide the Explorer tree. |
| • | Data grid options: it is now possible to restrict maximum column width. |
| • | SQL Script Editor settings: the "Use script runner for large scripts" option has been added. |
12/11/2007 - PostgreSQL Maestro 7.12 released
PostgreSQL 8.3 management extensions:
| • | Support for ENUM types has been added. You can create new such types, edit existing ones and, of course, drop unnecessary types. Also the corresponding editor has been implemented in the Data Grid (also works for domains based on ENUM types, domains based on domains based on ENUM types and so on). |
| • | Function management: now it is possible to set up the environment for a function as well as customize its execution cost and estimated number of rows returned by a set-returning function. |
| • | Support for XML and UUID types has been implemented. |
Other server management extensions:
| • | The Rule permission is no longer displayed for PostgreSQL 8.2+ because it was removed in that release for security reasons. |
| • | SQL parser now accepts queries with !~~, ~~, ~~* and !~~* operators (SQL Formatter, View Editor). |
Interface improvements:
| • | The SQL Generator tool has been implemented. Use this feature to produce various SQL scripts (CREATE, DROP, SELECT, INSERT, etc) for the selected object. The result script can be saved to a file, copied to clipboard, and opened in SQL Editor or SQL Script Editor. |
| • | Data Grid has been significantly updated: |
| o | The notification pane is now displayed after simple mode activation (filtering, grouping and sorting features are not supported in this mode). All the related settings can be customized in the Options dialog; |
| o | The Generate Query command has been added to the Table / View Editor. Use this command to copy current filter conditions to the SQL Editor window as an SQL query. It is also possible to copy filter condition to clipboard as WHERE clause using grid’s popup menu; |
| o | Now it is possible to encrypt the contents of the selected cell by the md5 algorithm (the corresponding item has been added to grid's popup menu). |
| • | Database designer: the Note and Text tools have been added. You can use them to decorate the diagrams. |
| • | Create Database Profiles wizard: the Hide already registered databases option has been added. |
| • | Object editors, SQL Editor, Database Designer, BLOB Viewer and other database-dependent windows: only connected databases are now displayed in the drop-down list. |
09/20/2007 - PostgreSQL Maestro 7.9 released
Server management extensions:
| • | Begining with this version you can backup the whole database as well as selected schemas or tables. To invoke this tool, choose Backup Database from the Tools menu or use schema/table popup menu in the Explorer tree or Object Browser. |
| • | Now it is possible to cancel a long running query execution and/or data fetching. |
Interface improvements:
| • | The SQL Formatter for DML statements is significantly improved (especially for CASE...WHEN...ELSE clauses and complex WHERE conditions). Also it is now used for view body formatting (PostgreSQL stores such bodies as a single line). The formatter can be invoked by means of the Format SQL link on the SQL Editor's navigation bar (Ctrl+Alt+D shortcut). |
| • | Database Designer: now you can drag a schema in the Explorer tree or Object Browser and drop it in the Designer window: all schema tables will be added to the current diagram. |
| • | Now PostgreSQL Maestro displays execution time for lengthy operations. |
| • | Data Import Wizard: the speed of loading of Excel files was significantly increased. |
| • | BLOB Viewer: now it is possible to save all BLOBs from a table to a given directory. |
| • | The hints for connected databases in the explorer tree now contain connection ID and database encoding. |
06/25/2007 - PostgreSQL Maestro 7.6 released
Server management extensions:
| • | The most important thing added in this version of PostgreSQL Maestro is support of UTF-8 data. |
| • | Process Browser is implemented. This feature is very useful for DBAs who want to monitor the users' activity (in fact, there are potentially thousands of sessions in a database at any one time). You can view details for each session (such as user, connect time, database name, client host, last SQL statement executed and more) as well as group and filter sessions by client host, connected user, database, client application, etc. To access the Process Browser window, select the corresponding item from the Tools menu. |
Interface improvements:
| • | Database Designer: a possibility of locking/unlocking diagram objects is added. This feature prevents your diagram from unforeseen changes: when the diagram is locked, you can neither move/resize/delete existing objects nor add new ones. |
| • | Some new features are incorporated into SQL Editor and SQL Script Editor. Now it is possible: |
| o | comment/uncomment selected text (Shift+Ctrl+. / Shift+Ctrl+, shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift+Ctrl+, having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported; |
| o | convert selected text to different cases (lower, UPPER, and NameCase); |
| o | export the contents of the editor to RTF and HTML formats (to file or to clipboard); |
| o | print/preview the contents of the editor. |
| • | The Copy to SQL Script Editor command is added to all object editors (available in the Navigation Bar on the SQL tab). Use it for quick copying object’s SQL definition (DDL) to the SQL Script Editor for future modifications; |
| • | Data grid: some advanced filtering abilities were implemented (see Main menu | Tools | Options | Data grid | Filter); |
| • | Explorer tree: the Browse command is added to lists' popup menus (runs the Object Browser tool). |
3/20/2007 - PostgreSQL Maestro 7.3 released
Server management extensions:
| • | None in this version; |
Interface improvements:
| • | The main feature of the new version is the Graphical Database Designer - a case tool for managing your database in a few mouse clicks. This piece of our software is intended for creation of physical Entity Relationship Diagrams that represent objects in your PostgreSQL databases. Each diagram displays the tables of your database and the relationships between them; |
| o | Handy tools of Designer allow you to create new and edit existing tables and references; |
| o | The reverse engineering feature will help you to understand the schema structure and make its modification in an easy and clear way; |
| o | Now you can quickly and easily print your database structure with a lot of options including header and footer, paper size and orientation, etc; |
| o | A rich set of options and settings give you a way to see your database in your own look and feel style. |
A diagram of your database can help you define operational aspects of your application logic that you might otherwise overlook. Also, a well-defined data diagram that accurately represents your tasks can be helpful in orienting employees to goals and operations.
| • | SQL Editor: now PostgreSQL Maestro can edit even very large SQL files. Also the speed of editor's work has been significantly improved; |
| • | SQL Editor: queries' tabs can now been displayed at the all sides of the editor (bottom, top, left or right); |
| • | The hint for foreign keys now contains such information as foreign table name and field correspondence. |
12/06/2006 - PostgreSQL Maestro 6.12 released
The new version of PostgreSQL Maestro, a powerful Windows GUI solution for PostgreSQL server administration and database development, has been released.
Please consider the list of the new features implemented in PostgreSQL Maestro 6.12:
PostgreSQL 8.2 management extensions:
| • | 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). |
Interface improvements:
| • | 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 the corresponding topic). You can choose your favorite UI in the Options dialog; |
| • | 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 SQLite DDL). Also it is possible to find and replace a text fragment of a BLOB column data; |
| • | It now available to refresh schema object list whenever an object depends on other objects e.g. refresh table list on view creation; |
| • | 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. |
07/16/2006 - PostgreSQL Maestro 6.7 released
The new version of PostgreSQL Maestro, a powerful Windows GUI solution for PostgreSQL server administration and database development, has been released.
Please consider the list of the new features implemented in PostgreSQL Maestro 6.7:
Server management extensions:
| • | implemented Foreign key references, the feature allows you to manage foreign keys that are created in other tables and reference columns of the current table; |
| • | provided support for OUT and INOUT function parameters (PostgreSQL 8.1). |
Interface improvements:
| • | SQL Editor improvements: now you can execute each query in a separate thread in order to continue your work with the software while the query is executing. The Procedure Editor is also improved for the purpose of executing the routine asynchronously; |
| • | PostgreSQL Maestro wizards windows are resizable now for more usability; |
| • | the server version can now be viewed from the tool tip of the database node; |
| • | added an ability to edit object properties directly from the explorer tree without opening the object editor; it helps you to make your work with your PostgreSQL database objects faster; |
| • | added an ability to rename an object directly from the explorer tree without opening its editor; |
| • | added more key shortcuts: a new query can be created in SQL Editor through the Ctrl+N shortcut and deleted through the Ctrl+R shortcut. |
In addition to this, several bugs were fixed and some other minor improvements and corrections were made.
06/09/2006 - PostgreSQL Maestro 6.6 released
The new version of PostgreSQL Maestro, a powerful Windows GUI solution for PostgreSQL server administration and database development, has been released.
Please consider the list of all the new features implemented in PostgreSQL Maestro 6.6:
Server management extensions:
| • | It is now possible to enable/disable a trigger (PostgreSQL 8.1); |
| • | Rows' OIDs are now displayed in the data grid for tables created using WITH OIDS option; |
Interface improvements:
| • | we have implemented the Object Browser tool, which operates like Object Manager, but includes some additional features such as properties grouping, filtering, and sorting. For example it is easy to find all the tables, which have more than 10 fields or all the domains based on INTEGER type in a few mouse clicks. You can also open several objects' editors simultaneously as well as drop all the selected objects by a single operation; |
| • | all the system objects such as pg_catalog or information_schema objects now can be displayed in a different color (purple by default). The color can be set in the Options window (the Explorer tab); |
| • | Definitions of domains based on INTERVAL(n) data type are now displayed correctly. |
| • | the connected databases are now displayed in bold everywhere (object editors, Object Manager, Object Browser, etc); |
| • | the Describe Object command is now included into the popup menu of each object as well as into navigation bars. Use it to specify the object's comment without opening its editor; |
| • | the F8 and Shift+F8 key shortcuts now can be used to open/execute queries in the SQL Editor. F9 and Shift+F9 work too. |
In addition to this, several bugs were fixed and some other minor improvements and corrections were made.
05/18/2006 - First public release of PostgreSQL Maestro
PostgreSQL Maestro is a powerful solution for PostgreSQL server administration and development. It allows you to create, edit, copy, extract and drop all the database objects such as tables, views, functions, domains, aggregates, etc., build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, manage PostgreSQL users and their privileges, and use a lot of other tools designed for the easiest and most efficient work with PostgreSQL Server.
Our product versions are formalized according to the date when they are released: the first figure of the product version stands for the year of release; the second figure of the version is meant to indicate the month of the current version release. Hence, the present version is 6.5.
While developing the new software product we tried to include the usable features available in the existing products and to provide it with unique functionality. Please consider the short list of PostgreSQL Maestro 6.5 main features below:
| • | support for all PostgreSQL server versions from 7.3 to 8.1: including dollar-quotation, connection limits, and so on; |
| • | easy database management: the conception of database profiles gives you the opportunity to connect to databases in one touch and work with the selected databases only. Of course, it is also possible to create or drop a database; |
| • | powerful database object management: the application includes a number of handy wizards and editors, database explorer allowing you to perform all necessary operations upon databases and their objects (creating new database objects, editing existing ones as well as duplicating and renaming objects); |
| • | user-friendly interface: easy-to-use GUI provided by PostgreSQL Maestro will make your PostgreSQL database management and administration easy and efficient; data can be viewed either as tables or as summary cards; Object Manager and Object Explorerallow you to fulfill complex data manipulation tasks irrespective of your personal level of competence in this or that server feature; |
| • | building and executing queries: PostgreSQL Maestro provides powerful tools which allow you either to edit query text directly with syntax highlighting and code completion or to build a query diagram visually selecting tables and fields, setting links between tables and so on; |
| • | powerful security management: implemented a number of powerful editors, which allow you to manage Firebird users and their privileges as easy as it can be, even if you are not a skilled Firebird administrator; |
| • | powerful BLOB viewer/editor: opportunity to view and edit the content of the BLOB fields in various representations such as hexadecimal dump, plain text, graphical image or HTML page; graphical representation of BLOB data supports the following image formats: BMP, Windows metafile, JPEG, GIF and PNG; |
| • | data export module: exporting data from PostgreSQL tables and queries to files of the 14 most popular formats including MS Excel, MS Access, MS Word, HTML, XML, PDF; |
| • | data import module: importing data to PostgreSQL tables from files of the following formats: MS Excel, MS Access, XML, DBF, TXT and CSV. |
The list of features implemented in the software product can be continued. PostgreSQL Maestro allows you, for example, to create a new table in a few mouse clicks, to get SQL dump of your metadata and data (even without knowing the syntax), to get a high-quality printable report for your database, to execute any SQL script, to copy a table from one database to another by drag-n-drop operations or by pressing Ctrl+C/Ctrl+V hot key combinations and a lot of other features.
We hope that you will enjoy working with your PostgreSQL server with our new software!
| Prev |
Return to chapter overview | Next |
