Postgres and Open Source Experts

Purchase Enterprise License

PgManage 1.4 Has Been Released!

This version adds MS SQL Server Support, Faster Interface Navigation, Spreadsheet‑like Data Grids & More!

Check our blog post dedicated to this release for more details and insights on the thought process behind new features.

• New features:
  • Implemented support for MS SQL Server databases
  • Implemented keyboard navigation in the 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 PostgreSQL server log viewer #658
  • Implemented pan, zoom, and layout save/restore in the ERD tab, added a dedicated toolbar for pan/zoom #659
  • Implemented support for mDNS resolving when connecting to the 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 an Oracle database #738
  • Fixed error when opening Oracle database connections in desktop app builds #767
  • Fixed the 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 the DB connection string
  • Fixed race condition resulting in intermittent Schema Editor errors after modifying a 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 the 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 the 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 the Oracle DB sessions tab
  • Enlarged the clickable area of the DB tree node expand/collapse icon to make it easier to click
  • Added SQL formatting for DDL tab content when working with SQLite3 databases
  • Don't immediately show the loader overlay in the 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 PostgreSQL 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 the psql console command list

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