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

Subscribe to our news:
Partners
Testimonials
Chris Passion: "I tried 3 different programs before yours and none would be so handy and helpful. PostgreSQL Maestro works great and couldn't be easier to install".
Simon Pills: "Someone finally invented an intuitively used and easily customized PostgreSQL database administration tool! Keep up the good work. I will be in touch. I am able to do this horrendous work because your software enabled me to create a new database with all necessary objects in several minutes! I am sure that I have found what I really need".

More

Add your opinion

SQL Maestro Group / Products / PostgreSQL / PostgreSQL Maestro / News / PostgreSQL Maestro 14.5 released

PostgreSQL Maestro 14.5 released

May 22, 2014

Prev Next

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

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

Server management extensions

  • This version of the software has been successfully tested with all the modern database server versions up to PostgreSQL 9.4 Beta 1 (the latest version available at the moment). We have also implemented support for some 9.x new features:
    • Support for materialized views (PostgreSQL 9.3+) has been added. A materialized view is a database object that contains the results of a query. It uses a query to fetch its data like a view, but this data is stored like a common table. This feature is most useful in data warehousing scenarios, where frequent queries of the actual base tables can be extremely expensive.

      Materialized View Editor: propertiesPicture 1. Materialized View Editor: properties

      A materialized view is refreshed with updated data by running once again the query it uses for its projection. To refresh a materialized view with data from master tables, use the popup menu of the editor tab or the corresponding node at the Explorer tree.

      Refreshing Materialized ViewsPicture 2. Refreshing Materialized Views

      The data refresh can also be used to truncate the data of the relation by running it with the enabled Leave in unscannable state option.

      Refresh Materialized View DialogPicture 3. Refresh Materialized View Dialog

    • Current version allows you to use built-in range data types as well as to create your own ones (PostgreSQL 9.2+). A range data type stores a lower and upper bound belonging to its base data type. It supports operations like contains, overlaps, and intersection.

      Create Range Type WizardPicture 4. Create Range Type Wizard

      You can disable the refresh of range types if you don't use them to speed us the initial database connection. Values of these types will come correctly irrespective of value of this option.

      Database refresh optionsPicture 5. Database refresh options

    • Support for the new jsonb "binary json" type (PostgreSQL 9.4). The new format accepts exactly the same data as the json type. However, it is stored in a format that does not require reparsing the original text in order to process it, making it much more suitable for indexing and other operations.
    • Support for smallserial data type (PostgreSQL 9.2+) has been added. This type is used for creating unique identifier smallint columns.
  • Function Editor: management of existing functions has been substantially improved. Starting from this version among other things, it is possible to:
    • add, drop, rename, and reorder parameters;
    • change parameter data types and scopes;
    • set, modify and remove parameter default values;
    • change function return kind (single value, set of values, table) and return data type;
    • add, drop, rename and reorder output columns (for functions returning tables).

    All these commands are available from the popup menu of the Parameters tab or with Ins, Del, F2 and Enter shortcuts.

    Function Editor: work with parametersPicture 6. Function Editor: work with parameters

    All the modifications are applied to the function with the Compile Function link at the Navigation bar. To make changes of an existing function you must be the owner of this function.

    Parameter EditorPicture 7. Parameter Editor

  • Now it's allowed to generate updatable views for your tables automatically. Moreover, the Insert, Update, and Delete operations can be enabled or disabled at your choice. It is possible to create a view for a single table or for several tables at once (even for all the tables in the database). To accomplish these tasks, use the popup menu of the corresponding node at the Explorer tree and the Main Menu | Object | Generate updatable views accordingly.

    Updatable views generationPicture 8. Updatable views generation

  • Starting from this version SQL Editor displays result sets for DML statements with the RETURNING clause.

    SQL Editor: executing a DML statement with RETURNING clausePicture 9. SQL Editor: executing a DML statement with RETURNING clause

  • Now it's possible to use view column's default values to be substituted into any INSERT or UPDATE command whose target is the view, before applying any rules or triggers for the view.

Interface improvements:

  • Starting with this version the warning appears on creating a table without a primary key.

    Warning messagePicture 10. Warning message

  • Data Import features:
    • Starting with this version it's possible to import data from several files at a time. To import data from multiple files with the same structure, set the mask of the file names to the corresponding field. To see the list of matching files, use with the button on the right.

      Import data from multiple filesPicture 11. Import data from multiple files

    • The Column Builder for text files with fixed column width has been redesigned. Now to set the correspondence between table columns and areas of a text file, you can either input offset and width for each column directly into the controls, or define these values by clicking the left mouse button in the right area of the tool.

      Column BuilderPicture 12. Column Builder for text files with fixed column width

    • Now it's possible to add current timestamp to the log file name using the %ts:TIMESTAMP_FORMAT% string template. Examples of valid datetime formats are: 'YYYY-MM-DD', 'YYYY-MM-DD-HH24-MI', 'YYYY-MM-DD-HH24-MI-SS', and so on.
    • Now each time you start the wizard to import data to a table it stores all the options as them were set on the previous session of working with this table.
  • Data Export: Support for Json file format has been implemented.

    Data Export to JSONPicture 13. Data Export to JSON

  • Data Grid: to reset all grid settings to defaults, open the Data tab when holding the Ctrl key.

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