How do you visualize your tables?

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 :rofl:)

Curious if anyone knows of other solutions. Extra points for something that’s free =) Thank you!

2 Likes

I MUST be able to see my app. I use Excel.

Glidelayout

4 Likes

Of course!!! :star_struck:

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.

2 Likes

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!

Hola!

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 :exploding_head: and complex.

Have a nice night

4 Likes

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 :rofl: :woman_facepalming:

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 :slight_smile:

2 Likes

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 =)

Found myself in this exact same position. How are you dealing with that problem 3 years later?

I create entity-relationship diagrams in Claude. They are very helpful when building and I include them in the documentation of the application.

I cannot recall who recommended this to me, probably @ThinhDinh, @Darren_Murphy or @Robert_Petitto.