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

Subscribe to our news:
Partners
Testimonials
Steve Morton: "First let me thank you for making this application Free. Best deal I have ever see for what it does".
Grey: "We're a two-person company, it's just me an my wife. I'm the technical guru, and she handles the business operations. I have to know a lot about MySQL, but that's much too technical for her. I have frequently had to setup CGI scripts (I code in Perl) so she can manage some of our tables (suppliers, manufacturers, etc).

I discovered PHP Generator a couple of days ago, tried the free version,and within a few hours I had purchased the Pro version (as well as SQL Maestro for MySQL).

Today I am completing the conversion of the last of my custom table managers to PHP Generator. This is eliminating several thousand lines of code that I don't have to support any more!

Thanks for this fantastic product".

More

Add your opinion

SQL Maestro Group / News / All company 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