ER diagram software

Question

ER diagram software for Ubuntu?

Could you please explain what is lacking in Dia, so that we can answer with the most suitable alternatives? — dv3500ea, Oct 13 '10 at 20:31

score 27 · Answer 1 · answered Oct 13 '10 at 21:14

27

I've found MySQL Workbench to be most useful for creating "ER" diagrams.

alt text

Though the format is only MySQL Workbench specific I can take a diagram created in Workbench and export it to SQL and execute it against any number of SQL servers.

alt text

If you're working with MySQL this tool also doubles as an Administration and Querying tool as well providing the added benefit of integration between the three.

answered Oct 13 '10 at 21:14

Marco Ceppi

47,783
30
172
197

It's a good tool, a good explanation, but I will use DIA. Thank you!!!! – Vassilis Oct 14 '10 at 09:20
2

Extremely buggy (lost my work twice, crashed 5 times total), and printing to a PDF has unacceptable font quality issues (and I would assume a real printer also). – Iiridayn Feb 07 '17 at 23:35
1

WB is not only buggy in behavior but in look and feel too (try to use it in a HiDPI monitor and you will see). There is a bug report about that since *2009* without any work on it (and so many other marked as duplicated). – sdlins Sep 16 '18 at 23:29
can you export and execute on Oracle? – mLstudent33 Mar 23 '20 at 00:00

score 24 · Accepted Answer · edited Feb 25 '23 at 09:35

24

Dia

Dia is a GTK+ based diagram creation program for GNU/Linux, Unix and Windows released under the GPL license. For more information visit the Dia project page

To install Dia in all currently supported versions of Ubuntu open the terminal and type:

sudo apt install dia

edited Feb 25 '23 at 09:35

karel

110,292
102
269
299

answered Oct 13 '10 at 23:19

tfmoraes

514
1
5
6

workflows with inkscape??? – Vassilis Oct 14 '10 at 09:23
1

why not? See this http://www.ioncannon.net/utilities/123/10-tips-for-creating-good-looking-diagrams-using-inkscape/ – tfmoraes Oct 14 '10 at 11:43
What does "Install electric sheep" mean? The link heads to an auto-download page for dia. Is it some jargon? – Ignatius Aug 05 '19 at 02:32

score 5 · Answer 3 · edited May 30 '15 at 11:12

5

Umbrello can also create ER-Diagrams besides most other UML diagrams. In addition it allows you to export the Diagrams in form of code (i.e. in this case SQL).

edited May 30 '15 at 11:12

mguassa

211
1
6

answered Oct 13 '10 at 20:43

txwikinger

27,944
10
78
101

1

umbrello http://www.umbrello.org/index.php and is for KDE if you use gnome it install a lot of KDE dependency – hhlp Oct 17 '10 at 22:08

score 1 · Answer 4 · answered Oct 13 '10 at 20:45

1

try to use Astah Comunity, the application was able to create ER diagrams, class diagrams, etc.To develop applications that application is very suitable. I even heard the professional version could generate java code to class diagram and generate sql code for the ER diagram.

that application was built using java, so the application is multi platform.

answered Oct 13 '10 at 20:45

squallbayu

3,054
2
23
24

the astha comunity FREE only support UML Modeling Tool the other thing you coment is the paid one – hhlp Oct 17 '10 at 21:43

ER diagram software

4 Answers4

Dia

Linked

Related