Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Andrew Maclean: "I am really quite impressed with the software. You and your people are doing a wonderful job. I actually have spent a while researching PostgreSQL admin/code generators and yours seems to fit our needs nicely. Your interface is beautiful".
Shafiq Far: "Just wanted to let you know that I think the SQL Maestro for Postgres is excellent. We've tried a variety over the past few years and none are even close to yours. Well done".

More

Add your opinion

Customers
SQL Maestro Group / Products / PostgreSQL / News / PostgreSQL Maestro 10.4 released

PostgreSQL Maestro 10.4 released

Apr 20, 2010

Prev Next

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

Please consider the list of new features implemented in this version since last official release:

Server management extensions

  • Starting with this version it is possible to connect to a remote server via SSH tunnel using a key-based authentication (in addition to the password-based authentication supported in the previous versions). To establish a remote connection in this way, you have to provide a private key (either in ssh.com or OpenSSH formats) and (optionally) a passphrase.

    Since now our software supports both SSH-1 and SSH-2 protocols (whereas all the previous versions supported only SSH-1).

    SSH tunnelingPicture 1. Connect to a remote server: SSH tunnel

  • This version of the software has been successfully tested with Postgres Plus 8.x (both standard and advanced server).
  • Support for ascending and descending indexes and NULLS FIRST/LAST has been added (PostgreSQL 8.3+).

    Index EditorPicture 2. Index Editor

  • SQL Script Editor: notices and warning messages generated by the server are now bound to source SQL statements. Also displaying of such messages now can be disabled.
  • Support for rules containing several SQL statements has been implemented.
  • Starting with this version PostgreSQL Maestro can execute SQL scripts containing the COPY FROM STDIN statement (like psql does).
  • The Script Runner window can now be invoked directly from the Tools menu. Also the productivity of this tool has been significantly improved.

    Script RunnerPicture 3. Script Runner

Interface improvements:

  • Database profile management improvements:
    • Starting with this version it is possible to reorder database groups in the Explorer Tree as well as reorder databases from the same group. You can also sort database groups and databases in an alphabetical order.
    • Now all the database profiles related to the same group may be deleted at once.
    • The Rename Database Profile command has been added to the popup menu. Use this command to rename a profile without opening its editor.
  • Data Grid features the following things:
    • Multi-column sorting has been implemented. To sort data on multiple columns, use the Advanced sort command from the grid's header popup menu.

      Multi-column sortingPicture 4. Data Grid: multiple column sorting

    • Starting with this version the number of grouped records is displayed for the group's header.

      Number of grouped recordsPicture 5. Data Grid: number of grouped records

  • SQL Editor: the Go to Line command has been added to the popup menu (Ctrl+G shortcut). Also field data types are now displayed in the Code completion window.

    Code completionPicture 6. SQL Editor: code completion

  • BLOB Viewer/Editor: starting with this version it's possible to customize PHP syntax highlighting for the text representation of BLOBs.
  • Database Designer: a possibility to select objects with Ctrl has been implemented.

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


Related links:

PostgreSQL Maestro home page
Download PostgreSQL Maestro
Get PostgreSQL Maestro Tour
Purchase your license of PostgreSQL Maestro today!
Prev Next
Back to news archive