[BNM] Online SQL ERD tool

[Alastair James]

Leo: Cheers for all that. An interesting feature would be to build the model
in the tool by typing SQL into a console. I.e. if you type a CREATE TABLE
statement, the table appears in the diagram for you to move about...
Wowzers, having automatic mysql fetching would be super powerful. Need to
think about that.

Good point on GraphML. Internally I will be using a super-lightweight JSON
based format (not because I like inventing new data formats, but simply that
its easier / quicker to process), but converting it to GraphML for some
tasks (rendering PDFs for example) is useful.

I will drop you a line when I have something to show! You guys are Werkers
right?

Al

2009/1/5 Leo Brown <lists at acumendevelopment.net>

> Guys
>
> Export is great, but a lot of people have preferences on which point to
> start from. Some start in visio, others start on the MySQL command line.
>
> When we were thinking of making this into a product a year or two ago, we
> were thinking of users being able to specify a URL to fetch the new DB
> from,
> for instance:
>
>  mysql://user:pass@acumendevelopment.net/db_name
>
> As long as that user then allowed connections to their server remotely, you
> could build up the ERD, auto-recognise the naming conventions, or if not,
> let them specify their own - Voila.
>
> Anyway, do consider storing your ERDs in GraphML, and do drop us a line if
> you want some help rendering them, though there are definitely
> editors/viewers out there from .graphml, I think we used some from
> yfiles.com before...
>
> Good luck!
>
> Leo
>
> -----Original Message-----
> From: bnmlist-bounces at brightonnewmedia.org
> [mailto:bnmlist-bounces at brightonnewmedia.org] On Behalf Of Alastair James
> Sent: 05 January 2009 15:14
> To: jasonslbailey at yahoo.co.uk; Brighton New Media
> Subject: Re: [BNM] Online SQL ERD tool
>
> Thanks all for the input. It seems like this idea might have some legs.
> I am certainly going to look the existing desktop (mostly windows) tools
> for
> features etc.
>
> Leo: Interesting point about naming conventions etc... I guess there is a
> larger point that people using rails, cake (etc..) might not use SQL at
> all.
> So export to Rails active record classes / migrations would be useful... So
> maybe it could have, instead of target database mysql, target format
> 'rails'
> or 'cake'...
>
> Al
>
> 2009/1/5 Jason Bailey <jasonslbailey at yahoo.co.uk>
>
> >
> > Toad for mysql is free but I think you'd want to be looking at toad data
> > modeller (oracle,mysql, mssql) which isn't free.
> > http://www.toadsoft.com/toaddm/toad_data_modeler.htm
> >
> > Not sure how much ERD stuff there is in the free toad for mysql.
> > As you're looking at creating your own tool the data modeller might be
> > useful for an idea of feature requirements.
> >
> > Jas
> >
> >
> >
> > --- On Mon, 5/1/09, Wayne Douglas <wayne at codingvista.com> wrote:
> > > I've used Toad[1] in the past (where sql server
> > > management studio isn't
> > > available) - there's a free version - not sure if that
> > > version includes the
> > > data modeller which does the ERDs but it is good.
> > > [1] - http://www.toadsoft.com
> > >
> >
> >
> >
> >
> > --
> >
> > BNM Subscribe/Unsubscribe:
> > http://www.brightonnewmedia.org/options/bnmlist
> >
> > BNM powered by Wessex Networks:
> > http://www.wessexnetworks.com
> >
>
>
>
> --
> Dr Alastair James
> CTO James Publishing Ltd.
>
> www.worldreviewer.com
> Winner Yahoo! Finds of the Year
> WINNER Travolution Awards Best New Online Travel Company 2008
> "In a market increasingly crowded with new content and experience-led
> sites,
> Worldreviewer stands out a mile. It has used exclusive editorial and
> excellent tools to wonderful effect and ensured its commercial partnerships
> are relevant to the target market."
>
> Blogs: onewheeledbicycle.com, traveltelegraph.com
>
> "Utinam logica falsa tuam philosophiam totam suffodiant!"
> --
>
> BNM Subscribe/Unsubscribe:
> http://www.brightonnewmedia.org/options/bnmlist
>
> BNM powered by Wessex Networks:
> http://www.wessexnetworks.com
>
> --
>
> BNM Subscribe/Unsubscribe:
> http://www.brightonnewmedia.org/options/bnmlist
>
> BNM powered by Wessex Networks:
> http://www.wessexnetworks.com
>



-- 
Dr Alastair James
CTO James Publishing Ltd.

www.worldreviewer.com
Winner Yahoo! Finds of the Year
WINNER Travolution Awards Best New Online Travel Company 2008
"In a market increasingly crowded with new content and experience-led sites,
Worldreviewer stands out a mile. It has used exclusive editorial and
excellent tools to wonderful effect and ensured its commercial partnerships
are relevant to the target market."

Blogs: onewheeledbicycle.com, traveltelegraph.com

"Utinam logica falsa tuam philosophiam totam suffodiant!"