cssfreakie Posted March 18, 2011 Share Posted March 18, 2011 Hi all, normally what i set up a database i get a pen and pencil and just start drawing, after that i make it digital with inkscape (a 2d grafics program) But that takes quite some time. Does anyone maybe know simple tool (not to advanced) to quickly make a database more visual, with diagrams and relationships between tables. I have searched a bit, and even instaled some, but they are all pretty advanced and farm from what i mean with visual. So in a njt shell a simple program to create a visual database, with tables and relationships Cheers! Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/ Share on other sites More sharing options...
gristoi Posted March 18, 2011 Share Posted March 18, 2011 you could try to use the EER diagram functionality in Mysql Workbench. The program is free and can be downloaded from http://wb.mysql.com/ Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1189141 Share on other sites More sharing options...
cssfreakie Posted March 18, 2011 Author Share Posted March 18, 2011 Thanks gristoi, I'll certainly check it out. I tried another workbench before, but it had so many options, and it seemed more like a programming language that I removed it. I'll give it ago Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1189150 Share on other sites More sharing options...
KevinM1 Posted March 18, 2011 Share Posted March 18, 2011 Check out http://www.gliffy.com It's a free UML/database/general diagram web app. Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1189166 Share on other sites More sharing options...
cssfreakie Posted March 18, 2011 Author Share Posted March 18, 2011 Check out http://www.gliffy.com It's a free UML/database/general diagram web app. WoohoOOOO that is awesome! that was exactly what i meant. Thanks a bunch! for some reason i need visual stuff to insert it in my brain, this will certainly help, thanks! -edit: seems i had to search for the word uml (if i were english i probably would have found it myself ) Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1189169 Share on other sites More sharing options...
cssfreakie Posted March 18, 2011 Author Share Posted March 18, 2011 I searched a bit more with the magic word "UML" after i saw it's only free for 30 days (poor fellow here ) And i found this: DIA there is only one word for it and that's : AWESOME Its free, it has loads of graphs and other stuff So if anyone needs this DIA is the bomb thanks for the magic uml word! Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1189213 Share on other sites More sharing options...
Philip Posted March 18, 2011 Share Posted March 18, 2011 I personally vote for MySQL WB, has everything you'd ever need Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1189225 Share on other sites More sharing options...
Maq Posted March 18, 2011 Share Posted March 18, 2011 Workbench is really nice, I've only used it briefly but everyone says positive things about it and it has everything you need. DIA looks interesting, I'll have to check it out. Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1189227 Share on other sites More sharing options...
cssfreakie Posted March 19, 2011 Author Share Posted March 19, 2011 I personally vote for MySQL WB, has everything you'd ever need I just tried work bench and it seems to be really nice. I first opened up the wrong application that came with the package, opening up some sort of command line thingy. Really nice, although it doesn't allow to edit the look and feel of the the boxes, it makes that up by the ease of inserting tables. Have to take a closer look to it though, but it sure looks promising. Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1189440 Share on other sites More sharing options...
gristoi Posted March 19, 2011 Share Posted March 19, 2011 Hi, not a my pc right now, but I can tell you that you can change the colour and look ofthe tables in the diagrams to anything you want in mysql WB. Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1189445 Share on other sites More sharing options...
cssfreakie Posted March 19, 2011 Author Share Posted March 19, 2011 Cool thanks, going to try that out cheers! Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1189452 Share on other sites More sharing options...
Philip Posted March 19, 2011 Share Posted March 19, 2011 Yup, see the attachment on where to change properties of each table in the diagram. [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1189623 Share on other sites More sharing options...
cssfreakie Posted March 19, 2011 Author Share Posted March 19, 2011 Thanks Philip! Really awesome this work bench. Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1189677 Share on other sites More sharing options...
JonnoTheDev Posted March 21, 2011 Share Posted March 21, 2011 Maybe similar to the one you are already trialing bu I sometimes use http://fabforce.net/dbdesigner4/ Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1190215 Share on other sites More sharing options...
cssfreakie Posted March 21, 2011 Author Share Posted March 21, 2011 Nice Neil, Thanks for sharing! Quote Link to comment https://forums.phpfreaks.com/topic/231004-database-visual/#findComment-1190228 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.