PGManage Files

📢 While working on this release, we focused on adding support for MS SQL Server and improving the UX for frequently performed actions such as navigating the DB tree. See our blog post dedicated to this release on the CommandPrompt website: https://www.commandprompt.com/blog/pgmanage-14-fast-intuitive-with-sql-server-support/

Release Notes

• New features:

  • implemented support for MS SQL Server databases
  • implemented keyboard navigation in Data Editor grid #736
  • implemented support for partial/range selection in data grids for selective copying and other operations #752
  • implemented a dedicated DB object drop/deletion dialog to replace template based workflow #734
  • implemented "quick search/jump to" feature in DB object tree for quicker navigation #667
  • implemented "pin database" feature for quicker navigation #237
  • implemented postgres server log viewer #658
  • implemented pan, zoom and layout save/restore in ERD tab, added a dedicated toolbar for pan/zoom #659
  • implemented support for mDNS resolving when connecting to database server #673
  • implemented redraw of customized dashboard widgets when widget settings change #626
  • implemented display of table index details in DDL tab for MariaDB and MySQL #704
  • implemented foreign key support in schema editor #251

• Bugs fixed:

  • relaxed custom widget validation rules to allow blank chart generation code #720
  • fixed an error in Data Editor when saving multiple rows in Oracle #737
  • fixed an error when running multiple SQL statements against Oracle database #738
  • fixed error when opening Oracle database connections in desktop app builds #767
  • fixed command history modal not displaying the most recent query #740
  • fixed the issue where pgmanage tabs could become unresponsive if the network connection stalls
  • don't show Explain/Explain Selection features when working with non-postgres databases
  • properly handle null passwords when building DB connection string
  • fixed race condition resulting in intermittent Schema Editor errors after modifying table in MySQL or MariaDB #755
  • fixed incorrect default_value in get_table_definition* API endpoints #754
  • fixed a bug in Schema Editor where "touched" column default values cannot be reverted to their initial state #757
  • fixed missing color markers on altered table rows in Data Editor if Clipboard Copy command was used on them before #765

• UI/UX Improvements:

  • reorganized DB tree context menus #668
  • improved postgres notice display in Query Tab: added color labels and refined notice formatting #725
  • improved nested context menu navigation when moving cursor from parent to child menu
  • improved stylesheets for snippets panel tab
  • right-justify integers and numerics in query results data grid #681
  • improved formatting of DB error toasts and dialogs #739
  • tweaked app scrollbar sizes to make them easier to grab
  • removed unnecessary confirmation when closing DB workspaces, ask for confirmation only if there's unsaved data
  • improved formatting and readability of Oracle DB sessions tab
  • enlarged clickable area of DB tree node expand/collapse icon to make it easier to click
  • added SQL formatting for DDL tab content when working SQLite3 databases
  • don't immediately show the loader overlay in DDL/Properties tab when changing selected DB object

• Other Changes

  • updated python from 3.9.13 to 3.11.13
  • updated cherrypy from 18.1.1 to 18.10.0
  • updated psycopg2 from 2.9.10 to 2.9.11
  • extracted app SQL templates into separate modules
  • removed redundant curly braces from postgres SQL templates
  • use user id instead of user username for process log file names
  • removed unnecessary blank lines between process log records
  • use native prettytable features when generating psql console command list