Postgres and Open Source Experts

PgManage 1.3 has been released

• New features:
  
  • new visual data filtering UI in data editor
  • new dashboard configuration UI with support for reordering of dashboard widgets
  • new dashboard widget layout with cleaner and easier-to-read UI
  • new implementation of dashboard graphs with improved readability and better handling of large amounts of data
  • extend MySQL dashboard to support MariaDB
  • added support for exporting query results in JSON format
  • added support for code folding in query editor
  • set backup type based on output file extension, set extension base on output type
  • added Postgres documentation links to SQL templates for quicker docs access
  • added column alias support in autocomplete engine
  • added advanced clipboard copy of query result data (copy cells as CSV, JSON or Markdown)
  • added support for running EXPLAIN/ANALYZE on a selected part of the query
  • added "copy to editor" feature for DDL tab and "Generated SQL" preview box components
  • new cell data viewer modal with syntax highlighting and support different data types
  • added support for PostgreSQL 17
    
    
• Bugs fixed:
  • removed unnecessary entries from info.plist on Mac builds which associated Pgmanage with some file extensions
  • added logic for handing mutually-exclusive --create and --single-transaction options in Database Restore tab
  • fixed incorrect colors for disabled inputs in dark theme
  • don't allow multiple monitoring dashboard within the same DB workspace
  • fixed Postgresql Alter View template
  • fixed autocomplete switch colors in dark theme
  • fixed DB object tree node data not loading in some cases
  • prevent starting duplicate backup/restore jobs
  • fixed empty SSL option appearing in connection form when connection type is changed
    
    
• UI/UX Improvements:
  • improved console tab size change handling
  • improved readability of Backends tab UI
  • added data loading/saving indication for data editor tab
  • added support for keyboard navigation for searchable drop-down lists
  • improved layout of Server Configuration tab toolbar
  • show query result messages for all supported databases
  • improved date-range picker in command history modals
  • improved command history modal layout
  • add support for live update of widget font size and colors when theme or font size is changed in app settings
  • improved data editor grid rendering performance when working with large number of rows
  • joined Run and Run selection buttons into a single block, moved autocommit option in its drop-down menu (#507)
  • backup/restore jobs are now ordered by job start time, from newest to oldest
  • the View Content data grid context menu is now disabled when multiple cells are selected
  • long backup/restore file paths are now truncated in the middle to improve readability
  • added "Discard Changes" warning when closing Data Editor
  • improved data grid cell rendering performance for cells containing large amounts of data
    

See the full change log on Github Release Page

Discovered a bug? Have a feature request? Want to contribute?

Feel free to create an issue or a Pull Request on GitHub

The latest version of PgManage documentation is available on ReadTheDocs