3 ms·
When I got the update I looked through the settings and there appears to be no way to disable it. I do not want AI anywhere near my database. I only use it for
by chaz6 7mo ago
When I got the update I looked through the settings and there appears to be no way to disable it. I do not want AI anywhere near my database. I only use it for testing/staging at least so I should hopefully not have to worry about it wrecking production.
- forinti 7mo agoIt's there on the UI, but it doesn't do anything if it's not enabled.
- imjared 7mo agoThe docs suggest that you can set the default provider to "None" to disable AI features: https://www.pgadmin.org/docs/pgadmin4/9.13/preferences.html#the-ai-node https://www.pgadmin.org/docs/pgadmin4/9.13/preferences.html#...
- zenmac 7mo agoIt is nice that they have the default set to "None". However to have this feature in pgAmdin is as distraction from the project. If it is just calling API anyway, then I don't want to have this in my db admin tool. It also expose surface area of potential data leakage.
- bensyverson 7mo agoWorth pointing out that Postgres is perfectly usable without an admin dashboard at all
- deleted 7mo ago[deleted]
- smartbit 7mo agoNote: AI features must be enabled in the server configuration LLM_ENABLED = True in config.py for these preferences to be available.
- OptionOfT 7mo agoI did not enable this and yet I got the panel in the UI.
- deleted 7mo ago[deleted]
- ziml77 7mo agoWhat's the danger? It can see the schemas to help it generate the queries but it can't run anything on its own. Also you have to give the application credentials to an AI provider for the feature to work. So, you can just not do that.
- adamas 7mo agoThere is no need of potential dangers to not want to have non-deterministic features in an application.
- justinclift 7mo ago> What's the danger? Hallucinated ideas about what needs doing, what commands to run, etc. So, data that's no longer reliable (ie could be subtly changed), or even outright data loss.
- Natfan 7mo agojust don't accept bogus changes it suggests? this is why having a human in the loop is a very good idea
- justinclift 7mo agoYep, I fully agree. It'd be awesome if all (or even most?) of the users were immune to automation bias though. :) https://en.wikipedia.org/wiki/Automation_bias https://en.wikipedia.org/wiki/Automation_bias And hopefully the users who are using this aren't YOLO-ing it. Though I'm pretty sure we're all expecting there will be a sizeable percentage who are.
- rubicon33 7mo agoWhy do you do in production?
- lateforwork 7mo agoDid you miss this: "This feature requires an AI provider to be configured in Preferences > AI." And then you have to supply an API key (see here https://www.pgedge.com/blog/ai-features-in-pgadmin-configuration-and-reports https://www.pgedge.com/blog/ai-features-in-pgadmin-configura... ) You don't get AI for free!
- stuaxo 7mo agoYou can use it with Ollama rubbing a local model.
- chaz6 7mo agoWhen I open a new query window, the AI tab is selected by default which is annoying. I just want to write SQL without having to switch tabs like I could before. Not only has it ruined my muscle memory, it's also more inefficient.
- giancarlostoro 7mo agoIf you arent using it is it even a danger?