80 Commits

Author SHA1 Message Date
Khushboo Vashi
b02e210c68 Python v3.8 does not support parenthesized context expressions. 2025-02-06 14:42:29 +05:30
Akshay Joshi
228156d0b6 1) Fixed an issue where the ad-hoc server with SSH Tunnel repeatedly prompted for the password.
2) Fixed an issue where the SSH Tunnel password was not being saved in the External Database if its encoded length exceeded 64 characters.
3) 'Save Password' check box should be hidden for SSH Tunnel password on the Welcome page.
2025-01-29 19:43:23 +05:30
Akshay Joshi
964d211260 Copyright updated for 2025 2025-01-01 11:26:42 +05:30
Akshay Joshi
fe6e21a08b Enhanced pgAdmin 4 with support for Workspace layouts. #7708 2024-12-16 14:52:56 +05:30
Aditya Toshniwal
bd2a484c2f Added support for adding tags on a server node. #8192 2024-12-05 12:18:26 +05:30
Anil Sahoo
3706c3126a Fixed migration failure while using external database. #7556 2024-06-17 18:12:31 +05:30
Anil Sahoo
6690b16f8a Added support for executing the query at the cursor position in the query tool. #6841 2024-05-27 16:11:59 +05:30
Rohit Bhati
4e3ec91d23 Added support for the 'Add to macros' feature and fixed various usability issues. #4735 2024-05-24 15:30:31 +05:30
Akshay Joshi
740ce15bd7 Update copyright notices for 2024 2024-01-01 14:13:48 +05:30
Akshay Joshi
a22b2a6074 Added keep-alive support for SSH sessions when connecting to a PostgreSQL server via an SSH tunnel. #7016 2023-12-19 16:16:03 +05:30
Aditya Toshniwal
c4a5f8d707 Fix a crash issue occurring when debugging a function with arguments when using pgAdmin with external config database. #6904 2023-11-15 17:42:58 +05:30
Anil Sahoo
695c008245 Remove the max length of 255 from password exec command in server configuration dialog. #6877 2023-11-06 11:55:29 +05:30
Aditya Toshniwal
10adb6a11b Add support for setting prepare threshold in server connection. #6285 2023-10-12 16:54:06 +05:30
Aditya Toshniwal
fc411bfc49 Allow setting custom username for shared servers, with default as username of server being shared. #6229 2023-10-11 12:56:06 +05:30
Akshay Joshi
f43b3b0ce5 After upgrading SQLAlchemy, use _asdict().items() instead of .items(). 2023-03-20 16:48:12 +05:30
Akshay Joshi
3ca7bb854f Fixed an issue where migration on external database is not working. #5941 2023-03-20 16:18:59 +05:30
Aditya Toshniwal
292d76b39e Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions. #5901
- Update Flask, Flask-SQLAlchemy, Flask-Babel, Flask-Security-Too, Flask-SocketIO, pytz, psutil, SQLAlchemy, bcrypt, cryptography, eventlet, Authlib, requests python packages
- Remove pinned dnspython, Werkzeug packages from requirements.txt
2023-03-15 11:57:16 +05:30
Akshay Joshi
3c56c0e4b7 Revert "Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions. #5901"
This reverts commit 31818bb67a.
2023-03-09 16:53:43 +05:30
Aditya Toshniwal
31818bb67a Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions. #5901
Remove the python version check from the requirements.txt.
2023-03-08 18:26:51 +05:30
Akshay Joshi
9b7a38ac52 Ensure that the database migration does not fail with a NoSuchTableError exception. #5870 2023-03-06 15:41:02 +05:30
Akshay Joshi
103cf0eba5 Fixed a migration issue for the external database. #4728 2023-01-31 15:53:16 +05:30
Akshay Joshi
ea3dffe78d 1) Fixed an issue where Query history is not getting loaded with an external database. #5781
2) Change the datatype of the value column of the setting table to text instead of a string. #5746
3) Fixed an issue where the key 'passfile' is not found. #4728
2023-01-30 15:38:36 +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
Akshay Joshi
749138791a 1) Fixed an issue where the 'save_password' column threw an error for the shared server when using an external database. #5535
2) Fixed integrity error while removing server when using an external database.
3) Remove the length of the password column of the server and the shared server table.
2022-11-16 14:01:55 +05:30
Akshay Joshi
0384f55de1 Remove check constraint from user table as it's data type is Boolean. 2022-10-20 18:25:21 +05:30
Akshay Joshi
964c7b1d28 Fixed API test cases. 2022-10-20 17:47:27 +05:30
Akshay Joshi
e17c50d304 Added support for storing configurations of pgAdmin in an external database. #1832 2022-10-20 16:18:41 +05:30
aelgn
a62fc2fbff Added support for IAM token based authentication for AWS RDS or Azure DB. #3491 2022-10-15 14:49:04 +05:30
Khushboo Vashi
e61a1045f5 Added capability to deploy PostgreSQL servers on Amazon RDS. Fixes #7177 2022-02-14 12:13:48 +05:30
Akshay Joshi
2786f7ac5a Update copyright notices for 2022 2022-01-04 13:54:25 +05:30
Akshay Joshi
5ae1036a24 Corrected the down_version in migration file. 2021-12-02 18:35:08 +05:30
Ashesh Vashi
36c9eb3dfd Added support for Two-factor authentication for improving security. Fixes #6543 2021-12-02 16:47:18 +05:30
Pradip Parkale
fe096116be Change the logic to rename the table in the SQLite database to fix the migration issue.
refs #7031
2021-12-02 16:25:59 +05:30
Pradip Parkale
6b613fdf36 Fixed an issue where SQLite database definition is wrong because the USER_ID FK
references the table user_old which is not available.

