[Klug-general] database diagraming

[nic dan]

On the subject of databases, a few of you may be interested in this....

http://www.helpmysql.org/en/theissue/customerspaythebill

PS:Colin, I Won't be at Dover meet, maybe Maidstone, &  I have a projector, if ever it's needed for presentations

Aitch
----------------------------------------------

> From: macgyver at thedumbterminal.co.uk
> To: kent at mailman.lug.org.uk
> Date: Sat, 30 Jan 2010 09:45:57 +0000
> Subject: Re: [Klug-general] database diagraming
> 
> On Friday 29 Jan 2010, Mike Evans wrote:
> > There are some plugins for eclipse, which I've not tried.
> >
> > Avoid anything by Rational Software, even though now owned by IBM my
> > experience is that they are worse than stuff that I was using 20 years ago.
> >
> > Although I haven't yet any experience I would have thought that the
> > obvious candidate would be MySQL Workbench - it's GPL and it should work
> > with everyone's (except Julia's) favourite database :)
> >
> > It supposedly allows forward and reverse engineering between schema and
> > database.  In my personal experience that has always been of limited
> > value (ie for prototyping and early development only) but that was
> > mostly because DBAs responsible for the sort of large organisation
> > databases I've worked with are quite keen to eyeball the DDL and ask
> > searching questions about things like cardinality of tables and proposed
> > indices.  This is, of course, their job as they get to figure it out
> > when performance is crap and it helps if they have some human readable
> > stuff to look at as a starter.
> >
> > Mike
> >
> > On 29/01/10 13:57, Dan Attwood wrote:
> > > Does anyone know of some OSS for creating database diagrams. IE hook it
> > > up to a MS sql database and spit out a nice zoomable interactive type
> > > map showing the tables and their links?
> > >
> > > I can do this with Visio but it's a bit rubbish and wondered if any one
> > > knew of something better
> > >
> > > Dan
> > >
> > >
> > >
> > > _______________________________________________
> > > Kent mailing list
> > > Kent at mailman.lug.org.uk
> > > https://mailman.lug.org.uk/mailman/listinfo/kent
> >
> > _______________________________________________
> > Kent mailing list
> > Kent at mailman.lug.org.uk
> > https://mailman.lug.org.uk/mailman/listinfo/kent
> 
> I've used a postgresql one for eclipse it worked ok, but i didn't try a lot of 
> the features.
> 
> 
> _______________________________________________
> Kent mailing list
> Kent at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/kent
 		 	   		  
_________________________________________________________________
We want to hear all your funny, exciting and crazy Hotmail stories. Tell us now
http://clk.atdmt.com/UKM/go/195013117/direct/01/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.lug.org.uk/pipermail/kent/attachments/20100130/4c858268/attachment-0001.htm