self* \lsnum \lsname \lyear \l " shape = "record", style = "rounded"];
"COURSE":"F_COURSE"->"DEPARTMENT":"PK_DEPARTMENT" [arrowhead = normal] [label="generic label"];
"PROFESSOR":"F_PROFESSOR"->"DEPARTMENT":"PK_DEPARTMENT" [arrowhead = normal] [label="generic label"];
"CLASS":"F_CLASS"->"COURSE":"PK_COURSE" [arrowhead = normal] [label="generic label"];
"ENROLLMENT":"F_ENROLLMENT"->"CLASS":"PK_CLASS" [arrowhead = normal] [label="generic label"];
"SCHEDULE":"F_SCHEDULE"->"CLASS":"PK_CLASS" [arrowhead = normal] [label="generic label"];
"MARK":"F_MARK"->"ENROLLMENT":"PK_ENROLLMENT" [arrowhead = normal] [label="generic label"];
// make sure nodes line up vertically (not fully necessary, but it works)
{rank=same STUDENT MARK}
{rank=same ENROLLMENT SCHEDULE}
{rank=same COURSE PROFESSOR}
// use invisible edges to rearrange nodes
ENROLLMENT -> PROFESSOR [style=invis]
STUDENT -> SCHEDULE [style=invis]
}
```
Giving:
---
### Author:  [@student](https://forum.graphviz.org/u/student)
#### Post date: [November 9, 2021, 2:05am UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/3 "2021-11-09T02:05:46Z")
Thank you for the suggestions! These are very helpful.
Since I am actually generating the code automatically, I wouldn’t really have a way to see the graph beforehand so I can decide which tables to give the same rank to and which tables should have an invisible line connecting them.
Is there a logic to how you decided which tables should be grouped together? Perhaps by looking at the foreign key relationships between them?
---
### Author:  [@scnorth](https://forum.graphviz.org/u/scnorth)
#### Post date: [November 9, 2021, 2:13am UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/4 "2021-11-09T02:13:48Z")
I’m not sure, but think we invented ratio=compress to solve this problem.
See [ratio | Graphviz](https://graphviz.org/docs/attrs/ratio/)
Amazingly, we don’t have any pictures to explain this - just a lot of words.
---
### Author:  [@student](https://forum.graphviz.org/u/student)
#### Post date: [November 9, 2021, 3:37am UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/5 "2021-11-09T03:37:33Z")
I changed my code to this:
```auto
digraph ERD {
graph [rankdir = "LR", ratio = compress];
ranksep=1;
```
I didn’t notice any changes and after reading through the link I realize that I need to set a specific size for the graph. Unfortunately, I don’t think I can do this either because graphs with many nodes would shrink down to undesirable sizes. Or am I misunderstanding this attribute?
Is there anything else that can be set in a relatively automatic way?
Thank you!
---
### Author:  [@steveroush](https://forum.graphviz.org/u/steveroush)
#### Post date: [November 10, 2021, 12:57am UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/6 "2021-11-10T00:57:48Z")
Based on a sample of 1, I may be close to an automated solution.
First, is this graph OK? It is your starting input with the only changes being **size** and **ratio** attributes.
The problem is determining the correct value for **size**. It is fairly easy to set the starting value, but then it gets a bit messy. I’m still working on it.
Questions:
- roughly how many graphs?
- what OS (or OSs)?
- does the solution just have to work for you or will it be shared with many users?
---
### Author:  [@student](https://forum.graphviz.org/u/student)
#### Post date: [November 10, 2021, 1:21am UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/7 "2021-11-10T01:21:38Z")
That graph looks great, but I think that would be pretty much the limit on width. As in, I think the next few nodes should extend the height, not width.
Here is the example I am attempting to replicate (not made with Graphviz):
In response to your questions:
- I’m not sure what you mean by how many graphs? The number of nodes (representing tables) within each graph would vary but would likely not be more than 15.
- I am currently using Windows, and it would also have to be compatible with Linux. Would this be an issue? I’m not familiar on the differences in Graphviz based on OS. The solution would then ideally work for everyone.
Thank you so much for your help!
---
### Author:  [@steveroush](https://forum.graphviz.org/u/steveroush)
#### Post date: [November 10, 2021, 3:52am UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/8 "2021-11-10T03:52:28Z")
- “How many graphs?” - Assuming 1 graph per database, how many databases are you wanting to model/graph? 5 databases, 50, 500?
- if you set **ranksep** to .75 or even .5, the resulting graph will tighten-up in the X dimension.
- if you are wanting to replicate the _node placement_ of the graph “not made with Graphviz”, in an automated way - I think that would be very difficult with Graphviz. (see below for the “naive” dot version)
- if you just want to approximate the style of “not made with Graphviz”, I think you could get fairly close, but close is in the eye of the beholder
- ~~setting **rankdir=LR** is going to _tend_ to generate a horizontal graph.~~ In many ways, **dot** is not the best engine for a network like yours because your network lacks “natural” ranks (my opinion). I tried the other Graphviz engines, but saw nothing that grabbed me.
- except for the occasional bug or OS oddity, Graphviz produces the same results on all OSs
- I asked about OS because my **ratio=compress** solution requires more than one execution of dot per graph (2 to 6 executions) and a tiny bit of scripting to make it all happen. (The script/program computes the **size** values)
- Try using “html-like labels” instead of “record labels” for your nodes. That should allow better placement of edges and styling of concatenated keys
- finally, I think there are other ERD diagramming tools. You might consider them also
---
### Author:  [@student](https://forum.graphviz.org/u/student)
#### Post date: [November 11, 2021, 12:28am UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/9 "2021-11-11T00:28:42Z")
I see! It’s going to be more like 5 graphs. This is for a small research project so performance is really not of any concern. I’d rather the graph be somewhat close to the original image.
I’m curious what your fairly close option is? I, of course, do not need the graph to be identical. I just wanted to get rid of some of the width of the graph and thought it was interesting that the engine did not do more to optimize the use of negative space.
Would you recommend using a script to figure out ratio=compress? I’m still not sure what this entails. Or, would you recommend html-like labels? I’m not familiar with this format, would you be able to show me what the translation of my code would be if you think it’s a better approach?
Thank you!
---
### Author:  [@steveroush](https://forum.graphviz.org/u/steveroush)
#### Post date: [November 11, 2021, 11:43pm UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/10 "2021-11-11T23:43:45Z")
- None of the Graphviz engines have “space management” as the primary goal. Very roughly speaking, **dot** uses “rank” as the primary driver (see [https://graphviz.org/pdf/dotguide.pdf](https://graphviz.org/pdf/dotguide.pdf)) and **neato** (kind of) uses total edge length as the primary driver (see [https://graphviz.org/pdf/neatoguide.pdf](https://graphviz.org/pdf/neatoguide.pdf)) [There will not be a test on the two documents, but they are worth a quick once over]
- html labels and ratio address two very different things, not an either/or situation.
- here is a video of the same graph made using varying **size** attributes: [output.mp4 - Google Drive](https://drive.google.com/file/d/1NJwHFuhyyaKxIiTrDGZOjnP9d_C8D0bU/view?usp=sharing) [hoping that the video shows the visual changes better that lots of words]
- here is a shell script & a GVPR program (part of Graphviz package) that will give you sizes to try:
```auto
f=myfile.gv;
T=png;
F=`basename $f .gv`;
dot -Tdot $f |
gvpr -f squish.gvpr|
while read size;do
dot -T$T -G"size=$size" -G"ratio=compress" $f >$F.$size.$T;
done
```
The script runs **dot** once to determine the “native” size of the graph, listing progressively smaller sizes (in the non-rank dimension) to “squish” the graph, and runs dot repeatedly to create these squished graphs. Here is squish.gvpr:
```auto
BEG_G{
string z[int];
float dx, dy, f, incr;
incr=.5;
split($G.bb,z,",");
print($G.bb," ",z[0]," ",z[1]," ",z[2]," ",z[3]);
dx=(float)z[2]-(float)z[0]; // compute delta X
dy=(float)z[3]-(float)z[1]; // compute delta Y
sizex=dx/72.; //convert points to inches
sizey=dy/72.;
if (hasAttr($G, "rankdir")){
if ($G.rankdir=="LR"||$G.rankdir=="RL"){
print ("// LR");
for (f=sizey;f>=2.;f-=incr)
print (sizex,",",f);
exit(0);
}
}
for (f=sizex;f>=2.;f-=incr)
print (f,",", sizey);
}
```
- If “squishing” your five graphs produces a “good enough” result, let’s put off html nodes until another day
---
### Author:  [@student](https://forum.graphviz.org/u/student)
#### Post date: [November 15, 2021, 12:36am UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/11 "2021-11-15T00:36:56Z")
Thank you so much for this. I am trying to integrate it with my code. Currently, I have the following written in C:
```auto
// End and close the file
fputs("}\n", fp);
fclose(fp);
// Translate the file
char *export_graph = "dot diagram.dot -T svg -o diagram.svg";
system(export_graph);
```
How would I be able to use the first section of code you provided in your previous message? I need to execute all command line commands from this C file…
I also pasted the second section of code into a text file with that name. Is that fine? Will it be able to compile or do I need to include it into my Makefile to link it… I’m a bit of a beginner when it comes to scripts.
This is my Makefile so far:
```auto
.PHONY: all clean
CFLAGS = -I"C:/Program Files/Graphviz/include/graphviz"
LDIR = -L"C:\Program Files\Graphviz\lib"
LDFLAGS = -lgvc -lcgraph
binaries=sqlpsql
all: $(binaries)
sqlpsql: SQLP.c SQLPGrammar.y SQLPScanner.l SQLPtoSQL-main.c Preprocess.c Rules.c
bison -v -d SQLPGrammar.y
flex --nounput -D SQLPGrammar SQLPScanner.l
gcc -Wall -o sqlpsql SQLP.c SQLPtoSQL-main.c Preprocess.c Rules.c $(CFLAGS) $(LDIR) $(LDFLAGS)
rm -f lex.yy.c SQLPGrammar.tab.c SQLPGrammar.tab.h
clean:
-rm -f *.o *.output *.dot *.png $(binaries)
```
---
### Author:  [@steveroush](https://forum.graphviz.org/u/steveroush)
#### Post date: [November 15, 2021, 2:01am UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/12 "2021-11-15T02:01:46Z")
C coders: Help!
[I have not written a serious C program in over 25 years - I am way past rusty. Additionally, I seem to have misplaced my copy of Marc Rochkind’s “Advanced UNIX Programming” ([https://www.amazon.com/Advanced-UNIX-Programming-Marc-Rochkind/dp/0131411543](https://www.amazon.com/Advanced-UNIX-Programming-Marc-Rochkind/dp/0131411543)) (mine was the first edition), so I am really in deep water]
As I understand it you want to rewrite this:
```plaintext
gvpr -f squish.gvpr|
while read size;do
dot -T$T -G"size=$size" -G"ratio=compress" $f >$F.$size.$T;
done
```
as a C program. Very doable, I just don’t remember how to set up a pipeline in a C program. I’ll thrash about. Maybe one of the smarter folks will chime in.
p.s. I think your system call is missing the input file name
p.p.s. the **squish.gvpr** program file can be incorporated into your C program as a text string as part of the command line
---
### Author:  [@smattr](https://forum.graphviz.org/u/smattr)
#### Post date: [November 15, 2021, 4:02pm UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/13 "2021-11-15T16:02:26Z")
Constructing that in C is probably going to involve [`popen`](https://pubs.opengroup.org/onlinepubs/009696799/functions/popen.html) and be a little complicated. Alternatively you could put this in a shell script and call Bash in the `system` call supplying that shell script.
---
### Author:  [@student](https://forum.graphviz.org/u/student)
#### Post date: [November 15, 2021, 4:15pm UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/14 "2021-11-15T16:15:19Z")
For the second option, how would I do that? Would it involve defining the script as some kind of variable? (I am using Powershell to run my program)
Would you mind providing instructions for how I can execute that?
---
### Author:  [@smattr](https://forum.graphviz.org/u/smattr)
#### Post date: [November 16, 2021, 1:14am UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/15 "2021-11-16T01:14:03Z")
While this is possible, I think you probably don’t want to do this. You probably want to replicate Steve’s GVPR program _in_ C so you can run the logic inside your own program instead of having to call GVPR and parse and interpret its output.
Alternatively you could have some wrapper script/orchestrator that calls your `sqlpsql` binary and then takes its output and runs the GVPR squishing. Writing this outer script in e.g. Python or Ruby is likely to be much easier than trying to manage interaction between subprocesses in C.
---
### Author:  [@student](https://forum.graphviz.org/u/student)
#### Post date: [November 24, 2021, 11:02pm UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/16 "2021-11-24T23:02:49Z")
Hi! Sorry for the delayed response, I’ve been trying to get the graph squished on my own and I succeeded to a degree that I think will be fine!
An example looks like this:
Here is the dot code for it:
```auto
digraph ERD {
graph [rankdir = "LR", ratio = compress, size=8];
ranksep=1;
"DEPARTMENT" [label=" DEPARTMENT|deptcode \l | deptname \l " shape = "record", style = "rounded"];
"COURSE" [label=" COURSE|deptcode \lcnum \l | cname \l " shape = "record", style = "rounded"];
"PROFESSOR" [label=" PROFESSOR|pnum \l | pname \loffice \ldeptcode \l " shape = "record", style = "rounded"];
"CLASS" [label=" CLASS|deptcode \lcnum \lterm \lsection \l | pnum \l " shape = "record", style = "rounded"];
"ENROLLMENT" [label=" ENROLLMENT|snum \ldeptcode \lcnum \lterm \lsection \l | " shape = "record", style = "rounded"];
"SCHEDULE" [label=" SCHEDULE|deptcode \lcnum \lterm \lsection \lday \ltime \l | room \l " shape = "record", style = "rounded"];
"MARK" [label=" MARK|snum \ldeptcode \lcnum \lterm \lsection \l | grade \l " shape = "record", style = "rounded"];
"STUDENT" [label=" STUDENT|snum \l | sname \lyear \l " shape = "record", style = "rounded"];
"COURSE":"PK_COURSE"->"DEPARTMENT":"PK_DEPARTMENT" [arrowhead = normal] [label="deptcode"];
"PROFESSOR":"F_PROFESSOR"->"DEPARTMENT":"PK_DEPARTMENT" [arrowhead = normal] [label="deptcode"];
"CLASS":"F_CLASS"->"PROFESSOR":"PK_PROFESSOR" [arrowhead = normal] [label="pnum"];
"CLASS":"PK_CLASS"->"COURSE":"PK_COURSE" [arrowhead = normal] [label="deptcode, cnum"];
"ENROLLMENT":"PK_ENROLLMENT"->"STUDENT":"PK_STUDENT" [arrowhead = normal] [label="snum"];
"ENROLLMENT":"PK_ENROLLMENT"->"CLASS":"PK_CLASS" [arrowhead = normal] [label="deptcode, cnum, term, section"];
"SCHEDULE":"PK_SCHEDULE"->"CLASS":"PK_CLASS" [arrowhead = normal] [label="deptcode, cnum, term, section"];
"MARK":"PK_MARK"->"ENROLLMENT":"PK_ENROLLMENT" [arrowhead = normal] [label="snum, deptcode, cnum, term, section"];
}
```
However, there are a few final (minor) things I am noticing with it and was wondering if hopefully you had some suggestions for them?
Firstly, the edge of the graph on the right side is cut-off, as in the last node is missing it’s right edge. Is there a reason for this that is apparent from my code? Or is it just an unfixable glitch?
Secondly, is there a way to clean up the arrow labels a bit? Perhaps to make them follow the direction of the arrow, rather than restricting them to be horizontal? The two edges coming out of the ENROLLMENT table are a bit hard to interpret…
Thank you so much for your help!
---
### Author:  [@steveroush](https://forum.graphviz.org/u/steveroush)
#### Post date: [November 25, 2021, 2:56am UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/17 "2021-11-25T02:56:43Z")
Problem #1 - image clipping/truncation
- maybe you are encountering this: [SVG layout doesn't always respect requested size (#1855) · Issues · graphviz / graphviz · GitLab](https://gitlab.com/graphviz/graphviz/-/issues/1855)
- I’m not encountering it on Linux, but I did on Windows & SVG. Are you still on Windows?
- are you creating SVG or PNG output (or other)?
- What Graphviz release are you using? (dot -V)
- Try this commandline as a work-around. It uses a different SVG generator:
`dot -Tsvg:cairo myfile.gv >myfile.svg`
Problem #2 - funky edge label placement
- Nope, Graphviz can’t write labels at an angle. (Longtime on the wish-list)
- Maybe one of these will work for you:
- add position ports to your edges (see [https://graphviz.org/docs/attr-types/portPos](https://graphviz.org/docs/attr-types/portPos)) e.g.`"ENROLLMENT":"PK_ENROLLMENT":se->"CLASS":"PK_CLASS"`
- try preceding the label text with a \n (see [escString | Graphviz](https://graphviz.org/docs/attr-types/escString/))
- Try different values of the splines attribute ([splineType | Graphviz](https://graphviz.org/docs/attr-types/splineType/)) (I like `graph[splines=false]`)
---
### Author:  [@student](https://forum.graphviz.org/u/student)
#### Post date: [November 25, 2021, 10:34pm UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/18 "2021-11-25T22:34:25Z")
Hi!
Problem #1:
Using -Tsvg:cairo is a very promising solution, but for some reason another one of my other graphs gets rendered like so:
It did fix the other graph’s cut-off issue, however… Is there any reason for this graph turning out this way?
Problem #2:
I do think that adding a newline between really long arrow labels will be a good workaround to my problem. However, I am having a bit of trouble doing so (embarrassing). When I try to write “\n” to the file, the generated .gv file simply just includes an actual newline and pushes the file to the next line, which does nothing for the rendered graph. How can I get my C code to just print \n into the .gv file?
Thanks!
---
### Author:  [@steveroush](https://forum.graphviz.org/u/steveroush)
#### Post date: [November 26, 2021, 6:01pm UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/19 "2021-11-26T18:01:10Z")
Problem #1:
Hmm, Cairo seems to be struggling with fonts and character placement. Rather than chase this down, first try a different work-around. Embed all the nodes and edges in an invisible (peripheries=0) cluster. It does not stop the chop/truncation, but it will not be visible.
```auto
digraph ERD {
graph [rankdir = "LR", ratio = compress, size=8];
ranksep=1;
subgraph clusterNoChop { // enlarge the graph a bit
graph [peripheries=0]
"DEPARTMENT" [label=" DEPARTMENT|deptcode \l | deptname \l " shape = "record", style = "rounded"];
"COURSE" [label=" COURSE|deptcode \lcnum \l | cname \l " shape = "record", style = "rounded"];
"PROFESSOR" [label=" PROFESSOR|pnum \l | pname \loffice \ldeptcode \l " shape = "record", style = "rounded"];
"CLASS" [label=" CLASS|deptcode \lcnum \lterm \lsection \l | pnum \l " shape = "record", style = "rounded"];
"ENROLLMENT" [label=" ENROLLMENT|snum \ldeptcode \lcnum \lterm \lsection \l | " shape = "record", style = "rounded"];
"SCHEDULE" [label=" SCHEDULE|deptcode \lcnum \lterm \lsection \lday \ltime \l | room \l " shape = "record", style = "rounded"];
"MARK" [label=" MARK|snum \ldeptcode \lcnum \lterm \lsection \l | grade \l " shape = "record", style = "rounded"];
"STUDENT" [label=" STUDENT|snum \l | sname \lyear \l " shape = "record", style = "rounded"];
"COURSE":"PK_COURSE"->"DEPARTMENT":"PK_DEPARTMENT" [arrowhead = normal] [label="deptcode"];
//graph[splines=curved] // maybe
//graph[splines=true] // ugly
//graph[splines=polyline] // huh, same as true
//graph[splines=ortho] // nope
//graph[splines=false]
"PROFESSOR":"F_PROFESSOR"->"DEPARTMENT":"PK_DEPARTMENT" [arrowhead = normal] [label="deptcode"];
"CLASS":"F_CLASS"->"PROFESSOR":"PK_PROFESSOR" [arrowhead = normal] [label="pnum"];
"CLASS":"PK_CLASS"->"COURSE":"PK_COURSE" [arrowhead = normal] [label="deptcode, cnum"];
"ENROLLMENT":"PK_ENROLLMENT"->"STUDENT":"PK_STUDENT" [arrowhead = normal] [label="snum"];
// headlabel & tail label make a bigger mess
// prepending a \n helps
"ENROLLMENT":"PK_ENROLLMENT":se->"CLASS":"PK_CLASS" [arrowhead = normal] [label="deptcode, cnum, term, section"];
"SCHEDULE":"PK_SCHEDULE"->"CLASS":"PK_CLASS" [arrowhead = normal] [label="deptcode, cnum, term, section"];
"MARK":"PK_MARK"->"ENROLLMENT":"PK_ENROLLMENT" [arrowhead = normal] [label="snum, deptcode, cnum, term, section"];
}
}
```
Problem #2:
You need 2 \ characters together. Three examples below:
```auto
char s[50] = "0: \\n";
printf("%s\n",s);
s[0]='\\';
s[1]='n';
s[2]='\0';
printf("1: %s\n", s);
printf("2: \\n \n");
```
---
### Author:  [@student](https://forum.graphviz.org/u/student)
#### Post date: [November 26, 2021, 9:29pm UTC](https://forum.graphviz.org/t/removing-unnecessary-whitespace-from-dot-graph/901/20 "2021-11-26T21:29:19Z")
Wow, perfect thank you so much! Both of those worked incredibly.
I really appreciate all your help with this 🙂