231–240 of 433 posts
Graphical schema image generation was in IntelliJ for like 15 years at least? Since the times with all the craze about UML "disrupting" software engineering.
[0] affectionately Crashional Rose
Earlier quoted context omitted.
No, it has a different purpose; VS Code extension and the former ADS are targeted for development, while SSMS is for server and database administration. I am a heavy user of SSMS and can do everything I ever need there, I don't use the VS Code extension for MS SQL even if I have it installed and I use VS Code quite a lot. This is because I am also acting as a backup and supervisor for our DBA team, so I am involved i…
SSMS is also for Development, I've been using it for that for 20 years
I've never used any of these kind of graphical SQL editors. I'm reasonably ok with SQL but I've always just done text queries. Does anyone here feel that the graphical editors actually save them time or make their lives easier?
Using a UI to explore data is like looking at the picture instead of someone describing the picture with words.
Like, you can make websites graphically with DreamWeaver (or something), but I think most people say that you're better off using HTML and CSS and whatnot if you know how to use that.
Is this GUI stuff something people who are good at SQL actually use or is this mostly for new people?
Graphical schema image generation was in IntelliJ for like 15 years at least? Since the times with all the craze about UML "disrupting" software engineering.
When you generate visualization, you should only show key table and key fields within the table and hide all the helper, secondary fields and tables.
In an LLM world this should be easy for LLMs to pick out key tables and fields and only display those
Earlier quoted context omitted.
Hm, is there a psql extension to augment the CLI and provide better autocomplete, maybe even interface with LLM? And then it just stores whatever metadata (like queries you want to save) in its own tables...
I’m really surprised that some rabid rustacean or something hasn’t written an entirely new and aesthetic CLI replacement for psql with all the modern comforts. Autocomplete menus, graphic icons, colors, etc…
Earlier quoted context omitted.
Using a UI to explore data is like looking at the picture instead of someone describing the picture with words.
I know, what I was asking is if this is something professionals actually use. Like, you can make websites graphically with DreamWeaver (or something), but I think most people say that you're better off using HTML and CSS and whatnot if you know how to use that. Is this GUI stuff something people who are good at SQL actually use or is this mostly for new people?
My first step was to look at the data using the UI. Then when I tested my queries, I also just ran them in the UI.
It’s just faster.
I never used the UI for “simple” queries since there wasn’t anything to test.
Isn't PGAdmin good enough? Not hating, but I'm not a database guy either so just curious why create a VSCode extension for GUI stuff.
Earlier quoted context omitted.
I've found Datagrip to be far and away the most impressive universal database tool. I feel like I've tried them all, and they all have a quality of having been developed by database people, rather than IDE designers. The depth of capability, extensibility, pace of improvement--I'm a very happy customer. I don't want to poop on open source, but pgadmin and dbeaver and not even close to playing in the same league. I wo…
I'd love to try datagrip, what are some advantages over pgadmin or others?
My company had some leftover Datagrip licences, and it felt like moving from notepad to an IDE. I haven't looked back since.