PGManage Files

Release Notes

• New features:
• pgmanage now uses database-specific syntax highlighting rules in SQL editors depending on the database type
• added support for displaying column data types in query results data grid
• columns in query results data grid can now be minimized/maximized by double-clicking the column header
• switchable data grid layouts in query tabs: adaptive, compact and fit-content can be selected by clicking the ellipsis icon on the top-left corner of the grid
• existing DB connection can now be cloned in connection manager dialog
• the size of the next loaded data chunk can now be selected when using "fetch-more" feature for large query results
• added multi-statement queries support for SQlite3
• database connections can now have a color label to make it easier to differentiate between different environments

• scram-sha256 password hashing is now used when changing Postgres role passwords

• Major Bugs fixed:

• fixed documentation urls in Postgres DB object tree context menus
• disable connection test button when test is in progress
• fixed 'fetch all records' feature when running queries on non-postgres databases
• fixed reversed DB object tree node ordering for inherited tables, foreign tables, sequences views, materialized views, trigger functions, event triggers, procedures, aggregates, types, fdw and tablespaces
• fixed incorrect count of table partitions displayed in DB object tree when tree is refreshed
• fixed Postgres unique indexes not being displayed in DDL tab
• fixed live theme switching issues for some modal dialogs
• improved escaping of HTML characters in data grid cells to prevent potential XSS
• fixes issue when query execution timer may not be stopped when user cancels the query
• fixed data saving issues in table data editor when using a database other than the one specified in DB connection properties (databases other than Postgres were affected)
• fixed data editor issues when user tried to apply multiple row changes at once on SQlite3
• improved back-end query thread termination when long-running query is cancelled by the user
• fixed long polling request clean-up when user closes application tabs
• fixed memory leak when working with DB console or SSH terminals
• fixed updating last used date for SSH connections
• fixed intermittent pgmanage startup issues on Windows platform

• fixed query results data export when query contains explain or explain analyze keywords

• UI/UX Improvements:

• 'fetch all records' is now also supported DB console tabs
• removed unnecessary schema name prefixes from table partition names in DB object tree
• added warning about unsaved changes in Postgres Seever configuration tab before close
• added confirmation when deleting configuration change histore records in Postgres Server configuration tab
• added support for showing newline characters in query results data grid cells
• added support for showing null and blank values in query results data grid cells
• data grid is no longer hidden for queries that return 0 rows
• added visual hints for column resize handles in data grid headers
• improved DB console and SSH terminal performance when displaying large amounts of text
• significantly improved performance of query result data grids when working with large amounts of data

• it is now possible to reuse a query from the history dialog by double clicking on the correspoding query cell

• Other changes

• sshtunnel bumped from 0.1.5 to 0.4.0
• optimized front-end imports to reduce js bundle size
• optimized peformance of several back-end queries
• project migrated from bootstrap 4 to bootstrap 5
• pev2 bumped from 1.8 to 1.11
• legacy code clean-up
• removed support for EOL Postgres versions
• added support for creating debug .appimage builds
• added support for masking sensitive data in error logs
• project migrated from django 3.2 to django 4.2
• bumped xterm.js from 5.2 to 5.5