3 ms·
Explanation of PostgreSQL PgAdmin Interface
- cameronfraser 7y agoI thought this was going to be an article explaining why the UI is so bad...
- boobsbr 7y agoI had already prepared my pitchfork...
- sojournerc 7y agoI've switched entirely to Dbeaver for postgres management/exploration and writing SQL. https://dbeaver.io/ https://dbeaver.io/ Really well-built tool.
- mattashii 7y agoIt may be well-built, but my recent experience with DBeaver was a database server that went down due to aggressive background column option fetching on a table with some 4 * 10^9 entries, soaking up all available IO. Partly the fault of the dba using the tool of course, but dbeaver has these 'small' features that suddenly become very costly to use when administrating production datasets.
- sojournerc 7y agoYeah, good point. I've unwittingly done something similar. I have to caution co-workers against trying to sort an entire 300mm row table in the GUI. Some guardrails around that would certainly be nice.
- cameronfraser 7y agoHave you used datagrip at all? Was curious how it compares
- unixhero 7y agoPgadmin4 is amazing