3 ms·

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

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?

debarshri 1y ago
We build privileged access management tools. Majority of our users do not like to use CLI. They know workbenches, pgadmin etc. at a wizard level. In my opinion, i see that graphical editors are more product for major section of devs and admins.
deleed 1y ago
You don't use it but still it's nice feature to have, isn't it?
- tombert 1y ago
  Oh sure, I'm not criticizing its existence.
- epolanski 1y ago
  I think he went a long way to simply ask what do these tools do that a cli won't.
mcv 1y ago
I haven't used it for relational databases, but I can imagine it's useful to visualize complex relationships between tables.
hbn 1y ago
Just today I've been dealing with an issue trying to update an XML column because the XML I'm trying to insert was escaping the string in the update query. But with DataGrip I could just pull the row I was interested and paste in the string from the UI. Surely there's another workaround that wouldn't involve a UI but this made it pretty easy.
harrall 1y ago
Using a UI to explore data is like looking at the picture instead of someone describing the picture with words.
- tombert 1y ago
  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?
  - harrall 1y ago
    I used to write a ton of SQL and I could write a query for anything you asked for, no matter how incompatible the schema was to your request. 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.
- timewizard 1y ago
  Yet the picture at the top of the article is incomprehensible to me. Why is the "session_speakers" table positioned there? It relates speakers and sessions and then has a geometric layout that completely fails to convey that. You put too many bezier curves on a page on my eyes go cross. They don't even bother to make the lines different colors. Just a bunch of white curves against a fixed grid layout. Wut? It's taking well structured data and then destructuring it into an inaccurate sloppy picture. I don't get it.
  - maxluk 1y ago
    Isn't it a problem with many-to-many relationships in relational algebra? You have to have this artificial table to relate things in many-to-many way. How would you display it in a better way?
pamelafox 1y ago
The schema visualization is a feature of the extension, not the primary mode of navigation. Lots of people love visualization, but not everyone does - totally cool to not use it. I think it's a fun way to browse a database that's new to me, to see roughly how things are connected.

debarshri 1y ago

We build privileged access management tools. Majority of our users do not like to use CLI. They know workbenches, pgadmin etc. at a wizard level. In my opinion, i see that graphical editors are more product for major section of devs and admins.

deleed 1y ago

You don't use it but still it's nice feature to have, isn't it?

tombert 1y ago
Oh sure, I'm not criticizing its existence.
epolanski 1y ago
I think he went a long way to simply ask what do these tools do that a cli won't.

mcv 1y ago

I haven't used it for relational databases, but I can imagine it's useful to visualize complex relationships between tables.

hbn 1y ago

Just today I've been dealing with an issue trying to update an XML column because the XML I'm trying to insert was escaping the string in the update query. But with DataGrip I could just pull the row I was interested and paste in the string from the UI. Surely there's another workaround that wouldn't involve a UI but this made it pretty easy.

harrall 1y ago

Using a UI to explore data is like looking at the picture instead of someone describing the picture with words.

tombert 1y ago
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?
- harrall 1y ago
  I used to write a ton of SQL and I could write a query for anything you asked for, no matter how incompatible the schema was to your request. 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.
timewizard 1y ago
Yet the picture at the top of the article is incomprehensible to me. Why is the "session_speakers" table positioned there? It relates speakers and sessions and then has a geometric layout that completely fails to convey that. You put too many bezier curves on a page on my eyes go cross. They don't even bother to make the lines different colors. Just a bunch of white curves against a fixed grid layout. Wut? It's taking well structured data and then destructuring it into an inaccurate sloppy picture. I don't get it.
- maxluk 1y ago
  Isn't it a problem with many-to-many relationships in relational algebra? You have to have this artificial table to relate things in many-to-many way. How would you display it in a better way?

pamelafox 1y ago

The schema visualization is a feature of the extension, not the primary mode of navigation. Lots of people love visualization, but not everyone does - totally cool to not use it. I think it's a fun way to browse a database that's new to me, to see roughly how things are connected.