God bless your efforts in your channel. As a new sql learner i had learned about ER diagrams, that are needed to build database schema for mapping out different entities, relationships, and attributes. My enquiry was if there any tool or software that would aid building that kind of diagrams with collaboration features among other developers. I would be so grateful if you would suggest any good practices that are leveraged regarding ER diagrams.
Ok, So I can only show tables already existing in some of my databases? I want to create an empty ERD and think about how my entities are related, before actually creating the database...
Thanks a lot! Visual Query Builder is our PRO feature, so it is available in DBeaver Lite, Enterprise, Ultimate and also in our web app CloudBeaver and in DBeaver Team Edition (our solution for teamwork)
1:22 Not Exactly. The dashed lines represened non-idenfying relationships while a solid line represents identifying relationship. A foreign key can be not null and you can still see a dashed line if it is a non-identifying relationship.
MySQL workbench has a feature called "Auto Layout" that automatically arranges the db schema with respect to all the relations to make it cleaner to view. Similarly there are features such as hiding un-related tables so you can only view tables you're currently working with and I can also make new connections in the ER diagram. Are these features available in DB Visualizer as well?
Unfortunately, we don't have deep expertise in DBVisualizer :) However, DBeaver has the auto layout in ERD. Speaking about hiding unrelated objects, we haven't implemented this feature yet. But thanks for the idea!
God bless your efforts in your channel.
As a new sql learner i had learned about ER diagrams, that are needed to build database schema for mapping out different entities, relationships, and attributes.
My enquiry was if there any tool or software that would aid building that kind of diagrams with collaboration features among other developers.
I would be so grateful if you would suggest any good practices that are leveraged regarding ER diagrams.
Ok, So I can only show tables already existing in some of my databases? I want to create an empty ERD and think about how my entities are related, before actually creating the database...
Hi, what a great tool ! Is the query builder available on community edition ?
Thanks a lot!
Visual Query Builder is our PRO feature, so it is available in DBeaver Lite, Enterprise, Ultimate and also in our web app CloudBeaver and in DBeaver Team Edition (our solution for teamwork)
1:22 Not Exactly. The dashed lines represened non-idenfying relationships while a solid line represents identifying relationship. A foreign key can be not null and you can still see a dashed line if it is a non-identifying relationship.
MySQL workbench has a feature called "Auto Layout" that automatically arranges the db schema with respect to all the relations to make it cleaner to view. Similarly there are features such as hiding un-related tables so you can only view tables you're currently working with and I can also make new connections in the ER diagram.
Are these features available in DB Visualizer as well?
Unfortunately, we don't have deep expertise in DBVisualizer :)
However, DBeaver has the auto layout in ERD. Speaking about hiding unrelated objects, we haven't implemented this feature yet. But thanks for the idea!
Excelent!!!!
Is it only available on paid version? Because on my dbeaver the “edit mode” is not shown.
Yes, the Edit Mode works only in DBeaver PRO apps
is it possible to add new tables to the diagram without them existing in the database?
can this tool be used without a connection to a database?
We recommend watching this video about forward engineering:
ruclips.net/video/dCm0Pva1Yaw/видео.html
It will probably be helpful for you
Is there a way to see an ERD of a materialized view?
Of course. You just need to open your view and go to the ER Diagram tab