Yep totally. I try to avoid connecting directly to my production DB in general so I haven't gone all out with a tunnel set up. Usually all modifications happen through migration scripts that get commit to version control and are run at deploy time.
I am having a hard time understanding the mapping between tables. Those mapping symbols in Dbeaver are not very clear. So, whether its one to one mapping or one to many, I am not able to understand. Would it be possible to share any link that explains the mappings between tables and their symbol in DBeaver please?
Maybe, I'm not sure. There's a post asking for that 6 years ago at dbeaver.io/forum/viewtopic.php?f=3&t=2116 which mentions it'll be in the next version. Chances are you can, I would say try it out, that's not a feature I typically use.
Here's a blog post that explains it in detail www.lucidchart.com/pages/ER-diagram-symbols-and-meaning. I didn't write the post but the idea of ER diagrams is standard and has standard notation.
I spent more than 12 hours in figuring this out. Thanks for this man.
You can setup a tunnel to connect to your production db from dbeaver. I think that's much easier than using sql commands from the terminal.
Yep totally. I try to avoid connecting directly to my production DB in general so I haven't gone all out with a tunnel set up. Usually all modifications happen through migration scripts that get commit to version control and are run at deploy time.
I am having a hard time understanding the mapping between tables. Those mapping symbols in Dbeaver are not very clear. So, whether its one to one mapping or one to many, I am not able to understand. Would it be possible to share any link that explains the mappings between tables and their symbol in DBeaver please?
Hi, it's an "Entity Relationship Diagram", if you Google for "ERD symbols" you'll find a break down of each one. It's not specific to DBeaver.
@@NickJanetakis Thanks. But, is the cardinality mentioned anywhere in Dbeaver if we want to find out for an ER diagram ?
Thx for sharing Nick. Could be great with more videos from you. This one was short, precise and usefull. Great!
No problem, and thanks for the comment. I do try to post new videos from time to time. Are there any topics you'd like to see covered first?
@@NickJanetakis An overrall overview of the most used functions would be great. Visualising geometries, how to create roles and permissions etc.
Great tips for visualing database
Glad you liked it. Thanks for watching.
Hello, is there a way how to show in the ERD schema foreign keys dirctly with columns in the ERD schema?
Hi, I'm not sure I follow you but they have docs available at dbeaver.com/docs/wiki/ER-Diagrams/.
Awesome vid, I wasn't sure what to use for Postgres, but this seems promising!
No problem. I still use it today.
Hi. Thank you a lot. can you pls more explain how to read the connections between tables? thanks again
Hi, what do you mean? Like creating a SQL query to join 2 tables?
Can you add descriptions to columns and tables via the package? we need to document a database where the column naming is not very good , thanks
Maybe, I'm not sure. There's a post asking for that 6 years ago at dbeaver.io/forum/viewtopic.php?f=3&t=2116 which mentions it'll be in the next version. Chances are you can, I would say try it out, that's not a feature I typically use.
Hi Nick, thanks for your explanation. then, can i generate diagram to script sql with dbeaver? Like in Sybase power designer.
Hi, I never tried but based on github.com/dbeaver/dbeaver/issues/8180 maybe it's not supported.
thanks for the video!
Please explain about relationship meaning like dotted line with diamond and solid line end with dot.plz explain this one
Here's a blog post that explains it in detail www.lucidchart.com/pages/ER-diagram-symbols-and-meaning. I didn't write the post but the idea of ER diagrams is standard and has standard notation.
Actually I couldn't understand what that diamond tell that
@@sowmiyamuthu7729 It's in the blog post next to the diamond picture. "Relationships are associations between or among entities."
"a non-good state" HA HA
It's good but it's not! Although technically some of it ended up working out quite nicely.