PGManage Files

Release Notes

• New features:

  • new visual data filtering UI in data editor (#483)
  • new monitoring widget management UI with support for reordering of dashboard widgets (#617)
  • new widget component layout with cleaner and easier to read UI (#618)
  • new implementation of dashboard widget graphs with improved readability and better handling of large amounts of data points (#605)
  • extend Mysql monitoring widgets to support Mariadb
  • added support for exporting query results in JSON format
  • added support for code folding in SQL editor
  • set backup type based on output file extension, set extension base on output type (#531)
  • add Postgres documentation links to SQL templates for quicker docs access
  • add column alias support in autocomplete engine
  • add advanced clipboard copy for data grids (#217)
  • added support for running EXPLAIN on a selected part of the query (#533)
  • new cell data viewer modal with syntax highlighting and support different data types
  • added support for Postgres 17

• Bugs fixed:

  • removed unnecessary entries from info.plist on Mac builds which associated Pgmanage with some file extensions (#620)
  • 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 (#572)
  • fixed empty SSL option appearing in connection form when connection type is changed (#674)

• 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 auto-commit 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

• Other changes

  • cleaned up legacy/unused sass styles
  • Django updated from 4.2.17 to 4.2.19
  • openpyxl updated from 3.0.10 to 3.1.3
  • restrictedpython updated from 6.0 to 7.4
  • psutil updated from 5.9.8 to 6.1.1
  • oracledb updated from 2.2.1 to 2.5.1
  • sqlparse update from 0.5.1 to 0.5.3
  • improved front-end error logging
  • ace-editor updated from 1.36.2 to 1.39.1
  • axios updated from 1.7.7 to 1.8.4
  • pev2 update from 1.12.1 to 1.14.0
  • splitpanes updated from 3.1.5 to 3.2
  • vue updated from 3.5.4 to 3.5.13
  • cleaned up back-end code
  • randomize start time of monitoring dashboard widgets data polling to reduce DB usage spikes
  • execute schema editor requests via long polling
  • don't add information_schema and pg_catalog data to autocomplete engine