Yogesh Mahajan
51d3fe54f3
Ensure proper error message shown if any error occurs while restoring psql tool.
2025-06-27 13:35:24 +05:30
Yogesh Mahajan
68e559c613
Added support to preserve the workspace, query windows, and pgAdmin state during an abrupt shutdown or restart. #3319
2025-06-05 16:50:38 +05:30
Akshay Joshi
eece396b30
Fixed an issue where the PSQL tool would hang when the database encoding was set to SQL_ASCII and certain commands were executed.
2025-05-14 14:05:29 +05:30
Aditya Toshniwal
e8cb962890
Add Cache-Control no-cache,no-store,must-revalidate header to dynamically generated utils.js file. #3688
2025-04-16 11:23:35 +05:30
Akshay Joshi
af6c1a24cf
1) Upgraded Gunicorn to version 23.0.0 to address a security vulnerability present in Gunicorn.
...
2) Resolved an issue where an empty PSQL panel would open if the psql utility was not found in the binary path.
2025-04-01 16:33:50 +05:30
Akshay Joshi
1d3e0a4455
Revert the fix for #8006
2025-03-27 12:32:46 +05:30
Aditya Toshniwal
1216f075ce
Fixed an issue where PSQL tool is not opening if database name have HTML characters in the name. #8365
2025-01-17 14:53:24 +05:30
Akshay Joshi
964d211260
Copyright updated for 2025
2025-01-01 11:26:42 +05:30
Akshay Joshi
185e0f61e2
Close the connection and delete adhoc server if all it's Query tool and PSQL connections are closed.
2024-12-17 17:57:25 +05:30
Akshay Joshi
fe6e21a08b
Enhanced pgAdmin 4 with support for Workspace layouts. #7708
2024-12-16 14:52:56 +05:30
Aditya Toshniwal
3417186df7
Fix issues found while testing pagination changes. #1780
2024-11-07 18:02:39 +05:30
Aditya Toshniwal
772c6ecd84
Remove the dependency on python packages eventlet and greenlet. #8102
2024-11-07 16:45:18 +05:30
Khushboo Vashi
f4761f55f7
Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215). #7425
2024-04-29 13:41:02 +05:30
Yogesh Mahajan
102e0a9839
- Update MUI v4 to v5
...
- Remove the SCSS dependency completely and use MUI for theming.
- Update - date-fns, @date-io, notistack. Remove - popper.js, sass-loader.
- Cleanup webpack config.
- Port PSQL tool to use MUI themes instead of SCSS theme.
- Theme change will reflect realtime without refreshing pgAdmin.
2024-04-09 08:21:14 +05:30
Akshay Joshi
0e0cbc40b8
Fixed SonarQube code smell Replace the unused local variable with '_'.
2024-01-24 18:33:43 +05:30
Akshay Joshi
740ce15bd7
Update copyright notices for 2024
2024-01-01 14:13:48 +05:30
Akshay Joshi
2b736c18ab
Ensure that eventlet's subprocess should be used following the resolution of an issue with Python 3.12 by eventlet. #6926
2024-01-01 14:01:56 +05:30
Akshay Joshi
9eb7c1cbea
1) Ensure that eventlet's subprocess is used for Python versions up to 3.11 and await the issue resolution for Python versions 3.12.
...
2) Fixed unescape sequence for Python 3.12
2023-11-02 16:03:50 +05:30
Pravesh Sharma
5d70803d6d
1. Fixed an issue where psql was not taking the role used to connect in server properties. #5807
...
2. Corrected title in query tool connection link.
2023-11-02 11:00:27 +05:30
Akshay Joshi
46a8c1ad6a
Use Python's subprocess module instead of the eventlet's subprocess as it is not working with Python v3.12
2023-10-27 17:23:33 +05:30
Aditya Toshniwal
862f101772
Significant changes to use ReactJS extensively.
...
1. Replace the current layout library wcDocker with ReactJS based rc-dock. #6479
2. Have close buttons on individual panel tabs instead of common. #2821
3. Changes in the context menu on panel tabs - Add close, close all and close others menu items. #5394
4. Allow closing all the tabs, including SQL and Properties. #4733
5. Changes in docking behaviour of different tabs based on user requests and remove lock layout menu.
6. Fix an issue where the scroll position of panels was not remembered on Firefox. #2986
7. Reset layout now will not require page refresh and is done spontaneously.
8. Use the zustand store for storing preferences instead of plain JS objects. This will help reflecting preferences immediately.
9. The above fix incorrect format (no indent) of SQL stored functions/procedures. #6720
10. New version check is moved to an async request now instead of app start to improve startup performance.
11. Remove jQuery and Bootstrap completely.
12. Replace jasmine and karma test runner with jest. Migrate all the JS test cases to jest. This will save time in writing and debugging JS tests.
13. Other important code improvements and cleanup.
2023-10-23 17:43:17 +05:30
Akshay Joshi
75d14565e4
Fixed escape/unescape issues in Query Tool and PSQL.
2023-07-13 17:02:51 +05:30
Aditya Toshniwal
d6cddd8c29
Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS. #6295
2023-06-30 16:08:33 +05:30
Nikhil Mohite
be4db5ce04
Fixed an issue where PSQL tool not working if the database name have single and double quotes #6431
2023-06-13 12:04:26 +05:30
Nikhil Mohite
60265b306f
Fixed an issue where PSQL is not working if the PGUSER env variable is set and service file is used for server connection details. #6180
2023-04-26 11:14:10 +05:30
Akshay Joshi
a7cf698d09
1) Added support for setting PostgreSQL connection parameters. #4728
...
2) Fixed an issue where Kerberos authentication to the server is not imported/exported. #5732
3) Increase the length of the value column of the setting table. #5746
4) Upgrade Flask-Migrate to 4.0.0. #5525
2023-01-23 17:19:59 +05:30
Akshay Joshi
98184e5835
Update copyright notices for 2023
2023-01-02 11:53:55 +05:30
Mark Mayo
41508f7f67
python 3 updates
...
- Fix super() calls for python 3
- No need to inherit objects.
- No need for u at the start of strings
- Tidied up some brackets and f-strings too
2022-11-19 10:13:41 +05:30
Aditya Toshniwal
669a3a7673
Fixed SocketIO calls when pgAdmin 4 server is running from a sub directory. #5521
2022-11-15 13:51:12 +05:30
Nikhil Mohite
56fb24c24a
Fixed the .psqlrc issue for PSQL Tool. #5167
2022-09-29 12:29:32 +05:30
Nikhil Mohite
1b11a6cd4b
Fixed a couple of SonarQube issues.
2022-09-27 14:28:31 +05:30
Aditya Toshniwal
cb635f6706
Removing dynamic module loading and replacing it with static loading. Fixes #7492
...
Gets rid of all occurrences and usage of get_own_javascripts since it is no longer used.
2022-06-30 11:06:50 +05:30
Akshay Joshi
e38c38cd58
Fixed following SonarQube code smells:
...
1) Remove this useless assignment to a variable.
2) Remove the unused local variable.
2022-01-12 14:53:19 +05:30
Akshay Joshi
2786f7ac5a
Update copyright notices for 2022
2022-01-04 13:54:25 +05:30
Ashesh Vashi
36c9eb3dfd
Added support for Two-factor authentication for improving security. Fixes #6543
2021-12-02 16:47:18 +05:30
Akshay Joshi
d644b4f94e
1) Replace Flask-BabelEx with Flask-Babel. Fixes #6088
...
2) Upgrade Flask to version 2. Fixes #7010
2021-11-24 17:22:57 +05:30
Akshay Joshi
7d07770244
Reverting 'Two-factor authentication' support as it cause OSX and docker build failures.
...
This reverts commit 787a441343
.
2021-09-29 13:24:18 +05:30
Ashesh Vashi
787a441343
Added support for Two-factor authentication for improving security. Fixes #6543
2021-09-28 17:47:00 +05:30
Aditya Toshniwal
fbc6c30b62
Set PSQLRC and PSQL_HISTORY env vars to apt. user storage path in the server mode. Fixes #6691
2021-08-23 16:19:01 +05:30
Nikhil Mohite
6645625e6b
Fixed copy/paste issues for PSQL tool terminal. Fixes #6547 .
2021-06-24 20:00:52 +05:30
Nikhil Mohite
2549688bdf
1) Disable the PSQL feature entirely in server mode by default.
...
2) Remove the code that attempts to filter out commands.
refs #2341
2021-06-14 20:53:11 +05:30
Nikhil Mohite
09693d14d1
Added check if the Windows version is not supporting the ConPty or WinPty disable the PSQL for that version.
...
refs #2341
2021-06-14 11:47:40 +05:30
Nikhil Mohite
9f12747d9b
Added PSQL tool support for the Windows platform.
...
Fixed following issues:
1. If the database name contains escape characters then PSQL unable to connect.
2. If the user terminates the connection by typing the 'exit' command, PSQL
will show the connection termination msg.
Fixes #2341
2021-06-08 14:58:43 +05:30
Nikhil Mohite
e0eac875b6
Disable the PSQL tool for Windows, the 'fcntl' module is not working on Windows.
2021-06-01 20:04:43 +05:30
Rahul Shirsat
658a2de619
Fixed the issue of renaming the database by another user. Fixes #4203
2021-05-31 12:41:09 +05:30
Nikhil Mohite
3ddf941cd7
Added support to launch PSQL for the connected database server. Fixes #2341
2021-05-25 20:12:57 +05:30