Member Avatar for phoenix_2000

Hello all,

Im looking for a tool that allows me to visualise a single entry in a database, so i can see that entry, and all entries that have a foreign key to it, and foreign keys to those etc.
Im not talking about an ERD, but more like a graph showing all entries from all tables related to a single entry.

This is what i have at the moment: a database containing a lot of employees. an employee might have multipl employees under him, who might have multiple of them as well.
What i would like to have is a tool that allows me to visualy see the 'chain of command' a certain user has, along with related table entries for each user (like his or her assignments)

Does anyone know if such a tool exists? i'm not to afraid to write it myself, but it would seem a waste of time if someone else already did that.

  • 3 Contributors
  • 6 Replies
  • 147 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by pixelsoul
Member Avatar for AleMonteiro

I know MySQL Browser, but you have to write the querys your self.

Member Avatar for phoenix_2000

According to the mysql site, the browser became part of mysql workbench.
I've got it installed, but i can't find that function.

Member Avatar for AleMonteiro

Oh, I never used it. It's been a while since I used MySQL. And last time I did, there was no Workbench.

Member Avatar for pixelsoul

When you open up Workbench go to the top menu and select "Database > Reverse Engineer". Put in the DB connection info and it will walk you through the steps.

Member Avatar for phoenix_2000

I know, but thats an ERD diagram. what i was looking for was more like a tree structure generator, that showed an individual entry from a table, and all related entries (be it in the same table, or another)

As far as i know, mysql workbench doesnt have that, so i guess my best guess is to loop the database in python (for example) and use a graphic library to draw one myself.

This is an example: it was made manually, but thats just undoable for the really huge databases.
4b5a02564a173b70f5780800fa464929

Member Avatar for pixelsoul

I really don't have any other suggestions. I would probably setout and create my own in PHP (for example) ;-)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.