Fixes #7031
2021-12-01 17:24:41 +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
Florian Sabonchi
a3d3c74e67 Ensure that the login account should be locked after N number of attempts. N is configurable using the 'MAX_LOGIN_ATTEMPTS' parameter. Fixes #6337 2021-07-22 12:24:43 +05:30
Akshay Joshi
eb658a75ab Modified the bulk insert logic to the user table in the migration file. 2021-07-20 13:27:03 +05:30
Aditya Toshniwal
6e42d9113b Fixed user password-related issues.
refs #6225
2021-06-10 22:56:38 +05:30
Aditya Toshniwal
065a3aa2f5 Updated Flask-Security-Too to the latest v4. Fixes #6225 2021-06-06 13:58:06 +05:30
Khushboo Vashi
72f3730c34 Added support to connect PostgreSQL servers via Kerberos authentication. Fixes #6158 2021-05-03 16:10:45 +05:30
Pradip Parkale
8ae8fea6d2 Ensure that Backup and Restore should work on shared servers as some cases were failing due to initial changes.
Fixes #6385
2021-04-22 17:29:04 +05:30
Nikhil Mohite
1a756efe82 Fixed an issue where Non-admin user is unable to view shared server created using service. Fixes #6075 2021-01-13 12:18:16 +05:30
Akshay Joshi
b372f08a59 Update copyright notices for 2021 2021-01-04 15:34:45 +05:30
Nikhil Mohite
2793747d3c 1) Added support for dynamic tab size. Fixes #4231
2) Fixed an issue where a long file name is not visible on the process watcher dialog. Fixes #5950
2020-11-04 17:45:28 +05:30
Khushboo Vashi
228d4bb321 Fixed SQLAlchemy operation error with the boolean value as true/false for Python version < 3.7 2020-10-01 13:29:46 +05:30
Akshay Joshi
1c70a43b91 Fixed code smells 'Define a constant instead of duplicating this literal' reported by SonarQube. 2020-09-29 15:08:14 +05:30
Khushboo Vashi
4616a74029 Added Macro support. Fixes #1402 2020-09-28 15:26:45 +05:30