Jump to content

Recommended Posts

Posted

Would anyone be interested in a script that uses the GD library to draw a picture of foreign key constraints in their MySQL/Innodb database? I haven't been able to find anything free out there that does it.

 

If so I'll share what I've done so far. If not I'll just keep it to myself :D See it in action drawing the mess I've made. Red dots are "parents" and blue dots are "children" in the relationships.

 

l8r,

Nate

Posted

I'm not exactly sure what it does... but I like the fact that you're using the GD library... one of the more esoteric bells and whistles offered by TCH.

 

Cool stuff.

 

Thanks for posting your hard work.

Guest Guest_Nate
Posted
I'm not exactly sure what it does... but I like the fact that you're using the GD library... one of the more esoteric bells and whistles offered by TCH.

 

Cool stuff.

 

Thanks for posting your hard work.

Not sure what it does...? Well, each box represents a table in the MySQL database, and each line represents a foreign key contraint for the table. So basically all it does is give a graphical representation of foreign key definitions. :o

 

GD is pretty spiffy. B)

 

l8r,

 

Nate

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...