Re: Forcing autocomplete on keypress - Mailing list pgadmin-support

From Aditya Toshniwal
Subject Re: Forcing autocomplete on keypress
Date
Msg-id CAM9w-_=xVN4QCgDshaL2mQrz-7LSBJotKqru-=fp5haVdiu=8g@mail.gmail.com
Whole thread Raw
In response to Forcing autocomplete on keypress  (Zac Warham <cazwarham@hotmail.com>)
List pgadmin-support
Hi Zac,

You can raise a feature request here https://github.com/pgadmin-org/pgadmin4/issues/new if you have any improvement suggestions.

On Wed, Dec 4, 2024 at 10:13 AM Zac Warham <cazwarham@hotmail.com> wrote:
Thank you for the advice Aditya. I managed to get it working by adding an extra line in my docker entrypoint although it does slow the process down a little when launching the container

python3 /usr/local/lib/python3.10/dist-packages/pgadmin4/setup.py load-servers "/usr/local/lib/python3.10/dist-packages/pgadmin4/servers.json"
python3 /usr/local/lib/python3.10/dist-packages/pgadmin4/setup.py set-prefs pgadmin4@pgadmin.org sqleditor:auto_completion:autocomplete_on_key_press=true

My concerns with overriding the preference file path was that I then have to manage the ownership permissions of the file that is created which is tedious as we run various different users in production.

Thank you for pointing me in the right direction though!

From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: Tuesday, 3 December 2024 7:53 PM
To: Zac Warham <cazwarham@hotmail.com>
Cc: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: Forcing autocomplete on keypress
 
Hi Zac,

You can use PGADMIN_PREFERENCES_JSON_FILE in https://www.pgadmin.org/docs/pgadmin4/8.13/container_deployment.html

On Wed, Dec 4, 2024 at 12:45 AM Zac Warham <cazwarham@hotmail.com> wrote:
We have a docker setup for pgadmin and we want to force autocomplete on keypress at launch (not through the preferences) using an environment variable or config of some sort. I tried modifying the file at https://github.com/pgadmin-org/pgadmin4/blob/master/web/pgadmin/tools/sqleditor/utils/query_tool_preferences.py#L792 and replacing False with True and this works but then breaks postgres in other ways. Is there a proper way of doing this beyond modifying this file?



--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"

pgadmin-support by date:

Previous
From: Aditya Toshniwal
Date:
Subject: Re: Version 8.13 now encapsulates any copy and paste value in double quotes - how to remove that?
Next
From: Calle Hedberg
Date:
Subject: Re: Version 8.13 now encapsulates any copy and paste value in double quotes - how to remove that?