News for hackers. Stuff that matters.

Ask HN: Good OS X data modeling software?

I'm looking for something to help me visualize my data structure design. I've done the requisite Googling and haven't come up with much besides OmniGraffle, which is a little pricey ($100 US for Standard Edition) and not built specifically for this purpose.

In the old days I'd just fire up M$ Access and use that to show table names, attributes, and relationships. Currently I've resorted to pen & paper.

Anybody solved this problem before? HN community advice is always welcomed and appreciated!

( 20 comments | 9 points | on HN )
Re:Ask HN: Good OS X data modeling software? by tortilla on Sunday November 02, 2008 @11:01AM (#351421)
I usually just use pen and paper (my workflow works best this way), I also like OmniGraffle, but here are some others to check out:

http://www.aquafold.com/

http://www.sqlpower.ca/page/architect

http://www.dbvis.com/products/dbvis/

http://www.thekompany.com/products/dataarchitect

ERD Stencil (Rails) for Omnigraffle: http://graffletopia.com/stencils/318

Re:Ask HN: Good OS X data modeling software? by mcormier on Sunday November 02, 2008 @09:43AM (#351380)
You could do your modelling in xCode using a core data model. Just create a Core Data application in Xcode and play with the model file.

http://developer.apple.com/macosx/coredata.html http://developer.apple.com/macosx/images/CoreDataSimpleDataM...

Re:Ask HN: Good OS X data modeling software? by sant0sk1 on Sunday November 02, 2008 @10:12AM (#351393)
This could work, thanks I'll look into it!
Re:Ask HN: Good OS X data modeling software? by wenbert on Sunday November 02, 2008 @10:48AM (#351410)
I vote for pencil and paper ;-) you can erase! I do this and then directly create the sql in phpmyadmin or something similar -- for most of projects which are small.
Re:Ask HN: Good OS X data modeling software? by edw519 on Sunday November 02, 2008 @10:57AM (#351420)
you can erase!

And you're not limited by the preconceived notions of the software you're using. It's also surprising how quickly you learn something when you have to draw and erase it 5 times (vs. entering some data into someone else's app.)

for most of projects which are small

Large projects too. They're just a lot of small projects stuck together.

Re:Ask HN: Good OS X data modeling software? by wenbert on Sunday November 02, 2008 @08:25PM (#351803)
also I would like to point out that I love paper. I love notebooks with my daily notes in them. I love print-outs. I love storing paper. I love seeing my (ugly)handwriting in my notes. It makes me remember things and makes me understand faster than looking at the fonts in my monitor.
Re:Ask HN: Good OS X data modeling software? by wheels on Sunday November 02, 2008 @04:22PM (#351662)
I use a whiteboard and an 8 megapixel camera for backups. ;-)
Re:Ask HN: Good OS X data modeling software? by wenbert on Sunday November 02, 2008 @08:22PM (#351800)
I have tried using whiteboard. But i kept on erasing stuff and had no permanent records. My life was a mess when i used it (for about a week). so i went back to pencil and paper ;)

your 8 megapixel camera solves my problem. But i don't have one.

Re:Ask HN: Good OS X data modeling software? by tptacek on Sunday November 02, 2008 @11:52AM (#351455)
I recommend Graphviz, which is free:

http://www.pixelglow.com/graphviz/

Re:Ask HN: Good OS X data modeling software? by shaunxcode on Sunday November 02, 2008 @11:19AM (#351431)
DIA: http://live.gnome.org/Dia/

I think the darwinports page for it is currently down (actually the entire server may be down), but regardless dia rules! Saves as svg so it's really easy to write reverse engineering tools for your code base/database. When I say really easy I mean possible.

Re:Ask HN: Good OS X data modeling software? by mmelin on Sunday November 02, 2008 @10:37AM (#351405)
SQLEditor works very well, although a single license costs $79. Try out the trial. One awesome thing about it that it can parse a SQL dump of your existing database and create a visual model of the structure.

http://www.malcolmhardie.com/sqleditor/

Re:Ask HN: Good OS X data modeling software? by jawngee on Sunday November 02, 2008 @01:46PM (#351558)
You sir, are my new best friend.
Re:Ask HN: Good OS X data modeling software? by charlesju on Sunday November 02, 2008 @10:15AM (#351395)
I know this is not as advance as you would like, but I use Open Office Draw for my process flows and DB models and stuff.
Re:Ask HN: Good OS X data modeling software? by mwbrooks on Sunday November 02, 2008 @11:16AM (#351429)
You may want to glance at 'R' which is an open source alternative to 'S'. http://www.r-project.org/

'R' is used to manipulate data and graphically display the results. I've never used it myself, but I know it's used in my University's Computer Science department.

Re:Ask HN: Good OS X data modeling software? by jonhohle on Sunday November 02, 2008 @10:55AM (#351417)
as mcormier said, you can use Xcode's data modeling. There is also Umbrello, which either requires X11 or finding a recent native OS X build.

i don't have any experience with it, but also found ArgoUML (http://argouml.tigris.org/)

Re:Ask HN: Good OS X data modeling software? by river_styx on Sunday November 02, 2008 @12:24PM (#351486)
Visualization is for sissies. Directly editing SQL scrips in TextMate is the only way to go. :)
Re:Ask HN: Good OS X data modeling software? by mattdennewitz on Sunday November 02, 2008 @12:36PM (#351499)
handing sql scripts over to clients in the first stage of planning development is a great idea :)

so easy to read!

Re:Ask HN: Good OS X data modeling software? by drewcrawford on Sunday November 02, 2008 @03:20PM (#351618)
This is probably outside of your pricerange, but have you looked at Wolfram's Mathematica? I find it invaluable for all sorts of statistical data modeling.
Re:Ask HN: Good OS X data modeling software? by omahajoe on Sunday November 02, 2008 @09:58PM (#351861)
I'm not a techy but www.thebrain.com is the coolest visualization tool i've found and its free...but may not apply for what you're looking fore
Re:Ask HN: Good OS X data modeling software? by 1gor on Sunday November 02, 2008 @12:22PM (#351481)
Java UML tool like ArgoUML?