As my Glide App grows, I find a need to visualize all the intricacies of calculated and related columns. I know that there are solutions for SQL databases that can graph it automatically but I’m not sure if it’s possible for Glide tables (guessing not?).
I’ve tried using dbdiagram.io and it’s a decent solution, but at some point becomes a bit unwieldy (I’m also not using it right, but oh, well, call the police )
Curious if anyone knows of other solutions. Extra points for something that’s free =) Thank you!
I MUST be able to see my app. I use Excel.
Do you use any kind of automation or just manually update it?
Manually. This was created after I had been working on my first app because I was going crazy trying to keep up. Now I attempt to build this first and it makes all of the difference as I think through my logic of glide’s relations, lookups, computations, etc.
Yes, Database Architect is a profession for a reason =) These relations get unwieldy really quickly, and your experience sounds exactly like what I’m going through. Granted, I was just learning the tool, but it’s time to clean this mess up!
Thank you for the advice =) Will try that!
Try with https://www.diagrams.net. I haven’t used it since long time ago but it had some interesting things.
Don’t fell bad about your “little mess”, the database’s relationships diagrams aren’t nice and friendly most cases, I have seen some ones on MS SQL Server very crazy and complex.
Have a nice night
Heh, well, less worried about the mess by itself, but rather about the fact that I can’t tell what’s related to what, which is kind of the whole point of the diagram
Thank you, I’ll check it out!
Thinking carefully about how you name columns, and taking full advantage of Column Grouping can both help with that
Doing both =)
I can tell what’s related to what looking at my tables, but not when I’m looking at that automatic diagram =) Sorry, I’m very picky about my visualizations =)