The latest version of PgManage has been released! PgManage 1.2 Release introduces new features and improvements, and addresses several bugs reported since the last release. Please update to the latest version at your earliest convenience.
New features:
- Implemented support for adding/changing table indexes in Schema Editor
- Implemented Postgres role editor
- Added SQL error annotations in the query editor
- Significant code completion improvements: added context-aware schema, table, view, column and function completions
- Added support for Postgres byte array display query results data grid
Bugs fixed:
- Connection manager where "Discard changes" confirmation was shown after clicking "Test Connection" button
- Fixed where PgManage was trying to restore tabs for closed database workspaces
- Fixed where "Discard changes" confirmation appeared after running "Explain/Analyze" and then closing the DB workspace
- Fall back to unencrypted SSH key when no password is provided (thanks u/El-Virus)
- Use a user-provided database password instead of a previously stored one when "Test connection" is clicked in the connection manager
- Fixed a bug when backup/restore background job info was potentially accessible by other pgmanage user accounts
- Fixed a bug when redundant database back-end was instantiated when requesting database auto-completion metadata
- Fixed a rare race condition when opening a new database workspace
- Rearranged parts of the DROP INDEX query template to make it runnable without needing extra modifications by the user
- Fixed a bug in the Monitoring Dashboard when the "Refresh all widgets" button was doing nothing after deleting all and restoring some monitoring widgets
- Fixed a bug in the connection manager where "Discard changes" confirmation was shown for connections with passwords auto-filled by the browser
- Fixed a bug in the schema editor where the "DEFAULT" part of the column definition was rendered regardless of the presence of the column default value
UI/UX Improvements:
- New application startup screen
- Improved naming for exported CSV/XLS files
Other changes:
- Django updated from 4.2.11 to 4.2.16
- cryptography updated from 36.0.2 to 41.0.7
- pymysql updated from 1.0.x to 1.1.1
- psycopg2 updated from 2.9.5 to 2.9.9
- oracledb updated from 1.3.1 to 2.2.1
- Other occurrences of highlighted selection in the query editor are now case-insensitive
- Implemented custom SESSION_SERIALIZER for improved session handling security
- Eager-load QueryTab components when opening database workspace for improved app responsiveness
- Added uniqueness validation to connection group names
- Removed unnecessary files from the Windows build of PgManage
- Changed default value for CSV separator setting
- Improved database back-end cleanup when no keep-alive requests come from the front-end
- don't show an error toast when running Explain/Analyze if PEV2 can display these errors by itself
Downloads & Sources are available here:
Contributions and feedback are welcome!
Want to receive blog updates straight to your inbox? Subscribe to the Command Prompt Substack here.