Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Peter Robinson: "As a tech savvy company director, I wanted an inexpensive web based database application to manage all aspects of my business. As with most humans I find developing purely by CLI very hard and do not have the will or time to invest in improving my skills. I was looking to find a nice human friendly GUI to design and build my application, which is when I came across PHP Generator for MySQL.

Whilst you still need a great understanding of logic and a small amount of programming ability to get the specific results you require, I am very happy with the speed of progress I have been making with this invaluable tool.

With all the standard libraries included, this product makes normal requirements such as JavaScript form validation, lookup selectors, on click events, auto complete, detailed searches, multiformat exports, rss feeds and username security straight forward and quick.

Having any changes made via the GUI written to the web server at the click of a button makes testing out ideas quick and easy without fear of breaking your application.

To conclude, I couldn't find any other product on the market that came close to offering the amount of options this does, and I do hope that more products like this come out in the future, with the hope of eventually eradicating the need to program all together".

Rati Dzidziguri: "I'm working on development of ERP and CRM software and during the process of creation of those products I have tried lots of solutions by the only solution I would call as an user friendly professional and with many other epithets is MySQL Maestro and all Maestro toolkits".


Add your opinion

SQL Maestro Group / News / All company news / PostgreSQL Maestro 17.8

PostgreSQL Maestro 17.8 released

Aug 19, 2017

Prev Next
PostgreSQL Maestro SQL Maestro Group is happy to announce the release of PostgreSQL Maestro 17.8, 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:

New feature highlights:

  • This version of the software has been successfully tested with all the modern database server versions up to PostgreSQL 10 Beta 3 (the latest PostgreSQL version available at the moment).
  • Support for a number of PostgreSQL 10 new features has been implemented as follows:
    • Support for the native table partitioning has been added (PostgreSQL 10). Partitioning refers to splitting what is logically one large table into smaller physical pieces.

      To create a partitioned table, turn ON the appropriate checkbox, then specify the partitioning strategy (Range or List) and the partition key at the Properties tab of Create Table Wizard.

      Creating a partitioned tablePicture 1. Creating a partitioned table
      You can optionally create partitions together with the partitioned table. To do so, switch to the Partitions tab at the third wizard step, then add partitions using the appropriate command from the popup menu.
      Adding partitions to a newly created tablePicture 2. Adding partitions to a newly created table
      To add a new partition to an existing table, open Table Editor, switch to the Partitions tab, then use the "Create New Partition" command at the editor navigation bar or the corresponding item in the partition list's popup menu.
      Adding a partition to an existing tablePicture 3. Adding a partition to an existing table
    • Starting from this version it is possible to rename values of enumeration types.
      Renaming enum valuePicture 4. Renaming enum value
    • Support for identity columns has been added. To add an identity column to a table, open Field Editor and check the appropriate option.
      Field Editor: adding an identity columnPicture 5. Field Editor: adding an identity column
      To customize an identity column, click the "Identity options" link and specify the necessary properties in the modal window.
      Identity column optionsPicture 6. Identity column options
      In data grids and data input forms values of identity fields are filled automatically. The corresponding column headers are marked with the plus sign.
      Identity columns in data gridsPicture 7. Identity columns in data grids
    • Support for restrictive row level security policies has been implemented (the previous versions of PostgreSQL support only permissive policies). By creating restrictive policies, administrators can reduce the set of records which can be accessed as all restrictive policies must be passed for each record.
      Restrictive RLS policyPicture 8. Restrictive RLS policy
  • Starting from this version it is possible to specify a custom label and/or a font color for server nodes in the Database Explorer tree.
    Explorer Tree: custom labels and colorsPicture 9. Explorer Tree: custom labels and colors
    To change these properties, right-click a server node, select "Edit Server Properties" from the popup menu and provide the values you need in the modal dialog.
    Edit Server Properties dialogPicture 10. Edit Server Properties dialog
  • The Statistics tab has been added to the Edit Database Profile dialog. Here you can find such information as profile creation time, total number of connections, last connection time, and so on.
    Database Profile StatisticsPicture 11. Database Profile Statistics
  • Data Grid: now it is possible to copy the value of the selected cell to Clipboard using grid's popup menu or Ctrl+Shift+C shortcut.
    Data Grid: copy cell valuePicture 12. Data Grid: copy cell value
  • "Show special chars" and "Convert tabs to spaces" options have been added to the Editor settings.
    Editor OptionsPicture 13. Editor Options
  • Links to our social networks accounts have been added to the Quick Launch panel. As minor versions are announced only in our Facebook and Twitter, we would recommend you to follow us somewhere to stay informed.
    Follow us!Picture 14. Follow us!

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

Related links

Prev Next